"Thanks, Joe. I'm not an Excel wizard, but I think I can follow what you're doing. My customers have history going back 7+ years - I guess I would have to have a reference page for all possible periods, including future ones.…"
"I have a control sheet that has 3 parts: Current period and year, Date table, and format area. The current period and year is NOT the one for accounting system but for the reports. The date table has all 12 or 13 periods listed with columns for some…"