Changing the cell values by macro to a cell in another column

[erguntmzkn]

I need a macro that sets the value of selected cell to the cell in column "B" which has the same row number with selected cell.
Example :

When I run the macro when the cell A3 is selected it should make the A3 equal to B3. (selected cell still should be A3)
Or when T39 is selected macro should make the value of the cell as B39. (And after the process the selected cell should be still T39.

Thanks in advance.

[MarvinP]

Hi,

Try this

Please Login or Register  to view this content.

[dilipandey]

Hi erguntmzkn,

You can use below macro:-

Please Login or Register  to view this content.

Regards,
DILIPandey
<click on below * if this helps>

[erguntmzkn]

Thank you. And can you give me the one that provides the value "-" ?
I mean A3 will turn to -B3. If B3 is equal to 14. When I run the macro A3 will be -14.
Thanks again.

[erguntmzkn]

And actually I want to select the next row after macro. I mean when I run it the value in cell A3 will be B3 and the selected cell will be B4. Is it possible ? Thanks.

[dilipandey]

I mean when I run it the value in cell A3 will be B3 and the selected cell will be B4.

Not getting you... you are standing on B4 and macro will fetch value of A4 .. that's what your requirement was... correct?
Now, do yo want to fill all rows above to your selected cell to be filled up with column A's value ?


Regards,
DILIPandey
<click on below * if this helps>

[erguntmzkn]

No I just want the same macro that you gave me and only want the selected cell will be the next row. I mean after running macro selected cell will be A4.

Like this.

Selected cell ---> A3
Run macro ---> A3 will be equal to B3
Selected cell will be ---> A4

[arlu1201]

erguntmzkn,

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.