Hi guys, is it possible linking the information you have from sheet 1 to your sheet 2 and 3?
Example:
Sheet 1
Sheet 2 will show who order Oranges
and sheet 3 will show who order Apples
Example:
Sheet 1
Name: | Order: | Address: | Phone 1: | Email: |
John Smith | Oranges | 123 fake street | 555 555 5555 | johnsmith@yc.com |
James Bond | Apples | 521 Maple drive | 222 222 2222 | Jamesbond@gm.com |
Logan Wolverine | Oranges | 789 Xavier Circle | 444 444 4444 | WolverineX@rm.com |
Tony Starks | Apples | 852 Parker Lane | 888 888 8888 | ironman@edith.com |
Sheet 2 will show who order Oranges
Name: | Order: | Address: | Phone1: | Email: |
John Smith | Oranges | 123 fake street | 555 555 5555 | johnsmith@yc.com |
Logan Wolverine | Oranges | 789 Xavier Circle | 444 444 4444 | WolverineX@rm.com |
and sheet 3 will show who order Apples
Name: | Order: | Address: | Phone1: | Email: |
James Bond | Apples | 521 Maple drive | 222 222 2222 | Jamesbond@gm.com |
Tony Starks | Apples | 852 Parker Lane | 888 888 8888 |