Hi - really grateful if someone can help me as this is all a bit beyond me...
I have created a sheet which contains events which are happening during various months next year.
What I would like to do is use a formula/code that means that if the 'MONTH' column contains the word January then the row will copy across to the sheet which contains just the events for January.
I would then want to repeat this for each month so I can have 12 individual sheet in addition to the main one with listings broken down by month.
The way I have done it on the attached sheet is by filtering the main sheet and then pasting onto a new sheet but the sheet is worked on by many people, some of whom forget to do this so it would be much easier if it could be done automatically.
Can anyone help??
Thanks
Bookmarks