Cutting and pasting in new spreadsheet

[midfieldgeneral11]

Hello everyone hope you having a good day.

Can you help this would be much appriciated.

I need to write a macro which is hard for me but could be easier for all you excel wizards.

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 and it to cut at February 2007 and put this into a new spreadsheet the problem is February 2007 could be at line 57 one day and then 62 the next the more names added the longer the list.

I need this to cut the information at all the months (in bold) and place this in a new tab. So I am left with 12 tabs, 12 Months?

Can someone tell me the code I would need to do?

This would be much appriciated.

A quick response would be great
If you would like me to send you the spreadsheet so you can see what am working with then please let me know via this website youre email address.

Simon

January '07
Armytage, Hugh
Baker, Nyree
Barreto, Anthony
Bennett, Harry
Bennett, Michael
Bignell, Michael
Bright, Steven
Brown, Richard
Collecott, Robert
Connelly, Paul
Daniels, Steve
Du Sautoy, Nicholas
East, Christine
Embling, Bryony
Fellowes, Robert
Gray, Alex
Healy, Lynne
Henderson, Martin
Hillion, Barry
Hoad, Tom
Hoes, Stephen
Horne, David
Horstead, John
Howes, Russel
Hurley, Phillip
Johnson, Grant
Lee, Gemma
Lewis, Vicky
Maguire, Patrick
Maxwell-Gumbleton, Dickon
Mewett, Paul
Miller, Sonia
Nicholson, Gemma
Notley, David
Pembroke, Sam
Petto, Steven
Pinnington, Christopher
Rands, Simon
Raymond, Lianne
Regan, Tim
Saada, Mo
Seagroatt, Julia
Seffens, Ericka
Sherley-Price, Matthew
Spencer, David
Stanley, Clive
Sudbury, James
Taylor, Julian
Thain, Julie
Thompson, Kevin
Townsend, Lesley
Vincent, Alex
Vint, Jim
White, Michael
Wright, Danielle
February '07
Bailey, Andy
Baker, Nyree
Baldacci, Nick
Barreto, Anthony
Bennett, Harry
Bennett, Michael
Bignell, Michael
Bright, Steven
Brown, Richard
Brown, Simon
Collecott, Robert
Connelly, Paul
Daniels, Steve
Dewey, Stephen
Du Sautoy, Nicholas
Embling, Bryony
Gray, Alex
Healy, Lynne
Henderson, Martin
Hillion, Barry
Holliday, Mark
Horne, David
Horstead, John
Hurley, Phillip
Keenan, Gary
Lee, Gemma
Leonard, Terry
Lewis, Vicky
Maxwell-Gumbleton, Dickon
Mewett, Paul
Miller, Sonia
Mitchell, Robert
Nicholson, Gemma
Pembroke, Sam
Petto, Steven
Pinnington, Christopher
Raymond, Lianne
Saada, Mo
Sarjeant, Vicky
Seagroatt, Julia
Seffens, Ericka
Sherley-Price, Matthew
Spencer, David
Stanley, Clive
Stoneham, Mark
Taylor, Adam
Taylor, Julian
Taylor, Laura
Thain, Julie
Thompson, Kevin
Townsend, Lesley
Vincent, Alex
Vint, Jim
Walker, Paul
Watson, Alison
Webber, Keith
White, Michael
Wright, Danielle
March '07
Armytage, Hugh
Bailey, Andy
Baker, Nyree
Barreto, Anthony
Bennett, Harry
Bennett, Michael
Bright, Steven
Brown, Richard
Brown, Simon
Collecott, Robert
Connelly, Paul
Daniels, Steve
Dewey, Stephen
Du Sautoy, Nicholas
Embling, Bryony
Fellowes, Robert
Gray, Alex
Healy, Lynne
Hillion, Barry
Hoes, Stephen
Horne, David
Horstead, John
Howes, Russel
Hurley, Phillip
Johnson, Grant
Keeble, Matt
Keenan, Gary
Khatib, Ata
Lee, Gemma
Lewis, Vicky
Maguire, Patrick
Maxwell-Gumbleton, Dickon
Mewett, Paul
Miller, Paula
Miller, Sonia
Mitchell, Robert
Nicholson, Gemma
Notley, David
Pembroke, Sam
Petto, Steven
Rands, Simon
Raymond, Lianne
Regan, Tim
Saada, Mo
Sarjeant, Vicky
Seagroatt, Julia
Seffens, Ericka
Sidgwick, Jason
Spencer, David
Stanley, Clive
Stoneham, Mark
Taylor, Julian
Taylor, Laura
Thain, Julie
Thompson, Kevin
Townsend, Lesley
Vint, Jim
Walker, Paul
Watson, Alison
Webber, Keith
Westmoreland, Adam
White, Michael
Wright, Danielle
April '07
Armytage, Hugh
Bailey, Andy
Bennett, Harry
Bennett, Michael
Bright, Steven
Brown, Richard
Collecott, Robert
Connelly, Paul
Davies, Paul
Du Sautoy, Nicholas
East, Christine
Embling, Bryony
Fellowes, Robert
Healy, Lynne
Henderson, Martin
Hillion, Barry
Hoad, Tom
Hoes, Stephen
Holliday, Mark
Horne, David
Horstead, John
Johnson, Grant
Keeble, Matt
Keenan, Gary
Khatib, Ata
Lee, Gemma
Leonard, Terry
Lewis, Vicky
Maguire, Patrick
Maxwell-Gumbleton, Dickon
Mewett, Paul
Mitchell, Robert
Nicholson, Gemma
Notley, David
Pembroke, Sam
Petto, Steven
Raymond, Lianne
Regan, Tim
Saada, Mo
Sarjeant, Vicky
Seffens, Ericka
Sherley-Price, Matthew
Stanley, Clive
Sudbury, James
Taylor, Julian
Taylor, Laura
Thain, Julie
Thompson, Kevin
Townsend, Lesley
Vaughan, Les
Vincent, Alex
Vint, Jim
Walker, Paul
Webber, Keith
White, Michael
Wright, Danielle
May '07
Armytage, Hugh
Baker, Nyree
Bennett, Michael
Bright, Steven
Brown, Richard
Collecott, Robert
Connelly, Paul
Davies, Paul
Embling, Bryony
Henderson, Martin
Horne, David
Horstead, John
Keenan, Gary
Khatib, Ata
Miller, Sonia
Nicholson, Gemma
Raymond, Lianne
Regan, Tim
Seffens, Ericka
Stanley, Clive
Sudbury, James
Taylor, Julian
Thain, Julie
Townsend, Lesley
Vaughan, Les
Walker, Paul
Watson, Alison
White, Michael
June '07
Armytage, Hugh
Baker, Nyree
Bennett, Michael
Bright, Steven
Brown, Simon
Connelly, Paul
Davies, Paul
East, Christine
Embling, Bryony
Fellowes, Robert
Gray, Alex
Healy, Lynne
Howes, Russel
Maguire, Patrick
Mewett, Paul
Nicholson, Gemma
Pinnington, Christopher
Raymond, Lianne
Regan, Tim
Spencer, David
Sudbury, James
Taylor, Adam
Taylor, Julian
Walker, Paul
Westmoreland, Adam
July '07
Armytage, Hugh
Baker, Nyree
Bennett, Michael
Daniels, Steve
Dewey, Stephen
East, Christine
Gray, Alex
Henderson, Martin
Holliday, Mark
Horne, David
Johnson, Grant
Mewett, Paul
Morgan, Jonathan
Raymond, Lianne
Regan, Tim
Seagroatt, Julia
Sudbury, James
Taylor, Julian
Thain, Julie
Thompson, Kevin
Townsend, Lesley
Vaughan, Les
Walker, Paul
Wright, Danielle
August '07
Armytage, Hugh
Bennett, Harry
Brown, Simon
Connelly, Paul
Daniels, Steve
Dewey, Stephen
Du Sautoy, Nicholas
Fellowes, Robert
Gray, Alex
Holliday, Mark
Horne, David
Howes, Russel
Miller, Sonia
Nicholson, Gemma
Raymond, Lianne
Regan, Tim
Sarjeant, Vicky
Seagroatt, Julia
Sudbury, James
Thompson, Kevin
Vaughan, Les
Vincent, Alex
Walker, Paul
September '07
Baker, Nyree
Bennett, Michael
Connelly, Paul
Daniels, Steve
Henderson, Martin
Morgan, Jonathan
Raymond, Lianne
Sarjeant, Vicky
Stanley, Clive
Townsend, Lesley
October '07
Dewey, Stephen
Mewett, Paul
Stanley, Clive
Taylor, Julian
Vaughan, Les
November '07
Taylor, Julian
Westmoreland, Adam
December '07
Bright, Steven
Nicholson, Gemma
Taylor, Julian

 

[ravishankar]

Hi
paste the following codes in the macro window ( Alt F8)

x = Cells(Rows.Count, 1).End(xlUp).Row
b = 2
c = 1
For a = 1 To x
If Cells(a, 1).Font.Bold = True Then
b = b + 1
c = 1
Else
Worksheets(b).Cells(c, 1) = Cells(a, 1)
c = c + 1
End If
Next a

I assume you have 13 sheets . The macro checks col A for bold fonts and if found (should be only on month names) will switch to next sheet.
Ravi