Formula copy paste down in a sheet but change row letter incre
Small Error
This is correct
Copy this to B6 and Drag it Down B and paste
=INDIRECT("'open data file'!"&ADDRESS(COLUMN()+5,(COLUMN())+ROW()-5))
In C6 Paste this and Drag Down C and Paste
=INDIRECT("'open data file'!"&ADDRESS(COLUMN()+5,(COLUMN())+ROW()-6))
You will notice that the only difference is the -5 has become -6
This Minus 1 has to be done every time you move 1 column along.
I am sure that there will be a Smarter way But this works
Best
Stew
"stew" wrote:
Hi Mike,
I think this is what you are after
Copy this to B6 and Drag it Down B and paste
=INDIRECT("'open data file'!"&ADDRESS(COLUMN()+5,(COLUMN())+ROW()-5))
In C6 Paste this and Drag Down C and Paste
=INDIRECT("'open data file'!"&ADDRESS(COLUMN()+4,(COLUMN())+ROW()-5))
You will notice that the only difference is the +5 has become +4
This Minus 1 has to be done every time you move 1 column along.
I am sure that there will be a Smarter way But this works
Best
Stew
"Mike" wrote:
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!!!
|