Re: Advanced Filter

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I think it's the List that's causing the trouble.

The list likes to expand horizontally and vertically when you add data to it
(you can see the list border expand).

When I removed the list, I didn't have any trouble.

So I think the choices are remove the list or move over to a non-adjacent
column.

ps.

You wrote this:
I select the List at G4
I like to select the range (G4:g13) to start. Then I don't have to change the
range in the dialog.

Johnny wrote:

Hi Thanks for your continued help
Ok I have a workseet called *** 1.
Row 1 Columns A to I inclusive had column names.
Row 2 is blank
Row 3 Column A to I include has the same column names as in Row 1
Rows 4 to 13 inclusive contain test data.

A4 to I13 is a list (I'm using Office 2003)

In G2 I place the text string on which I want to filter
I select the List at G4
I select Data > Filter > Advanced Filter
The dialog box appears. I select Copy to another location radio button.
In the Copy to box:
If I type (or use the selector, or click in the cell) Sheet1!J4 or $j$4 or
J4, and press the OK button. I get the column names appearing in row 4 and
the error message as mentioned.
If I select Copy to A15 or J3 or J5 or K4 the filter works perfectly.

I am totally befuddled as to why it will not work if I select J4 as the copy
to cell

Alex



--

Dave Peterson
.

Quantcast