The excel workbook is used to dump financial data into it and then using vlookups I have a summary sheet which graphs financial data on a specific team depending on which team code is selected in the data validation drop down box.
Ideally i would look to convert this as a web page but be able to have the same drop down functionality so that various (non excel) people can see various teams performances
Nope. What is that?
The firm have recently purchased sharepoint whether that is something that can help?