Command Button to Pull data from another worksheet/tab

[markusvirus]

Hi Experts,

I attached the file as my sample. I'm looking to achieve pulling cell data from "Source" sheet and show it in "Main" sheet, is this possible with the use of Command Buttons? If possible, can anyone look on my file and see what codes need to be put so this would run through clicking the buttons? So it's like if Button 1 is clicked, it should pull Title 1 and other row values associated with it. Thanks!

[amartinez988]

Try this better for button 1.

Please Login or Register  to view this content.

[amartinez988]

Hey I did some extra here so you can see the big Picture.

I guess you have one button for each customer. That's not really a good way to solve the problem by I worked based on what you have.

Paste this procedure in one of the Modules:

Please Login or Register  to view this content.

And use this code for the buttons so you don't have to repeat the same code so much.

Please Login or Register  to view this content.

Hope this helps.

[amartinez988]

Option Button Select.xlsm

Please notice attached fixed sample.

[markusvirus]

Thank you so much! exactly what i needed!

[amartinez988]

Great! Please close thread and add reputation if you believe my answer helped you.

[markusvirus]

I already did! thanks again.