| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sheet name needed for formula
in VBA sheet is sheet8
how can this appear in =index('sheetname'! c,(row()-1)*8+2) macro is currently selecting sheets name as appears on the tab but this changes every day. I need to use vba identity within this formula for it to work. James |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula needed to bring values to another sheet | Excel Worksheet Functions | |||
| carry over data to other sheet - help needed | Excel Discussion (Misc queries) | |||
| Help Creating a points tracking sheet needed | Excel Discussion (Misc queries) | |||
| Help needed! - How do I save a filtered sheet? | Excel Discussion (Misc queries) | |||
| Time Sheet Calculation Help Needed! | Excel Worksheet Functions | |||
Threaded Mode
