Hi all,
In my excel sheet I have about 50 rows and 7 columns.
I'm looking to open a work sheet for each row, with the name of each spreadsheet coordinated with the first column name.
I'm looking to organize a database, so that the master sheet will have all the names, numbers, emails, addresses etc. Then each worksheet will be an action/follow up sheet, of each person in each row.
I'm also wondering if there is a way to make the master sheet keep doing this, so if i were to add more rows in the master sheet it automatically opens a new worksheet for it.
Appreciate any help!
In my excel sheet I have about 50 rows and 7 columns.
I'm looking to open a work sheet for each row, with the name of each spreadsheet coordinated with the first column name.
I'm looking to organize a database, so that the master sheet will have all the names, numbers, emails, addresses etc. Then each worksheet will be an action/follow up sheet, of each person in each row.
I'm also wondering if there is a way to make the master sheet keep doing this, so if i were to add more rows in the master sheet it automatically opens a new worksheet for it.
Appreciate any help!