Search for text , cut and paste into new work sheetClosed

Question

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

JoeRooney · Answer

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

Search for text , cut and paste into new work sheet

1 reply

Subscribe To Our Newsletter!