本文发表在 rolia.net 枫下论坛Let's say in sheet3, we have the worksheet,
Sheet3
Name color code notes
product1 white 1200-1403 good quality
product1 white 1200-1404 good quality
product1 white 1200-1405 lower quality
product1 white 1200-1406 acceptable quality
product1 yellow 1200-1403 good quality
product1 yellow 1200-1404 good quality
product1 yellow 1200-1405 lower quality
product1 yellow 1200-1406 acceptable quality
product2 white 1300-2101 good quality
product2 white 1300-2102 lower quality
product2 white 1300-2103 acceptable quality
product2 white 1300-2104 lower quality
product2 yellow 1300-4101 acceptable quality
product2 yellow 1300-4102 good quality
product2 yellow 1300-4103 lower quality
product2 yellow 1300-4104 acceptable quality
I'd like to use these data in sheet1 and sort out the right one from sheet3. For example, I want to check out product2->white->1300-2102 in sheet1.Range("A2:D2"). How can I achieve this goal ? Keep in mind that no one can really remember the code. We go by product, color, and quality.
Thank you all again for your valuable input.更多精彩文章及讨论,请光临枫下论坛 rolia.net
Sheet3
Name color code notes
product1 white 1200-1403 good quality
product1 white 1200-1404 good quality
product1 white 1200-1405 lower quality
product1 white 1200-1406 acceptable quality
product1 yellow 1200-1403 good quality
product1 yellow 1200-1404 good quality
product1 yellow 1200-1405 lower quality
product1 yellow 1200-1406 acceptable quality
product2 white 1300-2101 good quality
product2 white 1300-2102 lower quality
product2 white 1300-2103 acceptable quality
product2 white 1300-2104 lower quality
product2 yellow 1300-4101 acceptable quality
product2 yellow 1300-4102 good quality
product2 yellow 1300-4103 lower quality
product2 yellow 1300-4104 acceptable quality
I'd like to use these data in sheet1 and sort out the right one from sheet3. For example, I want to check out product2->white->1300-2102 in sheet1.Range("A2:D2"). How can I achieve this goal ? Keep in mind that no one can really remember the code. We go by product, color, and quality.
Thank you all again for your valuable input.更多精彩文章及讨论,请光临枫下论坛 rolia.net