| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Variable worksheet name in offset
I am trying to use the offset function with a worksheet name that changes
based upon a drop down list: offset('worksheet name'!c1,$A$26,0) How can I replace 'worksheet name' with the contents of a cell that contains the results from the drop down list. I tried to use the indirect function but I keep getting errors. I am basically setting up a single chart that I can use to display info from various worksheets and particular rows on the woorksheets. Any help would be great. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Variable worksheet name in offset
Hi Dave
=OFFSET(INDIRECT("'"&A1&"'!C1"),$A$26) where A1 holds the worksheet name Note that the quotes are " ' " and " ' ! C1" -- Regards Roger Govier "Dave T" wrote in message ... I am trying to use the offset function with a worksheet name that changes based upon a drop down list: offset('worksheet name'!c1,$A$26,0) How can I replace 'worksheet name' with the contents of a cell that contains the results from the drop down list. I tried to use the indirect function but I keep getting errors. I am basically setting up a single chart that I can use to display info from various worksheets and particular rows on the woorksheets. Any help would be great. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Variable worksheet name in offset
Roger
Your suggestion worked like a charm. Thanks for your help. "Roger Govier" wrote: Hi Dave =OFFSET(INDIRECT("'"&A1&"'!C1"),$A$26) where A1 holds the worksheet name Note that the quotes are " ' " and " ' ! C1" -- Regards Roger Govier "Dave T" wrote in message ... I am trying to use the offset function with a worksheet name that changes based upon a drop down list: offset('worksheet name'!c1,$A$26,0) How can I replace 'worksheet name' with the contents of a cell that contains the results from the drop down list. I tried to use the indirect function but I keep getting errors. I am basically setting up a single chart that I can use to display info from various worksheets and particular rows on the woorksheets. Any help would be great. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I replace a worksheet with lists | Excel Worksheet Functions | |||
| Looking up a variable in one worksheet and copying information from another column to another worksheet?? | Excel Discussion (Misc queries) | |||
| Excel: Relative worksheet references? | Excel Discussion (Misc queries) | |||
| Activating a worksheet through use of a variable | Excel Worksheet Functions | |||
| Search/Match between 2 x separate Worksheets and populate result in third worksheet | Excel Discussion (Misc queries) | |||
Linear Mode
