Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Populate excel sheet based on values in a separate sheet | Excel Discussion (Misc queries) | |||
Create 2 sheets, from one, based upon value of one column | Excel Worksheet Functions | |||
CREATE NEW WORKBOOK AND SHEETS BASED ON COLUMN DATA | Excel Worksheet Functions | |||
how do I create a pivot table based on multiple sheets | Excel Discussion (Misc queries) | |||
Count unique values and create list based on these values | Excel Worksheet Functions |