Copy Data One Workbook to Another

[aburashed]

Hello guys, I am a new to excel. Still learning. Please help me solve a problem. Thank you in advance.

COULD YOU PLEASE SOLVE:

CONSIDER 3 CELLS: A2,B2,C2 in a Workbook named, Data Entry.

A2 is where I write data in.
B2 is a drop down list of 3 different posting workbook's named: X, Y, Z.

I want a SAVE button.
When SAVE button is clicked, I want to copy cell A2 to the workbook chosen from the drop down lists in B2. If X is chosen, data will save in X workbook only.

I hope this makes sense. And expect to see wonderful solution from you guys.
Thanks once again.

[FDibbins]

Thanks for the title change

All yours, shg

[shg]

Please take a few minutes to read the forum rules about cross-posting.

[aburashed]

guys sorry i did not know about rules. i change now title. please help me bro.

[aburashed]

can u please help me?

[aburashed]

bro u told me u help. but u no.