| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel auto-filter does not filter certain columns | Excel Discussion (Misc queries) | |||
| DataFilterAuto Filter in excel 2007? | New Users to Excel | |||
| Excel 2007 Auto Filter Filter | Excel Discussion (Misc queries) | |||
| Limit filter options in Auto Filter | Excel Discussion (Misc queries) | |||
| Excel auto filter doesn't recoginize case - won't filter AA from A | Excel Discussion (Misc queries) | |||
Hybrid Mode
