Can someone help me write a macro? [Closed]

Report
-
Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
-
Hello,

I have a large database of information (inventory). The datbase is constantly having rows added and deleted.
In column (1), there over 100 different items (string).
In column (5) I want a result dependent upon the value of column (1) (string).
When items are added to (1) I want it to update (5) automatically. If row is empty, then stop.
I understand the if,then. else feature...however, I am getting stuck on everything else.
I want the macro to run and save the result.



1 reply

Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
798
what is the relationship of column 1 and column 5 when new data is entered in column 1

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!