Creating an adjustable timeline

[pmk11]

Hello everyone,


I have a workbook with a large database in the first worksheet, the second worksheet is a monthly time line that looks like this:


Jun-12 Jul-12 Aug-12 .......

Project x 12,000 12,900 13,800

Project y .......


I am trying to set up a timeline with cells, or drop down menus, or at least something convenient in which you can pick your range of months (or year) that you want to look at and the timline will automatically update.


I was thinking if I could find a user friendly way to quickly change the date rows, I could have some kind of lookup function automatically pulling from the data. So all i really need is a way to quickly update the dates row (we will call it row 1 of my little example).


Thank you.

Mark

 

[Hui]

Mark


When working with Dates as months I always use the first day of the month as a reference

eg 1/June/2012 and then use custom formatting to display the cells as Jun-12


You can then use formulas to extend the dates automatically

say B1 has 1/6/2012

in C1 I would use =Eomonth(B1,0)+1 which will return 1/7/2012

then format that as mmm-yy


Then it is a simple matter of using Index/Match or Offset to retrieve the values from your main data table and populate your report