Hello all

This is the scenario:
WorksheetA - have an autofielter
WorksheetB - one to get the autofiltered name from the WorksheetA

WorksheetA - Business Name = Dell
WorksheetB - C3= 'WorksheetA'!A2 This means C3=Dell

BUT if I change the filtering in WorksheetA - Business Name =
Microsoft
my WorksheetB still showing the "Dell" name...I can tell the cell in
WB is not changing as my data change in WA. My question is: how can I
make this dynamically so my cell in WB change as my filter changes?

Thanks