| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying a formulae down a column that includes an INDIRECT
For example, in C1 I have a long formulae that includes multiple INDIRECT
references to B1 which is where I input a data figure - column B has data that is dragged and dropped between cells up and down that column (hence the reason for including the indirect) column C provides the answer. After setting up a formulae in C1 how can I copy this down column C and make the indirect move with it - currently the indirect always stays refering to cell B1 ???? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
| Lookup Table Dilemma | Excel Worksheet Functions | |||
| How to group similar column titles together???? | Excel Discussion (Misc queries) | |||
| Copying the contents of a column into a chart | Excel Worksheet Functions | |||
| Searching a column and copying rows | Excel Worksheet Functions | |||
Threaded Mode
