populate a spread sheet from another one

May 24, 2009 at 02:16:53
Specs: Windows Vista
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

See More: populate a spread sheet from another one

Report •

May 24, 2009 at 06:46:57
This a relatively simple operation that can be done with some VBA coding to copy specific cells - or an entire range - from one sheet to an empty range on another sheet.

It could be as simple as this...

Sub PopSht()
'Find Next Empty Row on Full List
   nxtRow = Sheets("Full List").Range("A" & Rows.Count).End(xlUp).Row + 1
'Copy Data
  Sheets("Job Sheet").Range("A1:E11").Copy _
    Destination:=Sheets("Full List").Range("A" & nxtRow)
'Clear Job Sheet
    Sheets("Job Sheet").Range("A1:E11").ClearContents
End Sub

...or it could be considerable more complicated if specific data has to be copied to specific locations, etc.

Report •

May 24, 2009 at 10:41:11
thanks for that I will give it a go, As it happens I do need to fill specific cells for example location will go to column A , Asset will go to Column B etc does that change things.

many thanks again your help is greatly appreciated

Report •

Related Solutions

Ask Question