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ää: what is data structure in c, what is data in data structure, table data structure, lists data structure, data structure coding, build expense excel, expense sheet, expenses sheet excel, excel projekt expense, tableau data analysis freelance, sample operational expenses excel sheet, excel formula sheet, working in customer service, vb in excel, customer data in excel, vb excel, typing in excel, typing excel, sheet, pivot table excel, expense, excel table, excel service, excel PIVOT, excel pivot table

Tietoa työnantajasta:
( 2 arvostelua ) Paris, United States

Projektin tunnus: #421712