Dilemma is as follows;
Sheet 1 Table 1:
I need to past Column A, B, C, and D into the 1st blank row in Sheet 2 IF a date is entered in column D.
If a date is then later entered into Column E, I need to again paste Column A, B, C, and E (the E date would then gow into Row D on Sheet 2).
Sample spreadsheet attached.
Bookmarks