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.
Bookmarks