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.
--
Nothing in life is ever easy - just get used to that fact.

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

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.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"KennyD" wrote in message
...
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.
--
Nothing in life is ever easy - just get used to that fact.

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

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.
--
Nothing in life is ever easy - just get used to that fact.


"Don Guillett" wrote:

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.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"KennyD" wrote in message
...
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.
--
Nothing in life is ever easy - just get used to that fact.

.