I have an actions register that needs updating on a weekly basis. Rather than manually cutting and pasting for mailouts, I'd like to be able to run a macro each week that will select the rows closest to today's date in the master list and move them into a different worksheet for mailing.

I've recorded macros before, but after several attempts I now think I need to do it with VBA and I'm a complete novice at that. I've tried using and editing some examples from various forums, but none of them do what I want - possibly because I don't know what I'm doing..... I'm planning to do some online courses, but would really appreciate some help now.

If it helps, the sheet I'm working from is labelled Action Register, the date is in column K, and the sheet I want the rows to go to is labelled Weekly updates - any help really appreciated!