Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Mifty
 
Posts: n/a
Default Advanced Filter - error message

Hi there,

Can anyone tell me what the following message means and how to stop it please

'The extract range has a missing or illegal field name'

In simple language please - not even sure what extract range and field name
are.

The filter works. It puts the data expected into the cell I tell it to but
an error message pops up afterwards.

I would be grateful for any answers.

Cheers
Mifty
--
Mifty
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Debra Dalgleish
 
Posts: n/a
Default Advanced Filter - error message

The extract range is where you want the filter results to start. The
range can be blank, or can contain headings that exactly match headings
from the source table. (You can use some or all of the headings from the
source table.)

A field is a column in the source table.

Usually you get that message if a heading in the extract range isn't
identical to one of the headings in the source table.

Mifty wrote:
Hi there,

Can anyone tell me what the following message means and how to stop it please

'The extract range has a missing or illegal field name'

In simple language please - not even sure what extract range and field name
are.

The filter works. It puts the data expected into the cell I tell it to but
an error message pops up afterwards.

I would be grateful for any answers.

Cheers
Mifty



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

  #3   Report Post  
Posted to microsoft.public.excel.newusers
Mifty
 
Posts: n/a
Default Advanced Filter - error message

Many thanks for your reply. Will have another try and let you know
--
Mifty


"Debra Dalgleish" wrote:

The extract range is where you want the filter results to start. The
range can be blank, or can contain headings that exactly match headings
from the source table. (You can use some or all of the headings from the
source table.)

A field is a column in the source table.

Usually you get that message if a heading in the extract range isn't
identical to one of the headings in the source table.

Mifty wrote:
Hi there,

Can anyone tell me what the following message means and how to stop it please

'The extract range has a missing or illegal field name'

In simple language please - not even sure what extract range and field name
are.

The filter works. It puts the data expected into the cell I tell it to but
an error message pops up afterwards.

I would be grateful for any answers.

Cheers
Mifty



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem using Advanced filter anandmr65 Excel Discussion (Misc queries) 1 April 17th 06 10:14 AM
Hiding advanced filter umba-sr Excel Discussion (Misc queries) 1 March 30th 06 01:42 PM
Refresh advanced filter Dan Excel Discussion (Misc queries) 1 March 25th 06 01:33 AM
advanced filter BorisS Excel Worksheet Functions 1 January 13th 06 05:30 PM
advanced filter won't allow me to filter on bracketed text (-456.2 LucianoG Excel Discussion (Misc queries) 1 December 6th 04 08:38 PM


All times are GMT +1. The time now is 02:29 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"