On the attached, what would be the proper VBA code for 'when cell E6 is not blank, cut the total record (A6:E6) and paste it to the next available row on the Archive tab'?
Adding how to re-sort cells A3:E7 on the "Input Log" tab by Name (the data1 field) so there is then not a blank would be even better!
Thanks a lot in advanced.
Bookmarks