Hi Eveyone,
I have 3 reference books in front of me & I’m losing it!!!
I’m pretty new to VBA & have a beginners question.
In column J I have various codes(K05A, KP60RA, 27, etc.). For 15 of those codes I need to put something in Column K.
K05A = JA
KP60RA = JP
27 = J
For the other codes I need to have it say “Look Up Manually”
Here is what I need: I need to know how to cycle through column J, evaluate the data, and write to column K and stop when it reaches a blank in Column J.
I need to do this in VBA because it is part of a longer Macro that will be used every month to format a report from one of our databases..
I just can’t seem to figure out where to begin and need a push in the right direction…