How do I get formulas referencing cells on other tabs to automatic

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have "=IF" functions in multiple tabs (worksheets) that display information
or not depending on the contents of targeted cells in a central tab. I
noticed that when I add entries in the central tab, the referencing tabs
never regenerate what displays. For example, a tab in which the formula
conditions matched (so it should show) a newly added central tab entry does
not show. I have to force it to show by regenerating the filter that blocks
out unwanted items from displaying.
 
Each tab is meant to show only the information from the "central tab" if it
matches a certain criteria, i.e. only showing the information if it matches a
specific department within a larger organization. The filter I have is meant
to show only those items (for that department within the organizatin) whose
status equals either 'open' or 'done.' So, I have a custom filter to provide
for this.

When I make new entries in the "central tab," I have to go into each
referencing tab and re-invoke the custom filter in order for the new items to
show.
 
Hi
if you need something dynamic you can either:
- use array formulas (quite slow)
- add some code to the worksheet_activate event to refresh your filter
 
Back
Top