jholly1984
New Member
- Joined
- Sep 29, 2020
- Messages
- 15
- Office Version
- 2016
- 2010
- Platform
- Windows
Hi everyone,
I am having an excel automation issue that I am hoping someone can help with.
Problem: Being able to automatically add a column and fill the column in with its associated sheet name for multiple sheets at the same time.
Context:
The workbook contains a large number of sheets named by category:
Tab 1 = Category 1
Tab 2 = Category 2
Tab 3 = Category 3
Tab 4+ = Etc.
We want to be able to add a column for every sheet at one time that pulls the tab name into every row as an identifier.
Current State:
Sheet Name 1 = Laptops
Columns = Keyword, Rank, URL
Sheet Names 2+ = Category Name 2+
Columns = Keyword, Rank, URL
Expected Output:
Sheet Name 1 = Laptops
Columns = Keyword, Rank, URL, Category/Sheet Name
We are hoping to be able to insert a macros or formula that will plug the sheet name in across 100+ sheets vs having to do it manually.
Thank you for your time.
I am having an excel automation issue that I am hoping someone can help with.
Problem: Being able to automatically add a column and fill the column in with its associated sheet name for multiple sheets at the same time.
Context:
The workbook contains a large number of sheets named by category:
Tab 1 = Category 1
Tab 2 = Category 2
Tab 3 = Category 3
Tab 4+ = Etc.
We want to be able to add a column for every sheet at one time that pulls the tab name into every row as an identifier.
Current State:
Sheet Name 1 = Laptops
Columns = Keyword, Rank, URL
Sheet Names 2+ = Category Name 2+
Columns = Keyword, Rank, URL
Expected Output:
Sheet Name 1 = Laptops
Columns = Keyword, Rank, URL, Category/Sheet Name
We are hoping to be able to insert a macros or formula that will plug the sheet name in across 100+ sheets vs having to do it manually.
Thank you for your time.
Last edited by a moderator: