using VB to filter
 

Hi,

I have Worksheet2 which contains all the rows from worksheet1 (by referring
to the cells on it). However worksheet 2 is filtered to show only those rows
with column A = 'Yes'

I copy Worksheet2 to a new workbook, and update the links so that Worksheet2
points to worksheet1 in the new workbook. However, this means worksheet2 is
no longer filtered correctly. Is it possible to automatically update the
filtering? maybe with a button with underlying VBA code or any alternative
methods anyone can think of

Thanks very much for any help!
cheers