as for the first part:
sequence is: start in the bottom-left corner of the sheet, move right 35 (to column 36th column - AJ). Move up till the first not-empty cell is found. While the original sequence was:
start in the bottom-left corner of the sheet, Move up till the first not-empty cell is found (you are still in column A).Move right 35 (to column 36th column - AJ) - but it's not necessary the last filled cell in this column.
Of course you can do this as Artik suggested starting immediatelly at the bottom of column AJ:
As for the copying this cell, (say it's AJ100) I understand that you want to copy it to range AJ2:AJ99 (from the 2nd row to current row -1) and into next 10 columns so also to AK2:AT99.
If that's the case try:
or
.
Bookmarks