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.