Build Expense Sheet in Excel 2007

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.

Taidot: Excel, Visual Basic

Näytä lisää: table data structure, lists data structure, data structure coding, build expense excel, expense sheet, expenses sheet excel, excel projekt expense, excel formula sheet, working customer service, customer data excel, vb excel, typing excel, sheet, pivot table excel, expense, excel service, excel pivot, excel pivot table, coding visual basic excel, visual basic excel coding, sample visual basic excel, sheet excel visual basic, basic excel coding, visual tool basic, excel cell

About the Employer:
( 2 reviews ) Paris, United States

Projektin tunnus: #421712