Macro for copying one cell from one worksheet to another

[bloomis]

Hi,

I have not been able to find this or to get this to work on my own, so if someone can please answer this, it would be appreciated!

I have a workbook that on sheet one, I want whatever data gets put into B2 to be put into B2 on sheet 2. I have not been able to find info just for one cell, always a row or column. I want this to be a macro/VB in the background.

I also will need whatever data is entered into worksheet one, cell B26, put copied into worksheet two, cell B6.

Thank you very much in advanced!

Brian

[mjcordeiro]

I don't know if I understand you correctly.
Is this what you need?:

Please Login or Register  to view this content.

Mário

[bloomis]

Yes,
But what do I need to add to the beginning....ex: Private Sub???? I think that is why it is not working for me!!

Thanks again for all of your help!
Brian

Please Login or Register  to view this content.

[mjcordeiro]

Hello Brian,

You must be more curate in your post.
You are using a Userform or you just want to execute a simple macro?
If you use a Userform, place a simple commandbutton, double click on it, this will place you to the

Please Login or Register  to view this content.

event. Place the code inside this procedure.

If you want to use a simple macro, try to use the RecordMacro command.

Sincerly
Mário

[shg]

mjcordeiro, bloomis,

Please take a few minutes to read the Forum Rules, and then edit your post to wrap your code with Code Tags.

Thanks.