ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Filter and excluding line item from filter (https://www.excelbanter.com/excel-programming/438377-filter-excluding-line-item-filter.html)

MC[_7_]

Filter and excluding line item from filter
 
Hi,

My excel table look like this
A B C D E
1 ______________________________ (This row, I put a filter to
filter the whole data based text I type in)
2 ID FirstName LastName Street City (This row are my
headers)
3 21 Joe Brown Elm Newyork
4 22 George Gregor 12th Newyok
5
6
.....
number of column are dynamic (will increase or decrease each time I refresh
data from database)

I am trying to put a about 3-4 row NOTES section at the end of the data, now
how can I exclude these Notes section from the filter? (could not put these
notes to footer because, excel only allows 255 char in header/footer)

Thanks
MC



All times are GMT +1. The time now is 09:27 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com