Move text from cell to another

Closed
jojo - May 11, 2010 at 04:09 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 11, 2010 at 04:20 PM
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 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
May 11, 2010 at 04:20 PM
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
0