Home |
Search |
Today's Posts |
#1
|
|||
|
|||
variable worksheet references
All - Having problems with creating an unusual reference. I have a workbook which contains a template that users will copy and rename as many times as they need to e.g. Analysis Template becomes Analysis 1, Analysis 2, Analysis 3, and so on. I've created a summary page which collects the highest level results from each of these worksheets (one row on the row per worksheet) - but am having problems telling excel which worksheet to go to find the value. What I need for this summary page is for Excel to recognize that I need 'Analysis ' and ID number depending on the row of the summary & '!Cell reference' - I could go through and do each row manually - but I am distributing this workbook to several different user groups each of which may have any number of different template copies - so it needs to happen automatically based on the number of copies they create. Any thoughts? Thanks - Matt -- mattbloodgood ------------------------------------------------------------------------ mattbloodgood's Profile: http://www.excelforum.com/member.php...o&userid=24999 View this thread: http://www.excelforum.com/showthread...hreadid=385267 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Making a file and worksheet reference into a variable.... | Excel Worksheet Functions | |||
variable to refer to "this worksheet"? | Excel Worksheet Functions | |||
Excel cell references to 2nd worksheet stopped working | Excel Worksheet Functions | |||
Replicating Formulas with Various Worksheet References | Excel Worksheet Functions | |||
Replicating Worksheet References in Formulas | Excel Worksheet Functions |