Hello,
I'm sure the answer to this is out there, but I am not searching correctly
to find it. I have code to past the result of an if/then/elseif statement
from column B into column A. It works for line one and I am drawing a mind
blank and I can't get it to run through the whole sheet
There's a couple of things that you may need to reconsider.
First of all, your code looks SPECIFICALLY at cell B1 and modifies A1.
you need a method of cycling through your values.
there are several ways to accomplish this.
In this case, I'd probably elect to do something like:
For each