View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
RWilliams RWilliams is offline
external usenet poster
 
Posts: 14
Default Re-running an AutoFilter filter when applied to a hidden column ..

I think this is simple but ..

I have AutoFilter on and specific filters on a number of columns - some of
the columns with filters are hidden. One of the filters is applied to a
column that gets its data from another workbook - if i change the data in the
other workbook and therefore want to reapply the filter, can i do this
without having to unhide the column?

Hope this makes sense ..
--
Thanks and have a good day

Ruth