| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copying formulas forward and have the column refference move backw
I need a formula that I can copy forward and will move the coulum refrence
backwards ie, the data I have is in colums G,F,E,D,C,B,A and I need it referenced in another sheet A,B,C,D,E,F,G. So A=G,B=F, C=E and so on It is a simple cell reference but it is for a very large amount of data, so I need a formula that will be able to update the colulm refrences going backwards when it is copied across the row. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying a Column of Formulas between Excel Files | Excel Worksheet Functions | |||
| Bring Forward Balances and Formulas in a Spreadsheet | Excel Worksheet Functions | |||
| copying a column of cells containing formulas without them changin | Excel Discussion (Misc queries) | |||
| Copying formulas to end of Column | Excel Discussion (Misc queries) | |||
| Copying Formulas From One Column To Another?? | Excel Worksheet Functions | |||
Threaded Mode
