Need to build an Expense Tracking sheet in Excel. Ultimately, the sheet will interface with Quickbooks. In order to create a user friendly tool, I need to have each of the following lists (pivot table data from quickooks), autocomplete/limit choices while typing in a given cell. There will be four columns: Vendor, Customer, Service Item, Class. Each column is it own pivot table.
From what I can tell [url removed, login to view] links basically spells out how I want it to work with some actual coding. But I dont know VB.
I have attached a sample files so that you may understand the basic structure I am working with.