Previous Topic Next Topic

Excel Macros help

Closed
xwingtw - Aug 31, 2008 at 06:59 PM
Ivan-hoe Posts 433 Registration date Saturday February 16, 2008 Status Member Last seen October 17, 2008 - Sep 2, 2008 at 09:05 AM
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..
Related:

2 responses

Answer 1 / 2
studentguide Posts 16 Registration date Monday August 25, 2008 Status Member Last seen April 28, 2009 2
Sep 1, 2008 at 04:09 AM
hello,

i dont think that is possible to be done but just check that in the help file and see what you can get
Answer 2 / 2
Ivan-hoe Posts 433 Registration date Saturday February 16, 2008 Status Member Last seen October 17, 2008 110
Sep 2, 2008 at 09:05 AM
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

Similar discussions

Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses
How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses