| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copy formulas from rows & columns
i having many columns having different formulas. i want to coy all formulas
to next many rows of all columns. example col-A COL - B 1 =SUMIF((AA100:AA1000="AD"),(AB100:AB1000)) =COUNTIF(AA100:AA1000="AD",1,0) IF I COPY FROM ROW 1 TO 2, RANGES CHANGED TO AA101:AA1001. BUT I WANT SAME TO BE COPY TO THE BELOW ROWS. REQUEST YOUR HELP PLEASE. -PERANISH |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| automatically copy formulas down columns or copy formulas all the | Excel Worksheet Functions | |||
| Skip columns and copy formulas | Excel Discussion (Misc queries) | |||
| Copy Formulas when inserting rows | Excel Discussion (Misc queries) | |||
| copy formulas to cells absolute rows and variable columns | Excel Discussion (Misc queries) | |||
| Copy/Insert rows with formulas | Excel Worksheet Functions | |||
Threaded Mode
