populate a spreadsheet

May 14, 2009 at 10:25:11
Specs: Windows Vista
My client needs to keep records of all job sheets, the job sheets are populated using cells i have already set a validation list in. Once the job is complete i need the job sheet to be cleared but the data recorded (sent to) in to a spreadsheet (the next avalable row) and so on. Can this be done?

Thank you

See More: populate a spreadsheet

Report •

May 14, 2009 at 12:29:46
Yes, it can probably be done, but we'd need a lot more detail than you have provided.

It sounds like a macro will be required, but we don't have near enough information to suggest any code.

Report •

May 15, 2009 at 06:56:37
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

Report •

Related Solutions

Ask Question