Can someone help me write a macro?

Closed
Maria - May 17, 2011 at 11:58 AM
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - May 17, 2011 at 09:54 PM
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

venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 810
May 17, 2011 at 09:54 PM
what is the relationship of column 1 and column 5 when new data is entered in column 1
0