Are you saying i should make that the critera for the filter?

i tried this

Data!$E$5Data!$E$2 as the critera

as well as

Data!$F$2Interface!$B$3 (its across sheets)

all i get from the advanced filter screen is reference is not valid

can you give me more info

"T. Valko" wrote:

Try something like this:

=A8B$3

Where A8 is the first cell of the range to filter.

--
Biff
Microsoft Excel MVP


"Joseph Atie" wrote in message
...
i need to achieve a value 28/08/2009

to achieve this i have a field where the user enters the date they wish to
filter on

this is translated to the filter criteria by the following formula

= "" & B3

the problem is i get a result of 40053

if i put "" around the date i get "28/08/2009"

this does not work with the advanced filter.

help

what formula do i need to achieve my goal