Hi,
I have a spreadsheet with rows of data, I would like to insert a column, ("H:H", enter a formula in ("H1", then copy and paste that formula down all of the rows that contain data in other columns. The problem is that the number of rows is different in each spreadsheet so the bottom row in the paste area needs to be a variable.
I have a macro which will find the first blank cell in a column which would work but I'm hoping there is a far more efficient way of doing it.I have recorded a macro to play around with various key strokes such as Ctrl Shift and down arrow etc. but it doesn't seem to work.
Thanks in advance
I have a spreadsheet with rows of data, I would like to insert a column, ("H:H", enter a formula in ("H1", then copy and paste that formula down all of the rows that contain data in other columns. The problem is that the number of rows is different in each spreadsheet so the bottom row in the paste area needs to be a variable.
I have a macro which will find the first blank cell in a column which would work but I'm hoping there is a far more efficient way of doing it.I have recorded a macro to play around with various key strokes such as Ctrl Shift and down arrow etc. but it doesn't seem to work.
Thanks in advance