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

[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.

 

[Frank Kabel]

Hi
what do you mean with 'regenerating filter'?

 

[Guest]

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.

 

[Frank Kabel]

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