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
JoeRooney Posts 2 Registration date Wednesday August 16, 2017 Status Member Last seen August 16, 2017 - Aug 16, 2017 at 11:13 AM
Related:
- Search for text , cut and paste into new work sheet
- Compare two worksheets and paste differences to another sheet - excel vba free download ✓ - Excel Forum
- Cap cut pc - Download - Video editing
- Www.google.com search video - Download - Video playback
- Vim search for word - Guide
- Macro to compare 2 sheets and copy differences ✓ - Excel Forum
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
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
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
