xforum142riidax
New Member
- Joined
- Feb 16, 2019
- Messages
- 3
Hello All -
I have a subset of data I download twice a month into a master sheet. The data is comprised of the same 8 column headings, and anywhere from 200-400 rows. I'm looking for a resource to copy and paste certain rows to existing worksheets based on text identification in one of the columns.
<colgroup><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
Per the example above, data is downloaded into sheet tab "Master" ; the data should then be identified based on Column E "LISTING'S NICKNAME" and the entire row copied and pasted to the corresponding sheets in the next available blank row. Meaning: Any row with Column E containing "10 Bonsall" should have the entire row pasted to Sheet "10Bonsall" in the next available blank row ; Any row with Column E containing "7 Sycamore" should have the entire row pasted to Sheet "7Sycamore" in the next available blank row ; and so on. With a full data set there are a minimum of 70x different Listing Nicknames and corresponding Sheets.
Really need help and sincerely appreciate any advice. Thank you in advance!
I have a subset of data I download twice a month into a master sheet. The data is comprised of the same 8 column headings, and anywhere from 200-400 rows. I'm looking for a resource to copy and paste certain rows to existing worksheets based on text identification in one of the columns.
CHECK IN | STATUS | GUEST'S NAME | NUMBER OF GUESTS | LISTING'S NICKNAME | TOTAL PAYOUT | TOTAL REFUNDED | SOURCE |
1/18/2019 | confirmed | Callum | 4 | 10 Bonsall | 397.7 | AirBnB | |
1/25/2019 | confirmed | Ben | 6 | 10 Bonsall | 382.18 | AirBnB | |
1/29/2019 | confirmed | Hannah | 3 | 10 Bonsall | 306.52 | AirBnB | |
1/30/2019 | confirmed | Brenda | 5 | 7 Sycamore | 411.28 | AirBnB | |
1/12/2019 | confirmed | MJ | 5 | 11 Sycamore | 249.29 | AirBnB | |
1/13/2019 | confirmed | Sulayman | 4 | 11 Sycamore | 191.09 | AirBnB |
<colgroup><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
Per the example above, data is downloaded into sheet tab "Master" ; the data should then be identified based on Column E "LISTING'S NICKNAME" and the entire row copied and pasted to the corresponding sheets in the next available blank row. Meaning: Any row with Column E containing "10 Bonsall" should have the entire row pasted to Sheet "10Bonsall" in the next available blank row ; Any row with Column E containing "7 Sycamore" should have the entire row pasted to Sheet "7Sycamore" in the next available blank row ; and so on. With a full data set there are a minimum of 70x different Listing Nicknames and corresponding Sheets.
Really need help and sincerely appreciate any advice. Thank you in advance!