|That's great news thanks, I have a page on a work booked called "Job Sheet" (job sheet is completed when we take a call reporting a break down) in this page I have various cells which I have drop down boxes |
The first is the site location if I select a certain site from this box lets say "Petershill"
then the next drop down box called asset will only show me the asset number at Petershills (these are pieces of catering equipment)
when I select the asset number the next for cells in the job sheet are completed using Vlookup
then I have a large area on the job sheet which details the work required. all this is currently working fine.
What I need to do is take this information from the Job Sheet and place it on spreadsheet called "Full list"
full list is all jobs that have been created since the start of the contract.
Once the infomation has been sent to Full List I want the Job sheet to clear ready for the next call and start again
end result I have a spreadsheet updating itself when a Job Sheet is completed
Really hope you can help, thank you in advance