Hi,
Thanks in advance since i am pretty new to Excel VBA.
I have a excel file that contains multiple tabs with the same header but The # of rows can vary).
What i want to do is to merge all the data from each tab together into one tab. When copy and paste, paste as link so if a user changes the data in first tab it will reflect in "stacked master tab". For example, copy all data in first tab (include header) into a new tab, then copy the second,third...etc(without header) all as link.
Thanks in advance since i am pretty new to Excel VBA.
I have a excel file that contains multiple tabs with the same header but The # of rows can vary).
What i want to do is to merge all the data from each tab together into one tab. When copy and paste, paste as link so if a user changes the data in first tab it will reflect in "stacked master tab". For example, copy all data in first tab (include header) into a new tab, then copy the second,third...etc(without header) all as link.