Hoping someone has an easy solution but I've basically created a project gantt chart with each column representing one day. Above each month's dates I have a merged cell that displays the name of the month. For ease of reporting I've created a second tab that shows only 4 months worth of data using offset formulas with a scroll bar to scroll through the remainder of the year. Problem is I can't figure out how to scroll by monthly increments. If I scroll by day then because of the merged cells the months don't line up or display correctly. Do I need to change my offset formula somehow to move in monthly increments or do I need to adjust the properties of the scroll bar?
Thanks, Brian
Thanks, Brian