Hello Everyone!! Please I need your help.
I want to copy some data from a column J starting from a specific cell, and concatenate it data from another Column L starting from a specific cell, and save the results of the concatenated data to column U starting from a specific cell. Please note that all this is done dynamically. So the starting cell for column J, L and U is the last row index +1 for column P. Again please note that the number of rows in column p is different from the number of rows in column J, L and U. for instance column P might have 700 rows while others have 3000 rows, though this is not always the case as the number and position of rows vary daily. so the nos of rows are not static its always dynamic, but the starting row to copy data and concatenate for both column J and L is always the last row +1 of column p and the starting row to paste concatenated data on column U is the last row +1 of column p