Use sheetname as a new column

[Ylin0615]

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 

[flying008 · Accepted solution]

Hi, @Ylin0615 

Please see that: 

[geraldo]

@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