| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula copy paste down in a sheet but change row letter increment
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!!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why do dates change when I copy/paste into another sheet? | Excel Discussion (Misc queries) | |||
| How do I copy formula but only increment certain ranges? | Excel Discussion (Misc queries) | |||
| Date copy & increment formula | New Users to Excel | |||
| fairly easy (i thought) copy and paste cells, increment by 17 accross | Excel Discussion (Misc queries) | |||
| fairly easy (i thought) copy and paste cells, increment by 17 accross | Excel Discussion (Misc queries) | |||
Threaded Mode
