Excel Macros help

[Closed]
Report
-
Posts
433
Registration date
Saturday February 16, 2008
Status
Member
Last seen
October 17, 2008
-
Hello,
I am try to get a macro to let me do:

Input a number in cell c1 and have that number appear in a1 then the macro will delete the number in c1 but when I input another number in c1 again it will place that number in a2 and delete the number in c1..so on...

so the output will look something like this..

A B C
1 172637889287722889 9898808980911111 >----NUMBERS WILL GO HERE
2 789789507698979879 AND DELETE ITSELF
3 789070987097087888 |
4 766564533435000010 |
5 010202022020200030 |
6 <--------------------------------------------------------------------------------------------
7
8
9

Is this possible? Please help...Thank you..

2 replies

Posts
16
Registration date
Monday August 25, 2008
Status
Member
Last seen
April 28, 2009
2
hello,

i dont think that is possible to be done but just check that in the help file and see what you can get
Posts
433
Registration date
Saturday February 16, 2008
Status
Member
Last seen
October 17, 2008
109
Hello,
of course it is possible, by using the event Change of the Worksheet
Private Sub Worksheet_Change(ByVal Target As Range)
    'your instructions
End Sub

Ivan