| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I use a formula to give me a cell reference in excel?
I want to be able to copy the following formula sequence down an excel sheet:
='By Name'!A2 ='By Name'!A5 ='By Name'!A8 .... But excel will not recognise the sequence. Can I a) Do something so it will recognise it and copy it or b) Make the cell references the result of a formula e.g. ='By Name'!A(B1), where B1 contains the reference I need. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 Formula cell reference colours (colors) | Setting up and Configuration of Excel | |||
| how give excel cell red color if value above range? | Excel Discussion (Misc queries) | |||
| Excel formula-cell reference not working | Excel Worksheet Functions | |||
| Can I place a formula/cell reference in the Header/footer Excel | Excel Worksheet Functions | |||
| how to give cell reference using Combo Boxes in Excel? | Excel Discussion (Misc queries) | |||
Threaded Mode
