I am creating a worbook to generate month end reports. I'd like to pull figures from the various budget sheets into the reporting sheets for the current month and year to date by setting up a variables sheet and I think the "Choose" function but my experimentations have proven me incapable of doing so.
What I'd like to do is set my month in the variables sheet to the month I want to report in, eg "Feb" and have the budgets pull through automatically. I've a feeling that this is pretty simple and I'd appreciate any help given. I've attached the workbook and highlighted one of the sheets and the columns that I'm trying (and failing miserably) to work with.
Thanks in advance.
Bookmarks