I'm trying to make weekly schedules from a monthly schedule of routine tasks . Some tasks get done once a week, others get done daily.
Is it possible to use advanced filter to copy tasks listed as 'daily' on the Month worksheet to several loctions (each day) on the Week worksheet?
I have tried but can't get it to work.
Failing that, would it possible to select a row of headings as criteria and copy to a location several rows down from the headings? (If so, how?)
Any and all help much appreciated!
Bookmarks