Hi,
I am looking for the VBA code that will copy non empty cells from the dynamic range column "N2:N" and paste values to the bottom of data in column A named "Record ID" within the table named "RecordsDate" which has the range A2:E100.
The column B "Date" in the Table contains VLOOKUP formula that search column A values and returns values from another worksheet. The same formula is in all cells in range B1:B100.
At the moment there are i.e. 48 records in column A.
The codes I found are adding lines below the table to fully empty lines A101,A102...., which are out of the formatted table range, and are not "vlookedup".
My ideal is the formula that will update (copy and paste) the records within the table range and find the first empty cell in column A i.e. A49
As alternative solution would be to keep the Table with the range that has non empty records in column A. In this case the macro should add records in column A, copy formula in column B and expand Table range across the columns A:E.
I am looking for the VBA code that will copy non empty cells from the dynamic range column "N2:N" and paste values to the bottom of data in column A named "Record ID" within the table named "RecordsDate" which has the range A2:E100.
The column B "Date" in the Table contains VLOOKUP formula that search column A values and returns values from another worksheet. The same formula is in all cells in range B1:B100.
At the moment there are i.e. 48 records in column A.
The codes I found are adding lines below the table to fully empty lines A101,A102...., which are out of the formatted table range, and are not "vlookedup".
My ideal is the formula that will update (copy and paste) the records within the table range and find the first empty cell in column A i.e. A49
As alternative solution would be to keep the Table with the range that has non empty records in column A. In this case the macro should add records in column A, copy formula in column B and expand Table range across the columns A:E.
