macro to copy Vlookup formula to some cells with a filter on

M

Maria

Hello,

I was wondering if somebody could help me with this macro…

I have some data with a filter on, so that only the rows with blank cells
are showing.
I want to enter a VLOOKUP in the cell, and copy it down to all the blank
cells. I tried just recording a macro, but when I run the macro it doesn’t
work.

Any ideas of how to do it?

Example:

1)
Before the filter:

Colums A -B - C
A x x - 1st Row
A - 2nd Row
A x x - 3rd Row
A - 4th row
A x x - 5th row

2)
After the filter (filter – blanks):

Colums A -B - C
A - 2nd Row
A - 4th row

3)
Enter VLOOKUP in A2,B2 and copy it down to B4 and C4

Hope I made sense...

Thanks!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top