Hi,

I have a cell that uses a data validation list on one of my worksheets,
(Cell 'B3').

I pick a value from 'B3' and by using advance filtering, data is copied
over from another worksheet.

If I add a new row to one of the sheets that the data is being copied
from that match's the choice I have selected in B3 it doesn't display
until I select the choice again from my list in 'B3'.

How can I make my code refresh the current choice in 'B3' without me
having to select it?

Thanks, Jody