| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy formula down in rows but change column increments
I am trying to copy and paste a Range B6-O11 in the same sheet numerous
times. The formulas in the range =Open Data File!C$7 thru =Open Data File!C$46 When I copy and paste the range down the same sheet I need the C to change to D then on the next paste change to E and so on with each time I paste the Range. In the sheet Open Data File, new data will be entered in each column C, D, E, F, G and so on in rows 6 thru 46. I am trying summarizing that data in each column on another sheet. But each time I copy then paste the range the column in all formulas in range noted above stay a C... Your help is greatly appreciated!!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I copy a formula with the cell increasing by increments? | Excel Discussion (Misc queries) | |||
| How do I complete increments of time in column A by say 9 min? | Excel Discussion (Misc queries) | |||
| copy formula down a column and have cell references change within formula | New Users to Excel | |||
| how do i put increments in the row or column numbers? | Excel Discussion (Misc queries) | |||
| copy a formula that does not change the column or row number? | Excel Discussion (Misc queries) | |||
Hybrid Mode
