ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   ranging the filter cells when doing auto filter (https://www.excelbanter.com/excel-programming/388011-ranging-filter-cells-when-doing-auto-filter.html)

thread

ranging the filter cells when doing auto filter
 
Hi all,
its it posible to include for example row 4 as header rows and from
row 9 and under to use it for the auto filter?


Norman Jones

ranging the filter cells when doing auto filter
 
Hi Thread,

its it posible to include for example row 4 as header rows and from
row 9 and under to use it for the auto filter?


If I understand you correctly, I do not think that this is
possible; rows 5-8 would fe included in any autofilter
operation.


---
Regards,
Norman



thread

ranging the filter cells when doing auto filter
 
so there is no other solution to this matter?
Norman Jones כתב:
Hi Thread,

its it posible to include for example row 4 as header rows and from
row 9 and under to use it for the auto filter?


If I understand you correctly, I do not think that this is
possible; rows 5-8 would fe included in any autofilter
operation.


---
Regards,
Norman



Norman Jones

ranging the filter cells when doing auto filter
 
Hi Thread,

Why can you not insert / move the header row
immediately before the first autofilter data row?


---
Regards,
Norman



"thread" wrote in message
ups.com...
so there is no other solution to this matter?
Norman Jones ???:
Hi Thread,

its it posible to include for example row 4 as header rows and from
row 9 and under to use it for the auto filter?


If I understand you correctly, I do not think that this is
possible; rows 5-8 would fe included in any autofilter
operation.


---
Regards,
Norman




thread

ranging the filter cells when doing auto filter
 
so there is no other way to overcome this issue?

Norman Jones כתב:
Hi Thread,

its it posible to include for example row 4 as header rows and from
row 9 and under to use it for the auto filter?


If I understand you correctly, I do not think that this is
possible; rows 5-8 would fe included in any autofilter
operation.


---
Regards,
Norman



thread

ranging the filter cells when doing auto filter
 
so there is no other way to overcome this issue?

Norman Jones כתב:
Hi Thread,

its it posible to include for example row 4 as header rows and from
row 9 and under to use it for the auto filter?


If I understand you correctly, I do not think that this is
possible; rows 5-8 would fe included in any autofilter
operation.


---
Regards,
Norman



Norman Jones

ranging the filter cells when doing auto filter
 
Hi Thread,

As indicated, I think that you should reconsider your
data arrangement.

Why can you not insert / move the header row
immediately before the first autofilter data row?


---
Regards,
Norman


"thread" wrote in message
ups.com...
so there is no other way to overcome this issue?

Norman Jones ???:
Hi Thread,

its it posible to include for example row 4 as header rows and from
row 9 and under to use it for the auto filter?


If I understand you correctly, I do not think that this is
possible; rows 5-8 would fe included in any autofilter
operation.


---
Regards,
Norman




thread

ranging the filter cells when doing auto filter
 
so there is no other way here?

Norman Jones כתב:
Hi Thread,

its it posible to include for example row 4 as header rows and from
row 9 and under to use it for the auto filter?


If I understand you correctly, I do not think that this is
possible; rows 5-8 would fe included in any autofilter
operation.


---
Regards,
Norman



Norman Jones

ranging the filter cells when doing auto filter
 
Hi Thread,

'-------------
so there is no other way here?
'-------------

See my reponse to your last post.


---
Regards,
Norman







All times are GMT +1. The time now is 12:04 AM.

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