Consolidate multiple tabs into a "Summary" one and ovewrite past data

**dim06** · 04-02-2012, 07:24 AM

Hello,

I have this piece of code:

HTML Code:

but it consolidates (dooes not overwrite over the past data) until it reaches the A65526.

Could someone help me please to modify this code and make it copy-paste from A4 in the Summary tab and finish pasting in the last row where the data from the Worksheets end? My desired consolidated data will be from A4 to T(Last Row Number).

Thank you very much!

**royUK** · 04-02-2012, 07:33 AM

This teslls the code to copy to the next empty row

Please Login or Register  to view this content.

Your code needs to clear previous data. You don't use two of the variables that you have declared

**dim06** · 04-02-2012, 07:40 AM

Thanks, I have inserted Dim LastRow As Long as I was trying to copy-down some formulas from X2 to all the consolidated data. How can I fix the above code to clear my previous data? Thanks a lot

**royUK** · 04-02-2012, 07:45 AM

This will clear the summary sheet

Please Login or Register  to view this content.

There's a lot more for you to consider. Do the sheets each have header rows? If they do then you need to remove the header row by resizing the copied data. I have posted examples how to do this