Copy an =Indirect formula

[rfinnegan]

Hi All:

I'm using the formula below to import data from a workbook that changes monthly (e.g. MarchCumulative, AprilCumulative, etc) and need to copy the formula to about 150 rows and 50 columns. I want the 'y70' portion to change to y71, y72, etc when I copy it down and z70, aa70, etc. when I copy it to the right.

I'm trying to keep this format, as I'm expanding a current worksheet in which this formula was used. I don't recall how I managed to fill in all the other cells properly, but I'm sure it wasn't changing each individual cell.

=INDIRECT($M$4&"Cumulative"&"!y70")

Thanks in advane

 

[rfinnegan]

Answered my own question, but would be interested in hearing other solutions, as I', a novice and I'm sure my solution wasn't the most elegant.

Here's what I did -
I created a column to the far right (BX) and numbered it 1-1000. Then used the following formula. The BX## changed as I copied the formula down. As for the "c" portion, I'm changing those by hand (first row only) before I copy it down.

=INDIRECT($M$4&"Cumulative"&"!Y"&BX11