How to copy cell to workbooks selected.

[Closed]
Report
Posts
3
Registration date
Sunday November 24, 2013
Status
Member
Last seen
November 24, 2013
-
Hello friends, please help me with this problem:

I want to copy cell(A1) in book1 to cell(A1) in book2 or book3 or book4, etc.
Here book1 is for data entry. And book2,3,4,5,6, etc. is where the cell data will be copied.
Example: When book2 is chosen. Data will be copied to book2 only.

Now,
1. How can I choose between the workbooks where I want the data to be copied?
2. Is there any button or something when clicked or pressed then the cell data will be copied to mentioned workbook?

I am not good in excel. Please make a simple formula: easy to understand.

Hope my description makes sense.
I am expecting to see a response from you guys. Thanks in advance.
God bless you.