| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying a formula with multiple worksheets down rows and across co
I have the following formula:=IF('LC + CC'!B3="","",'LC + CC'!B3+'LC +
CC'!B3*F69+'Sales Price (2)'!B3*'Sales Price'!F70+'Sales Price (2)'!B3*'Sales Price'!F71+'Sales Price (2)'!B3*'Land Cost'!B14) Im trying to copy this down multiple rows as follows:=IF('LC + CC'!B4="","",'LC + CC'!B4+'LC + CC'!B4*F69+'Sales Price (2)'!B4*'Sales Price'!F70+'Sales Price (2)'!B4*'Sales Price'!F71+'Sales Price (2)'!B4*'Land Cost'!B14) Im also trying to copy across multiple columns as follows:=IF('LC + CC'!C3="","",'LC + CC'!C3+'LC + CC'!C3*F69+'Sales Price (2)'!C3*'Sales Price'!F70+'Sales Price (2)'!C3*'Sales Price'!F71+'Sales Price (2)'!C3*'Land Cost'!B14) Each time I try it Changes all of the formula. Any help is much appreciated:) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying multiple cells out of multiple worksheets at same time. | Excel Discussion (Misc queries) | |||
| Copying a formula from multiple workbooks down rows and across col | Excel Programming | |||
| Copying multiple rows to other worksheets (but amount of rows varies) - How? | Excel Discussion (Misc queries) | |||
| Copying a formula to multiple worksheets | Excel Worksheet Functions | |||
| Copying a Formula To Reference Multiple Worksheets | Excel Worksheet Functions | |||
Threaded Mode
