jnbrewer69
New Member
- Joined
- Jun 12, 2007
- Messages
- 10
Hi,
Thanks in advance to all you good guys and gals.
I need a macro that will look down Sheet1 column E
Find the first cell that contains "B"
Then count down 32 rows and copy the 32 rows to sheet2.
Then loop down sheet1 column E find the Next "B"
Then count down 32 rows and copy the 32 rows to sheet2.Below the previous copied rows
Then continue till the end of the sheet.
Hope that makes sense
Johnny B
Thanks in advance to all you good guys and gals.
I need a macro that will look down Sheet1 column E
Find the first cell that contains "B"
Then count down 32 rows and copy the 32 rows to sheet2.
Then loop down sheet1 column E find the Next "B"
Then count down 32 rows and copy the 32 rows to sheet2.Below the previous copied rows
Then continue till the end of the sheet.
Hope that makes sense
Johnny B