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