How can I reflect all duplicates of one sheet into another sheet? In Sheet 2, you can see there are some 2 distinct products given in Column D. And you can also see that the same product is bought on different dates with different price. And I want to reflect the product name in Sheet 1 and the dates may come in dropdown as you can see in the images. So whenever a person selects a particular date it may show that day purchase price and quantity.
And also when the same product might be bought in future and entered in Sheet 2, the day may automatically come in dropdown.
Is there any way
kindly help me