How to select the first blank cell after filtering?

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.....)

Please Login or Register  to view this content.

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

Hi Jimmy,

You need to select first blank cell after the filtered data ?
Or,
you need to select the first blank cell with-in the filtered data. If Yes, then how you are filtering that it shows any blank there, I would like to see that. Thanks.


Regards,
DILIPandey
<click on below * if this helps>

HI Jimmy,

You need to put up vlookup in blank cells of column B till column A has data.. correct ?
Now, from where to lookup the data ?

Regards,
DILIPandey
<click on below * if this helps>

Okay.. use below code and update your formula in it before running :-

Please Login or Register  to view this content.

example.xls

Regards,
DILIPandey
<click on below * if this helps>

Great..!!

Please mark this thread as [SOLVED].. thanks.


Regards,
DILIPandey
<click on below * if this helps>