Hi all,
I'm after some help if you will.
I have a single worksheet that has every day of the financial year (as from 17th June) on it starting in cell C5 through to Cell KD5 (being 31st March 2014).
I am looking to only show data from today back 2 weeks so it will be a rolling 2 week period. Within the data I have columns A and B which need to be visable at all times.
Does anyone have any ideas either with VBA/Macros or another solution how I would be able to do this. I had it in my mind that when you open the workbook the code automatically runs to show the day you open the file back 2 weeks.
I'm really hoping someone can help as I have been racking my brain trying to work out how I can do it.
I am using Excel 2010.
Many Thanks
Jon
I'm after some help if you will.
I have a single worksheet that has every day of the financial year (as from 17th June) on it starting in cell C5 through to Cell KD5 (being 31st March 2014).
I am looking to only show data from today back 2 weeks so it will be a rolling 2 week period. Within the data I have columns A and B which need to be visable at all times.
Does anyone have any ideas either with VBA/Macros or another solution how I would be able to do this. I had it in my mind that when you open the workbook the code automatically runs to show the day you open the file back 2 weeks.
I'm really hoping someone can help as I have been racking my brain trying to work out how I can do it.
I am using Excel 2010.
Many Thanks
Jon