Tks Again Ossie,
Here is the code I recorded under sheet €œRecords€�, .
Selection.AutoFilter
Selection.AutoFilter Field:=5, Criteria1:="000600" (value of sheet
€œOda Input€� cell J19)
Selection.AutoFilter Field:=2 'Criteria1:="AAAAAA" (value of sheet €œOda
Input€� cell J20)
Selection.AutoFilter Field:=21, Criteria1:="ADD" (value of sheet €œOda
Input€� cell J22)
Selection.AutoFilter Field:=3, Criteria1:="activate" (value of sheet
€œOda Input€� cell J35)
Selection.AutoFilter Field:=16, Criteria1:="mm dd hh:mm" (output of a
formula that value between sheet €œOda Input€� cell J36 & J38)


"OssieMac" wrote:

Hi again,

We are obviously in a very different time zone and hense the delay in some
of my replies. It is currently 7:30am here. I have to go out for a couple of
hours and then I will get back on this to provide the answer as soon as
possible. I think that I understand now what you are trying to achieve.
However, I would like you to do one more thing for me and then perhaps we can
be sure of getting it correct. (I should have thought of this with my last
post because it is the best way to tell me exactly how you want the filters
set).

In your Records sheet ensure that all filters are set to All. (Turn
AutoFilter off then on again).

Turn on the Macro recorder.
Set the required filters manually.
Turn off the Macro recorder.
Post the code exactly as recorded.

--
Regards,

OssieMac