This is probably going to sound too difficult but I really can't figure it out.
I want to create a excel spreadsheet where I can select any of my companies names from a drop down list and this will then given me all the data for that company on the spreadsheet.
For example
I click on the drop down list 'ABE' Which is the first company..
This then pulls all the data for that company. In this case ... all its bookings for 2017, 2016 and 2015 in separate columns. These are also broken down into sectors. (UK,Ilse of man, Ireland and Europe) It would also pull If it is up or down on prior year and what the total number of bookings are combined from each sector.
Lastly I need the data to be editable. SO I can click ABE, it brings the data up and I can change the amount of bookings etc as its done monthly.
I have no idea it this is possible to do but any help at all would be really appreciated!
Thanks a lot
Bookmarks