Sort by Date Based on Today() Value

[mattman123]

Hello,

I need help building a macro that does the following:

1) Hides columns E, G, H, I, K, M, O, P, Q, R, S, X, Y, Z, AA-AQ
2) Filters data by column U (which is a list of dates) to only show the values from the last calendar week
3) Saves to a folder called "Data_Folder" at C: -> Data_Folder

Thank you!
Matt

[mattman123]

I found a work around way to do this by putting the days of the week into separate cells. Quick question on a macro auto filter with multiple cell values. I have this code:

Please Login or Register  to view this content.

How can I filter that will yield results that combine values from AT2:AT8?

[mattman123]

For those interested...

Please Login or Register  to view this content.