Please can you help with the attached file.
I would like to copy & paste special the values on sheet 1 into sheet 3
Sheet 1 Range B9:S108
Sheet 3 starting with B9 and onward
However I only wish to export lines which have an end date in column N, the lines which do not will then shift up the page towards B9 etc
The idea is to do this once a week so that in sheet 3 old lines are added and used as an archive