rolo
Member
Hello, when I consolidate many sheets using append (1 sheet = 1 table)
1. In the final consolidated table: is there any way to have a new column that shows sheet name?
2. Or new column that shows some cell value?
For example: consolidate 4 sheets > North, West, South, East
So in final consolidated table, I will need a new "Region" column that can show sheet name for each record
I will appreciate your help, thanks!
1. In the final consolidated table: is there any way to have a new column that shows sheet name?
2. Or new column that shows some cell value?
For example: consolidate 4 sheets > North, West, South, East
So in final consolidated table, I will need a new "Region" column that can show sheet name for each record
I will appreciate your help, thanks!