Good evening,
I have a sheet with data starting in row 7
Each row below will record data but the cell in column A will have a formula.
I am trying to create a macro that will copy the data from the last row (say row 11) to the next row (row 12).
More specifically, I only need to copy the formula in the column A cell and the formats of the cells in column A to the last column with data.
At the moment columns A to I have data but more may be added but only "A" will have a formula.
All answers gratefully received.
I have a sheet with data starting in row 7
Each row below will record data but the cell in column A will have a formula.
I am trying to create a macro that will copy the data from the last row (say row 11) to the next row (row 12).
More specifically, I only need to copy the formula in the column A cell and the formats of the cells in column A to the last column with data.
At the moment columns A to I have data but more may be added but only "A" will have a formula.
All answers gratefully received.