Move text from cell to another

Closed
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Dear all

I would like to know if it's possible to move text from cell to another in excel 2007, Example ; I have IN colmun and Out colmun in one sheet so, I'll write the item in the IN colmun when i finised from that i'll add ok or i'll color it then i want the text to move to the OUT colmun

need your help please



1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
You have to write a macro for that. If you want this to happen on its own then you most probably have to define this event on the sheet where this will occur


Private Sub Worksheet_Change(ByVal Target As Range)

End Sub