The Doctor
Member
So I've got a worksheet that uses formulas to project payroll for the year. The problem is that anything more than about a month ahead of right now is really un-reliable. As the pay period approaches the data becomes better. So what I want to do is create a dashboard that only shows the user a segment of data based on today's date. I have a cell using the =today() formula to automatically adjust the date, and a helper column to find the row to start with.
So starting from the row in which today's date lies I need to see 3 rows above and 4 rows below. I have thought about using an index/match and offset formula, but it seems like that could get messy. So I think VBA would work better, I'm just not sure where to begin.
A Sample of the table which holds the data can be found at https://www.dropbox.com/s/czlmv3db7mt41u1/projection%20problem.xlsx
As always, thanks for your help Ninjas
So starting from the row in which today's date lies I need to see 3 rows above and 4 rows below. I have thought about using an index/match and offset formula, but it seems like that could get messy. So I think VBA would work better, I'm just not sure where to begin.
A Sample of the table which holds the data can be found at https://www.dropbox.com/s/czlmv3db7mt41u1/projection%20problem.xlsx
As always, thanks for your help Ninjas