Hi,
In excel 2013 I applied a "filter" so that you can eliminate certain things & then saved the file..........over the weekend my spreadsheets sheet 1 updated but sheet 2 didnt. So, the filter didn't update/ hold its criteria, I had to go in and reapply filter.
Is there a way for the filter to auto update?
Sheet 1 has data, Sheet 2 is just linked to sheet 1 with a filter for 1 particular person
when data is added to sheet 1, its doesn't auto update in sheet 2.
Thx
PS. Shg had suggested (view->custom view) but that isn't working
Bookmarks