Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi,
I come across small problem that I can't copy formulae for relative address reference to move every 4 cells downwards. For instance, I have a table as follows : A B C CODE PROD_A PROD_B 1 AA 100 150 2 AB 200 2000 3 AC 300 600 Formulas relative to the table to be copied : +A1 +B1 +A1 -B1 +A1 +C1 +A1 -C1 After copy formulas, I want following ref. so on and so forth : +A2 +B2 +A2 -B2 +A2 +C2 +A2 -C2 How can I do that without my own manipulations ? I tried hilited the area but the formulas jump 4 cells forward. Much obliged if a simple solution can be given. Rgds, Frankie |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
copying formulae along rows. | Excel Discussion (Misc queries) | |||
copying formulae | Excel Worksheet Functions | |||
copying and pasting excel formulae | Excel Worksheet Functions | |||
Copying a formulae down a column that includes an INDIRECT | Excel Discussion (Misc queries) | |||
when copying formulae from one cell to another it does not work | Excel Worksheet Functions |