midfieldgeneral11
Active Member
- Joined
- Feb 11, 2004
- Messages
- 464
Hello can you help?
I need to write a macro which is hard for me but could be easier for all you excel wizards.
Please see the able below which is a table containing who is on Holiday within my Department for the different Months.
This spreadsheet is a download from a system but the Months are not split out and what I want is to split out every time there is a month change.
This table is just showing the first column but the range I need to cut will always be from A to AM
I have a list of people as listed below which starts at January 2007 and goes down and then starts at February 2007 and then restarts at each month till December.
What I need is?
To be able run a macro to cut or copy all information from the January cell to the end of the names/start of the next month. This may change so therefore it may not be A3 –A11 could be A5-A13. So I need the macro to know when there is a new month etc.
This is one spreadsheet and what I require is to split this into 12 months which can be then renamed for each month.
So I need a code to cut it at each month?
Hope this explains all. Thanks for looking and hopefully your help.
[Bad HTML example removed by admin]
I need to write a macro which is hard for me but could be easier for all you excel wizards.
Please see the able below which is a table containing who is on Holiday within my Department for the different Months.
This spreadsheet is a download from a system but the Months are not split out and what I want is to split out every time there is a month change.
This table is just showing the first column but the range I need to cut will always be from A to AM
I have a list of people as listed below which starts at January 2007 and goes down and then starts at February 2007 and then restarts at each month till December.
What I need is?
To be able run a macro to cut or copy all information from the January cell to the end of the names/start of the next month. This may change so therefore it may not be A3 –A11 could be A5-A13. So I need the macro to know when there is a new month etc.
This is one spreadsheet and what I require is to split this into 12 months which can be then renamed for each month.
So I need a code to cut it at each month?
Hope this explains all. Thanks for looking and hopefully your help.
[Bad HTML example removed by admin]