Copy and Paste 3 sheets to 1

Hi

I am building a report for work. I wish to copy and paste data from 3 different sheets into 1 to form a final report. The problem is, each month there will be a different amount of lines to copy across. Is there a way to write a macro that will only copy the cells from row 2 or 3 down but only rows that have text in them?

also how do I get the lines to copy across to the line below where the last sheets copy ended?

I hope this makes sense.

Hi

what if my workbook has many sheets? I want the data in sheet named "SC" and the data in sheet "PR" to consolidate into "Rotables"

Right now it isnt working and just returns "Type" with the dotted line under and then "Type" with another dotted line under.

Also does it matter if the data is filtered? will it only copy the filtered data or will it copy all the lines?

Maybe see this post:

Error in VBA

Please Login or Register  to view this content.

Regards, TMS

I am struggling to get the consolidation tool to work, i specify the ranges and then click okay and it does nothing?

Hi

so here is a dummy workbook with my problem.

There are other tabs in the original worksheet, but these are the ones i need work on.

The goal is to filter by "Rotable" in "PR" and "SC" and then consolidate all the rotable lines in the "Rotable" sheet. The same must then be done for "Non-Rotables" and then finally to do some more filtering in the "Rotable" and "Non-Rotable" sheets respectively, once the filtering is done, they should be pasted into the "Final" worksheet.

Preferably these should be written in several Macros, so that small changes can be made in between stages manually.

Also, there is alot more data than I am revealing here, '000's of lines for each of the SC and PR sheets.

OK, try the following code (in a standard module). It will take all the cells on sheets PR and SC and copy them to sheet Final.

It starts on Row 1 but you can adjust that if necessary.

Please Login or Register  to view this content.

Regards, TMS