Thread: Summary sheet
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Dennis Allen Dennis Allen is offline
external usenet poster
 
Posts: 43
Default Summary sheet


"Jack Schitt" wrote in message ...
It is probably not quite what you are looking for, but a "simple" solution
might be to reserve a column in your existing summary sheet to return on
each row either TRUE or FALSE depending on whether the count of "Y" in
column A of the respective sheet dedictated to that row in the summary is
greater than 0. Then autofilter on that column.



Hi. I tried autofilter and it works, but when someone adds a "Y" entry it does not show up on the summary sheet. To get it to show
you have to rerun autofilter. Isn't there something we could use that would be more dynamic?