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.
[TABLE="width: 786"]
<colgroup><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]CHECK IN[/TD]
[TD]STATUS[/TD]
[TD]GUEST'S NAME[/TD]
[TD]NUMBER OF GUESTS[/TD]
[TD]LISTING'S NICKNAME[/TD]
[TD]TOTAL PAYOUT[/TD]
[TD]TOTAL REFUNDED[/TD]
[TD]SOURCE[/TD]
[/TR]
[TR]
[TD="align: right"]1/18/2019[/TD]
[TD]confirmed[/TD]
[TD]Callum [/TD]
[TD="align: right"]4[/TD]
[TD]10 Bonsall[/TD]
[TD="align: right"]397.7[/TD]
[TD][/TD]
[TD]AirBnB[/TD]
[/TR]
[TR]
[TD="align: right"]1/25/2019[/TD]
[TD]confirmed[/TD]
[TD]Ben [/TD]
[TD="align: right"]6[/TD]
[TD]10 Bonsall[/TD]
[TD="align: right"]382.18[/TD]
[TD][/TD]
[TD]AirBnB[/TD]
[/TR]
[TR]
[TD="align: right"]1/29/2019[/TD]
[TD]confirmed[/TD]
[TD]Hannah [/TD]
[TD="align: right"]3[/TD]
[TD]10 Bonsall[/TD]
[TD="align: right"]306.52[/TD]
[TD][/TD]
[TD]AirBnB[/TD]
[/TR]
[TR]
[TD="align: right"]1/30/2019[/TD]
[TD]confirmed[/TD]
[TD]Brenda [/TD]
[TD="align: right"]5[/TD]
[TD]7 Sycamore[/TD]
[TD="align: right"]411.28[/TD]
[TD][/TD]
[TD]AirBnB[/TD]
[/TR]
[TR]
[TD="align: right"]1/12/2019[/TD]
[TD]confirmed[/TD]
[TD]MJ [/TD]
[TD="align: right"]5[/TD]
[TD]11 Sycamore[/TD]
[TD="align: right"]249.29[/TD]
[TD][/TD]
[TD]AirBnB[/TD]
[/TR]
[TR]
[TD="align: right"]1/13/2019[/TD]
[TD]confirmed[/TD]
[TD]Sulayman [/TD]
[TD="align: right"]4[/TD]
[TD]11 Sycamore[/TD]
[TD="align: right"]191.09[/TD]
[TD][/TD]
[TD]AirBnB[/TD]
[/TR]
</tbody>[/TABLE]
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.
[TABLE="width: 786"]
<colgroup><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]CHECK IN[/TD]
[TD]STATUS[/TD]
[TD]GUEST'S NAME[/TD]
[TD]NUMBER OF GUESTS[/TD]
[TD]LISTING'S NICKNAME[/TD]
[TD]TOTAL PAYOUT[/TD]
[TD]TOTAL REFUNDED[/TD]
[TD]SOURCE[/TD]
[/TR]
[TR]
[TD="align: right"]1/18/2019[/TD]
[TD]confirmed[/TD]
[TD]Callum [/TD]
[TD="align: right"]4[/TD]
[TD]10 Bonsall[/TD]
[TD="align: right"]397.7[/TD]
[TD][/TD]
[TD]AirBnB[/TD]
[/TR]
[TR]
[TD="align: right"]1/25/2019[/TD]
[TD]confirmed[/TD]
[TD]Ben [/TD]
[TD="align: right"]6[/TD]
[TD]10 Bonsall[/TD]
[TD="align: right"]382.18[/TD]
[TD][/TD]
[TD]AirBnB[/TD]
[/TR]
[TR]
[TD="align: right"]1/29/2019[/TD]
[TD]confirmed[/TD]
[TD]Hannah [/TD]
[TD="align: right"]3[/TD]
[TD]10 Bonsall[/TD]
[TD="align: right"]306.52[/TD]
[TD][/TD]
[TD]AirBnB[/TD]
[/TR]
[TR]
[TD="align: right"]1/30/2019[/TD]
[TD]confirmed[/TD]
[TD]Brenda [/TD]
[TD="align: right"]5[/TD]
[TD]7 Sycamore[/TD]
[TD="align: right"]411.28[/TD]
[TD][/TD]
[TD]AirBnB[/TD]
[/TR]
[TR]
[TD="align: right"]1/12/2019[/TD]
[TD]confirmed[/TD]
[TD]MJ [/TD]
[TD="align: right"]5[/TD]
[TD]11 Sycamore[/TD]
[TD="align: right"]249.29[/TD]
[TD][/TD]
[TD]AirBnB[/TD]
[/TR]
[TR]
[TD="align: right"]1/13/2019[/TD]
[TD]confirmed[/TD]
[TD]Sulayman [/TD]
[TD="align: right"]4[/TD]
[TD]11 Sycamore[/TD]
[TD="align: right"]191.09[/TD]
[TD][/TD]
[TD]AirBnB[/TD]
[/TR]
</tbody>[/TABLE]
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!