Hi everyone i have a slight problem in a project i am working on.
Main list sheet is where all data is copied to.
I have monthly named sheets and these are changed year to year.
on closing of the sheet i need all the data on main list to be copied into correct months due to date being col A
but data must remain in main list and only be copied into the others.
I have been searching the forum for hours but unable to find a solution.
hope someone can figure this out using Excel 2013
Also after data copied over, then any fresh data must follow after the last entry not overwrite
thank you all in advance
regards Steve
Bookmarks