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
Bookmarks