If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Need formula for sheet & cell reference
Help
Have a list of sheet names and want to create a formula to use sheet name as a reference in a formula. Have tried "Indirect" but haven't succeeded with that or any other. For example sheet names listed vertically i.e. inv1, inv1, inv3 etc. formula needed to refer to "sheet name"[Inv1] AND "cell reference"[g10] Have used SheetOffset in VBA but want to use actual sheet name, rather than offset. For this file it is not possible to use consolidation feature. Will appreciate any help. TIA Malcolm Hughes |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How can I format a cell with a link formula so an empty reference. | SteveG | General Discussion | 1 | September 16th, 2004 05:24 PM |
IF E3 & E10 = TRUE set this cell to "Yes", else set to "No" | Timothy L | Worksheet Functions | 5 | August 27th, 2004 02:28 AM |
Reset Formula to Use Cell Address Not Cell Name | Eli | General Discussion | 2 | August 17th, 2004 12:51 AM |
Question about Absolute reference formula | Maria | General Discussion | 3 | June 23rd, 2004 06:27 PM |
Formula help | Wally | Worksheet Functions | 6 | December 5th, 2003 12:18 PM |