Newbie Question - Moving text from one cell to another
 

I just want to make a button that will take information from on
specific cell like v7 and move it to another specific cell like c2
This is probably really easy, bt i'm very new to this code thing. Than
you for any help

--
Message posted from http://www.ExcelForum.com

Newbie Question - Moving text from one cell to another
 

put a button on the sheet from the forms toolbar and try this

Sub Button1_Click()
ActiveCell.Cut
Range("C2").Select
ActiveSheet.Paste
End Sub


The code will cut the text from the selected cell and paste it into C2


"Buritoking " wrote in message
...
I just want to make a button that will take information from one
specific cell like v7 and move it to another specific cell like c2.
This is probably really easy, bt i'm very new to this code thing. Thank
you for any help.


---
Message posted from http://www.ExcelForum.com/

Newbie Question - Moving text from one cell to another
 

-----Original Message-----
I just want to make a button that will take information
from one
specific cell like v7 and move it to another specific
cell like c2.
This is probably really easy, bt i'm very new to this
code thing. Thank
you for any help.


---
Message posted from http://www.ExcelForum.com/

.

In cell if you want the info in cell v7 to also appear in
cell c2 you should just put "=v7" in cell c2 and then
whatever is in v7 will be in c2. Hope this helps and
answers your question.

Newbie Question - Moving text from one cell to another
 

the OP said:

move it to another specific cell

usually that means the data is not to appear in both locations.

--
Regards,
Tom Ogilvy

wrote in message
...

-----Original Message-----
I just want to make a button that will take information
from one
specific cell like v7 and move it to another specific
cell like c2.
This is probably really easy, bt i'm very new to this
code thing. Thank
you for any help.


---
Message posted from http://www.ExcelForum.com/

.

In cell if you want the info in cell v7 to also appear in
cell c2 you should just put "=v7" in cell c2 and then
whatever is in v7 will be in c2. Hope this helps and
answers your question.