Hi,
I have put together a spreadsheet that shows all the holidays booked for the people in my department with each month on a separate tab. I am also in the process of creating a central shared spreadsheet where anyone can go in and have access to this information, I would like to know if there is anyway for me to create a formula that finds the relevant tab first before running the lookup I require as the central spreadsheet will have a drop-down menu of the months so ideally the formula would find the tab relevant to the month and then bring back all the holidays booked for that month.
I'm not very clued up on Excel Databases or VBA's so if I can avoid using them I would prefer to but if that's my only option I'll be doing some weekend reading.
I hope thats easy enough to understand, if not I can upload an example.
Thanks
I have put together a spreadsheet that shows all the holidays booked for the people in my department with each month on a separate tab. I am also in the process of creating a central shared spreadsheet where anyone can go in and have access to this information, I would like to know if there is anyway for me to create a formula that finds the relevant tab first before running the lookup I require as the central spreadsheet will have a drop-down menu of the months so ideally the formula would find the tab relevant to the month and then bring back all the holidays booked for that month.
I'm not very clued up on Excel Databases or VBA's so if I can avoid using them I would prefer to but if that's my only option I'll be doing some weekend reading.
I hope thats easy enough to understand, if not I can upload an example.
Thanks
