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!!!