Conditional Date Filter in Macro

[boliver228]

Hi,

I am having trouble setting conditional date filters for a column using a macro. I have two columns, A&B, each with dates in each cell. I want to filter column B to show dates that are less than or equal the corresponding cell in column A.

For example: A1=10th June 2014, B1=11th June 2014 --> The filter is set on column B, and B1 is excluded as it is not <= A1.

Any help is much appreciated.

[nathansav]

Start recording macros and looking at the code, i did this is less than a minute and just altered the criteria recorded.

Please Login or Register  to view this content.