Jeremy has attended:
Excel Intermediate course
Filters
How can I apply filters to sheets that apply to multipul pages. For example I can apply filters in the data range but it only seem to apply to the page selected and not the rest of the sheet.
RE: Filters
Hi Jeremy
Hope you enjoyed the course on Tuesday, the answer to your question is a simply one but not the one you were hoping for you can not apply filters to the multi sheets at the same time, but you can apply filter to seperate sheet at anytime but the difference is that this type of filter one sheet at a time will only apply to the sheet you are on
If this posting has helped in answering your query then I would request you to mark the posting as Resolved. If, however, it hasn