Hi Mr Excel,
Im faced with a mind numbing, finger crackingly tedious task and it would make my week if someone could save me with a little trick.
I need to copy/paste an array of cell's throughout a workbook. This array references a master array, such that if the data in the master array changes it should automatically change every other array.
So basically my secondary arrays contain "=A1"... and so on, referencing back to the master array. The only way I know how to copy the references without typing it over and over is to "F4" lock each cell in the secondary array and copy/paste it. But the process of "F4" is huge as I have like 500 cells to do.
Is there a trick please.
Thanks
Mathias
Im faced with a mind numbing, finger crackingly tedious task and it would make my week if someone could save me with a little trick.
I need to copy/paste an array of cell's throughout a workbook. This array references a master array, such that if the data in the master array changes it should automatically change every other array.
So basically my secondary arrays contain "=A1"... and so on, referencing back to the master array. The only way I know how to copy the references without typing it over and over is to "F4" lock each cell in the secondary array and copy/paste it. But the process of "F4" is huge as I have like 500 cells to do.
Is there a trick please.
Thanks
Mathias