Date limit on formatting.

[sungen99]

I am trying to add some new flexibility to an existing macro but have been unable to do it successfully.

As it stands now the macro will take the Name on Sheet2 B1, and then sort through the data in Sheet1 and nicely format it by color back on Sheet2 J1:Q.

I now need to be able to limit the date using B2 on Sheet2. So if the data being worked on is greater than that date it should skip it.

Thank you.

[PCI]

Try twice (at least ) and comment

Please Login or Register  to view this content.

[sungen99]

Works perfectly. Thank you!