Search for text , cut and paste into new work sheet

Closed
JoeRooney
Posts
2
Registration date
Wednesday August 16, 2017
Status
Member
Last seen
August 16, 2017
- Aug 16, 2017 at 11:08 AM
JoeRooney
Posts
2
Registration date
Wednesday August 16, 2017
Status
Member
Last seen
August 16, 2017
- Aug 16, 2017 at 11:13 AM
Hi , can anyone help me with the below vba code :

Logic
Find text
If next row starts with number
Then - cut 1 row above text and 3 rows below
If next row start with date
Then - cut 1 row above text and 2 rows below

any help is greatly appreciated
Thanks

1 reply

JoeRooney
Posts
2
Registration date
Wednesday August 16, 2017
Status
Member
Last seen
August 16, 2017

Aug 16, 2017 at 11:13 AM
Updated with more detail :

Find text in column A
If next row starts with number
Then - cut 1 row above text and 3 rows below
Paste into new worksheet in column A
Find text in column A
If next row start with date
Then – cut 1 row above text and 2 rows below
Paste into new worksheet in column A directly under existing record
Loop through until all relevant rows have been cut and pasted into new worksheet
0