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
- Windows network commands cheat sheet - Guide
- Sheet right to left in google sheet - Guide
- Google.us search - Guide
- Yahoo search history - Guide
- How to search for a word on a page - Guide
1 response
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
