Thread: Macro to run Auto Filter based on the contents of another cell on another sheet.

Hi, Im trying to find a macro that will run the auto filter function.

I have a list of dates (1000's of lines) in sheet 2, cell H5 contains the Auto Filter.

Id line to input a date into cell B18 of sheet 1, and for that date to trigger the auto filter and results..

Due to the operating restrictions on this PC i cannot upload a sample file.

Hope some one can help?

Thanks.

Can anyone help?

Thanks in advance

B