Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Specifiying the worksheet name in a cell
I have several different xls with multiple worksheets in each I have written the report that generates the data but I must manually go into each field and change the worksheet reference each time the sheet changes. Could I have an additional colum which specifies which sheet to pull data from? Then in each function sepecifiying how to create the value needed the worksheet referance updates too. Let me know if I need to clarify. -- adiss ------------------------------------------------------------------------ adiss's Profile: http://www.excelforum.com/member.php...o&userid=33939 View this thread: http://www.excelforum.com/showthread...hreadid=537156 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Specifiying the worksheet name in a cell
You can use
=INDIRECT("'"&A1&"'!H10") which pulls the value in H10 from the sheet specified in A1. -- HTH Bob Phillips (remove nothere from email address if mailing direct) "adiss" wrote in message ... I have several different xls with multiple worksheets in each I have written the report that generates the data but I must manually go into each field and change the worksheet reference each time the sheet changes. Could I have an additional colum which specifies which sheet to pull data from? Then in each function sepecifiying how to create the value needed the worksheet referance updates too. Let me know if I need to clarify. -- adiss ------------------------------------------------------------------------ adiss's Profile: http://www.excelforum.com/member.php...o&userid=33939 View this thread: http://www.excelforum.com/showthread...hreadid=537156 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Specifiying the worksheet name in a cell
Thats just what I needed thankyou! -- adiss ------------------------------------------------------------------------ adiss's Profile: http://www.excelforum.com/member.php...o&userid=33939 View this thread: http://www.excelforum.com/showthread...hreadid=537156 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
fill cell with color from other worksheet | Excel Discussion (Misc queries) | |||
Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
Conversion of Cell Contents into a Functional Worksheet name ? | Excel Worksheet Functions | |||
macro help | Excel Discussion (Misc queries) | |||
Refrencing another cell in a worksheet that "could" exist | Excel Worksheet Functions |