Hi all
Still a novice in VBA so I could with a hand. I do a report where I currently filter Column B by blanks then add a vlookup connecting to another file to 'fill-in' the missing cells. How can I automate this in VBA?
Do I
1. Add the filter, like below, and enter some sort of code under 'Range("B1") that would make it go to the first blank cell in column b and from there I can use the autofill selection.
My attempt (I thought maybe offset could work with a filter but obviously not.....)
2. Approach it from some kind of Loop angle. If so, how would I do this? Is there something I can do that would make it start at B2, check if it's blank, enter a formula if so,pass if contains data, continue until the data ends in column a for that day (which shows the job numbers for the day)
Any help would be great. Cheers
Bookmarks