Hi all,
I need to drag a formula e.g.
=Database!A1
down across a set of merged rows. I wish the formula to automatically update by one row at a time as I drag it down e.g. A2, A3 etc but instead it naturally references the number of merged rows (10 in all) it has been dragged over.
Is there an easy way I can manage this issue? Or, alternatively, could anyone provide me with the macro code which would automatically insert 9 blank rows between each of a set of row entries which I can then merge into single rows?
Many thanks for your help,
Freddie
I need to drag a formula e.g.
=Database!A1
down across a set of merged rows. I wish the formula to automatically update by one row at a time as I drag it down e.g. A2, A3 etc but instead it naturally references the number of merged rows (10 in all) it has been dragged over.
Is there an easy way I can manage this issue? Or, alternatively, could anyone provide me with the macro code which would automatically insert 9 blank rows between each of a set of row entries which I can then merge into single rows?
Many thanks for your help,
Freddie
