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



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.

Don Guillett

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.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question