![]() |
#1
|
|||
|
|||
![]()
In Excel file, the user will enter 1 in A1, 2 in A2 then if he entered 3 in A3, I want the 1 in A1 (user already entered) to disperse automatically. If Macro is the only way to do this, can I use “record macro” to record specific steps and then run it for example in a command button? I would appreciate any help.
![]() |
#2
|
||||
|
||||
![]()
What's the logic behind this? Is it because the sum of A1 and A2 equals A3? Does this need to be applied elsewhere in the spreadsheet?
Yes, you will need to use VBA to do this. |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
klingenfelter | Outlook | 10 | 02-04-2011 01:35 PM |
Delete text | Michael007 | Office | 13 | 01-01-2011 10:38 PM |
Undo Delete | jbelorit | Outlook | 0 | 11-22-2010 08:10 AM |
delete email message via blackberry and have it delete on my pop3 and my outlook | Iamthestorm | Outlook | 2 | 10-28-2010 12:21 AM |
Cannot delete line | adkr | Office | 1 | 04-07-2010 09:26 PM |