Reflecting All Duplicates of one sheet to other sheet, and values in front of them as dropdown.

%3CLINGO-SUB%20id%3D%22lingo-sub-2269591%22%20slang%3D%22en-US%22%3EReflecting%20All%20Duplicates%20of%20one%20sheet%20to%20other%20sheet%2C%20and%20values%20in%20front%20of%20them%20as%20dropdown.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2269591%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22sheet%202.PNG%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F272352i17BCA498780DFF21%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22sheet%202.PNG%22%20alt%3D%22sheet%202.PNG%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22stock%201.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F272351iACADE9372412DC1C%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22stock%201.png%22%20alt%3D%22stock%201.png%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22stock%202.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F272353i6BE1A2A09F63DFC9%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22stock%202.png%22%20alt%3D%22stock%202.png%22%20%2F%3E%3C%2FSPAN%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20all%20ae%20good%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20someone%20please%20tell%20that%20how%20I%20can%20reflect%20all%20duplicates%20of%20one%20sheet%20into%20another%20sheet.%20In%20Sheet%202%2C%20you%20can%20see%20there%20are%20some%202%20distinct%20products%20given%20in%20Column%20D.%20And%20you%20can%20also%20see%20that%20the%20same%20product%20is%20bought%20on%20different%20dates%20with%20different%20price.%20And%20I%20want%20to%20reflect%20the%20product%20name%20in%20Sheet%201%20and%20the%20dates%20may%20come%20in%20dropdown%20as%20you%20can%20see%20in%20the%20images.%20So%20whenever%20a%20person%20selects%20a%20particular%20date%20it%20may%20show%20that%20day%20purchase%20price%20and%20quantity.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnd%20also%20when%20the%20same%20product%20might%20be%20bought%20in%20future%20and%20entered%20in%20Sheet%202%2C%20the%20day%20may%20automatically%20come%20in%20dropdown.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20any%20way%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ekindly%20help%20me%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F699938%22%20target%3D%22_blank%22%3E%40DevendraJain%3C%2FA%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2269591%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Visitor

sheet 2.PNGstock 1.pngstock 2.pngHello,

 

Hope all ae good

 

Can someone please tell that how I can 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

 

Thank you

 

@Sergei Baklan 

@DevendraJain 

0 Replies