Create New Sheets and Name Them Based on Values in another sheet

  • Thread starter Thread starter KennyD
  • Start date Start date
K

KennyD

Hey everyone.

I have seen several different posts on these different topics, but I need to
combine them all. Here is a brief summary of what I need to do.
I have a sheet that has a list of ID#'s on it. I have setup a formula to
lookup the names associated with the ID #'s. For each set of ID#'s, I have
to create a copy of a generic calculation sheet that I have setup to run a
set of calculations on. NOTE: This generic sheet has some very detailed
lookup functions, as it is looking up detailed sales information, and will be
based on the ID#. So, I need to create copies of the generic calculation
sheet, rename the new copies based on the names associated with the ID#, and
change the cell reference of cell C3
("=ROUNDDOWN((INDEX(Sheet_2!$A$2:$B$100000,1,2)),0)" to
"=ROUNDDOWN((INDEX(Sheet_2!$A$2:$B$100000,2,2)),0)" and then to ....3,2)),0)
....4,2)),0), etc.
 
There is probably a better way
If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.
 
Thank you so much for the quick reply. I don't know how easily I can send it
because the file type is sooooo large (>30MB). I will try to send it via
gmail, but I don't know if it will send. Thanks again for your help.
 
Back
Top