Hi Again
I've got this spreadsheet, it's quite large and will only get larger!
On the sheet Everything, it will be a large data dump for various school subscriptions, and costings. At the moment I'm still figuring out how best to lay this out and actually navigate it easier. At the far right in BU to CB we have totals which we invoice/charge for the year - each column/service we charge separately.
What I want to do is on another sheet Sheet1 is to create a finance tool, so that when a service is selected in a drop down in say B6 it will pull information from the Everything sheet (so if I selected Governor Services it will pull through the school, type, dfe, total amount for Governor Services, a supplier number and cost centre)
If anything, this will help us to be a bit more efficient in setting up our billing.
I've tried using INDEX and MATCH - however the results don't seem to start from row 3 and are more randomised!
There is also the issue where, I don't think merged cells play well in formulas? The headers for the table, above them are merged cells which entitle each set of columns to show which service they represent.
Any help would be appreciated for this tool - and any tips for a more user friendly database experience would also be welcomed!
Bookmarks