E
erick-flores
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
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