I am attaching a spreadsheet that needs formula(s) in the yearly report tab. I would like to be able place the year, for ex: 2011, in cell A17. I would then like the report to populate information from the data tab into the yearly report tab so that the schedule shows the entire year's activity in the schedule, the end date and start date cells in B21 and B22 respectively show the dates of year jan1/dec31, and the info in row 17 generates all of the information as the title requests. As it is now, it only works for a specific period of time. I need an entire year. Any help would be greatly appreciated.