Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto Filter one short list vs another very long list
I would like an example code of autofilter where on the linked sheet it will look up each part number in the yellow column and filter the pink column for that part number. Then return the column G value, the column B "filter on" value and the column N dollar amount, as displayed in the blue return example. Using the macro recorder I know the three columns have to be included in the filter and the copy the visible cells. The recorded code was to abstract for me to distill down to a proper autofilter macro. Thanks, Howard https://www.dropbox.com/s/kaiky4skoe...test.xlsm?dl=0 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I change a long columns list to short ones in 2007 Excel? | Excel Discussion (Misc queries) | |||
Auto Filter List | Excel Programming | |||
Auto list/filter | Excel Discussion (Misc queries) | |||
Long list of words to find with Filter | Excel Discussion (Misc queries) | |||
Auto Filter From List | Excel Programming |