| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I create formula that allows the worksheet ref. to be c
If A1 has the sheet name and B1 has the column letter, you can use
=INDIRECT("'"&A1&"'!"&B1&"10") to return the value in Row 10 of the column named in B1 on the worksheet named in A1. "DMD1236" wrote in message ... THANKS CHIP!! Now I am being just greedy.....How do I allow the"C" portion to be user defined as well? Imbed another Indirect formula?? Appreciate your help! "Chip Pearson" wrote: If I understand correctly, you can use the INDIRECT function for this. For example, if cell A1 has a sheet name, the following formula will return the value in cell C10 of the worksheet named in A1. =INDIRECT("'"&A1&"'!C10") "DMD1236" wrote in message ... Would like to allow user to be able pick amongst Multiple worksheets via in-cell dropdown and formulas to change. IE - what do I have to do to make =SHEET1!D5 point to a cell and allow user tyo make it Sheet2! or Sheet 3! etc? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| create a new worksheet with the same formula | Excel Discussion (Misc queries) | |||
| Formula changes to renamed cell name. I want to keep it from chang | Excel Discussion (Misc queries) | |||
| create formula another worksheet if value | Excel Discussion (Misc queries) | |||
| how can create a formula to add data from 1 worksheet to another? | Excel Discussion (Misc queries) | |||
| how do I chang the start point for my next row? | Charts and Charting in Excel | |||
Threaded Mode
