Search for text , cut and paste into new work sheet
Closed
JoeRooney
JoeRooney
- Posts
- 2
- Registration date
- Wednesday August 16, 2017
- Status
- Member
- Last seen
- August 16, 2017
JoeRooney
- Posts
- 2
- Registration date
- Wednesday August 16, 2017
- Status
- Member
- Last seen
- August 16, 2017
Related:
- Search for text , cut and paste into new work sheet
- Excel vba cut and paste row to another sheet based on cell value - Forum - Excel
- Disable cut copy paste in windows - Forum - Windows 7
- Compare two worksheets and paste differences to another sheet - excel vba free download ✓ - Forum - Excel
- How to compare two Excel sheets with varying data ✓ - Forum - Excel
- Macro to compare 2 sheets and copy differences ✓ - Forum - Excel
1 reply
JoeRooney
Aug 16, 2017 at 11:13 AM
- 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
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