I am hoping to some help with a formula. I use the attached spreadsheet to track professional development within our organization. I know it would be much easier to create a Access database for all this spreadsheet is doing but for reasons I don’t quite understand we do not have Access available to us. So I created this spreadsheet last year so we are able to track and analyze our professional development for staff in 1 centralized location. The spreadsheet is also used to summarize the budget. I have a tab called Budget Summary that refers to the tab that the data is collected. Rather than create a new spreadsheet for 2015 I think it would be much to add a Budget summary tab for each year and continue to collect the data in the same spreadsheet so I am able to look at data through pivot tables over the years. My problem is that I did not not think of this last year when I created the spreadsheet. The formulas I created do not allow for a separation of year. I have added a column on the Data tab for “Year of Event” and I have to create formulas that will let me add another condition that will separate the year. On the Budget Summary tab I have a “Reimbursed Summary” and a “Budget Code Summary” and I am struggling to come up with an adjustment to the current formulas or a new formula that will do this. Formulas in both summaries are doing quite a bit already so I am no sure if it is even possible to keep everything they are doing now and still be able to separate the year. My plan would be to have a Budget Summary tab for each year. If anyone is able to help it would make this spreadsheet so much more functional for me. I have deleted a lot rows from the Data tab. We have a very large number of events for our organization that this spreadsheet tracks. I have also removed employee names and info. I think you can tell by reading the formulas what exactly they are doing but I can clarify if needed.
Thanks s much in advance to anyone even willing to try
Bookmarks