I have created a workbook that tracks all my accounts by week.
Rows are account specific
Columns are weeks
I would like to have a macro that will print a snapshot report based on the current week where the report will print 6 weeks(columns) before the current week and 3 weeks(columns) after the current week. The current week columns should be 10% grey with left and right borders so that it is clearly delineated from the rest.
I print this report almost daily.
I have attached an example workbook and printout for reference.
Thank you in advance for your time and aid.
I had a previous thread posted to a different forum.
https://www.excelforum.com/for-other...rent-date.html
Bookmarks