Forum Discussion
VBA Copy cells after filter
Hi, I've read several other discussions but still can't find anything that seems to match what im trying to do or that i understand enough to make use of. I have a table on sheet 1 which has 1...
MrNoSoul As a variant, and if you want to dynamically present the three values in Sheet2, based on where the "Yes" is in Sheet1. If the row in Sheet1 with "Yes" changes, the cells in Sheet2 will update automatically.
Two (of many different) options:
1) a "double" FILTER, spilling the three cells in one go (provided your Excel version supports it)
2) a straight forward set of INDEX and MATCH functions
See attached workbook.