Hello all! I have been banging my head on this one for awhile. again, i am new to VBA and trying to learn with the help of many! =) i'm not even sure this is possible.
i have a column of imported data from another sheet. the number of rows will change from week to week so the used range will constantly be different. in the column to the right of it i am trying to paste a formula into said cell using a macro only if the cell to the left has a value in it. if not, i am trying to skip down to the next cell and check for a value then paste the formula if one is found. i will paste what i'm using here which i'm sure is way off!! any help is greatly appreciated.
Thanks!
Bookmarks