Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
macro to copy Vlookup formula to some cells with a filter on
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 doesnt 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Do I use a formula or a macro to copy cells? | Excel Discussion (Misc queries) | |||
How do i copy a vlookup formula into other cells going right | Excel Worksheet Functions | |||
Copy only visible cells after filter is applied/ sum after filter | Excel Worksheet Functions | |||
Macro to copy and paste into a custom filter | Excel Discussion (Misc queries) | |||
A formula to filter data and copy it from one worksheet to another | Excel Worksheet Functions |