I have a workbook which consists of 13 worksheets – a summary sheet and then 12 sheets , one for each month of the year.
Each month, I populate the page for the relevant month with fiugres and comments from project reports.
On the summary page, most of the info is pulled forward into the relevant column/cell, i.e. there is a column for each month so it is very straightforward to populate each cell.
But, I have a few cells which only display a single set of data, usually the latest month’s input. Up till now, these cells have been filled manually but I would like to be able to select the month which I want to look at and then have this data pulled through automatically from the relevant sheet.
I wondered if it would be possible to use a drop-down menu containing a list of the months and then, when the month is selected, it goes to the relevant sheet and pulls those few cell’s contents through for me. I could do this on each cell to make it simpler if necessary.
Is it possible or is there another way, e.g. the user typing in the month or tab name?
Any help would be very much appreciated.