Hi,
I am combining all the sheets in one but would like to grab the tab name as a new column "grouping" so that I know which row is from which tab.
How do I attach the sheet name as a new column?
Thanks,
Betty
Hi, @Ylin0615
Please see that:
@Ylin0615
you have to do the following steps.1 - open the spreadsheet that has all the tabs and choose the sheet names option
As it is more than one tab, you will have to make a batch macro that will receive the fullpath and the name of the tab to be able to append it in a single worksheet
