Consolidating data from multiple worksheets

Hello All,

I need some help.

I have a workbook which has data in multiple tabs and also I have a macro which consolidates data from these tabs to one tab.(Master Tab name)

Everytime whenver I have to execute this macro first I have to delete the master tab and then execute the macro.

Is there a possibility where without deleting the tab can the data be consolidated.

Example: if I run the macro the data is consolidated, then I add data in tabs and run then re run the macro It should leave a row and then add the new data to master tab.

Also a last request can pivot be build on the master tab and auto refreshed when the macro is executed

I have attached the spreadsheet

Thanks in advance for all your support

Kamal

Originally Posted by kt090678

Example: if I run the macro the data is consolidated, then I add data in tabs and run then re run the macro It should leave a row and then add the new data to master tab.

Wouldnt this result in duplicate data in your tab?

Just use this small code -

Please Login or Register  to view this content.

I have put this code in a blank module (Right click on Microsoft Excel Objects and select Insert->Module. Copy the code over).

You might have pressed the "ESC" key while running the macro. Click on END on this popup that you get and start running it again.

Ok, i understand what you are talking about. I used to face this error earlier as well. This problem is due to a memory shortage in your system. Hence, it asks you to keep clicking the "Continue" button.

Try doing this. Close your workbook without saving the changes, then close all other excel files (if open). Open excel again from start, then copy the code over to your file and run it again. You should not face this problem.

Change this line of code from

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.