I have a workbook that contains about 265 vehicle data worksheets. Each uniquely numbered vehicle has it's own worksheet with detailed information about that vehicle. Every vehicle page is identical, accept for the data stored in it. These pages are setup in rows and columns of data, but not in a line-by-line list. One of these pages is a list of all of these vehicles with certain cells of information that i need to pull over from each of the individual vehicle workbooks. I've been trying for days now to set up a loop to bring this information from each individual page to this line-by-line list with little to no success.
Here is an example of what I am trying to do.
First vehicle on the list is vehicle;
A-01 (vehicle number, not cell reference) , I want the VBA code to go to A-01's worksheet and pull data from cells "B30", "B18", "B9", "B12", "B15", "B21", "B33", "B27", "J30", "F24", "H24", "D18". Then paste that data back to a row in the list of vehicles into cells "C7", "D7", "E7", "F7", "G7", "H7", "I7", "J7", "K7", "L7", "M7", "N7", in that order.
Then I want it to go to vehicle A-02 (next worksheet) and copy the data from the same set of cells (B30, B18, B9....etc.) and copy that to the next row on the list worksheet, Then go back and do the same thing for vehicle A-03, then for A-04, then A-05........untill the end of the list.
I can get the data from the first worksheet (vehicle A-01) but I can't figure out how to get the VBA to go to the next worksheet to get the next set of data and paste it.
I have tried a For All loop with some success, but there are 4 or 5 worksheets that I want it to skip over because they contain data that is not relevant to the worksheet I am trying to build.
One other thing I should note, currently the first page contains the data (entered manually) in a table. I am trying to get VBA to paste the data into that table.
I hope this is clear. I've tried to describe it to the best of my ability. Thanks for any help you can offer.
I have uploaded a small sample of the list with what I would like it to look like after running the macro and updating all of the fields.forum.ozgrid.com/index.php?attachment/70701/