I need to show a years worth of parts and need to hide previous months, but
also have the worksheet move formulas for each new month. Is there a way to
automate this. I haven't used Excel for awhile and am not sure how to
automate this. Currently I have to manually hide the month not needed and
then add a column for my totals and redo all the formulas.