VBS for Active Sheet, bring data from database Sheet

[menor59]

Hello Team,

Can you please help with the Following...can i please ask ffor a VBA to do the Following..

This is My Database that has lines B2:H2000

Active Sheet i will tie the Code to a Macro Button as "Update"

The Last Picture is the ActiveSheet. I need to Grab Data from the Database sheet Based on the Active Sheet D3, then From the Database sheet Find the Value of D3 in Range B2:B2000 and Return the Values where it is found from C2:H2000.

D3 or the Sheet Name from the ActiveSheet can be used to search the Database for the Value. Which ever you perfer.

Thank you so much for your time!

 

[Fluff]

Duplicate to: HHelp With Modifying VBA

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread. If you do not receive a response, you can "bump" it by replying to it yourself, though we advise you to wait 24 hours before doing so, and not to bump a thread more than once a day.