Extract Data from a table based on a selection from a drop down list (VBA)

[Shantanutheway]

Hi all,
I have a sheet which contains a master data, i want to copy the data from the master sheet to a new sheet based on the selection made in the drop down list.
I tried using slicer but it does not suit my needs, so i made my own drop down list in Cell A10 which has all the dates present in column H.
What i am looking for is, when i select a particular date from the drop down list i want the data from all the rows containing that date to be displayed in the "Output" sheet.
I tried doing it through formulae but as the data is in 1000's of cells the output is very slow to load ,so i would like to know a VBA code which does the same.
Any help will be appreciated.

Regards,
Shantanu

For your reference i have attached a test sheet.

[oeldere]

Why not a filter on H12 in the original data?

[vcoolio]

Hello Shantanu,

Try the following code assigned to a button:-

Please Login or Register  to view this content.

I hope that this helps.

Cheerio,
vcoolio.

[Shantanutheway]

Hi oeldere,
Filtering the data wont work for my problem because i also need the data to be displayed in another sheet.

[Shantanutheway]

Hello Shantanu,

Try the following code assigned to a button:-

Please Login or Register  to view this content.

I hope that this helps.

Cheerio,
vcoolio.

Hi vcoolio,
That is 99% of what i am looking for. THANK YOU! The only issue that is still present is that when i click the button the data is being extracted below the previous data, whereas i want the data in the "output" sheet to show the data of only the date i select. For your reference, i have attached the sheet after assigning the macro to the button and using it.
If the sheet only shows the output i want and deletes the previous output then it would be perfect.
Thank you for your effort and prompt response!

Regards,
Shantanu

[vcoolio]

Hello Shantanu,

Add this line of code:-

Please Login or Register  to view this content.

just above

With Sheet1...............

You should then be able to refresh the Output sheet with just the new data.

I hope that this helps.

Cheerio,
vcoolio.

[Shantanutheway]

Hello Shantanu,

Add this line of code:-

Please Login or Register  to view this content.

just above

With Sheet1...............

You should then be able to refresh the Output sheet with just the new data.

I hope that this helps.

Cheerio,
vcoolio.

Hello vcoolio,
Thanks Alot! Worked exactly as i wanted!! :D

[vcoolio]

You're welcome Shantanu. I'm glad to have been able to assist.

Thanks for the rep.

Cheerio,
vcoolio.