LinkBack URL
About LinkBacks
I need to create spreadsheets based off of 240 store numbers so I can send employee list to be verified. Is there a formula or function I can use as opposed to using a pivot table and clicking each one to create a new spreadsheet?
I need to create spreadsheets based off of 240 store numbers so I can send employee list to be verified. Is there a formula or function I can use as opposed to using a pivot table and clicking each one to create a new spreadsheet?
Formulas cannot create sheets. VBA can be used to create new sheets off of unique values in a specific column.
------
Here's a macro for parsing rows of data from one sheet to many sheets named for the same values in a specific column.It not only can parse the rows, it can create the sheets if they are missing. There is a sample sheet there where you can test this out.
------
'SHEET1 TO MANY WORKBOOKS
Here's a macro for parsing rows of data from one sheet to many workbooks based on one column, workbooks named for the same values in that column.My macro names the workbooks for values in the column PLUS today's date, you can take a stab at removing the date part...or leave it in, it's a good technique.
Last edited by JBeaucaire; 12-26-2019 at 04:04 PM.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks