I am after a simple excel sheet that tracks my purchases on weekly bases.
The sheet will look like this:
Supplier Name: Date:
Supplier details: Order #:
Qty Description Net weight Price Total
1. Supplier name would be a drop down list
2. When a supplier name is selected, their details would appear along with their product list.
3. I would than specify the quantity number for order and click purchase
4. After I click purchase I want all the data to be banked in a location, so that every time I click on purchase the data would be saved automatically in a specific location for future retrieval.
Also the date and order number would automatically appear every time I open a new sheet, so that excel would automatically remember how many orders I have done.
I hope that’s all possible within excel.
65 freelancers are bidding on average $72 for this job
Hi, I am vba developer.I have experience in excel(vba and Userform based application , even integration with access DB , SAS, ..).I can provide you the solution.Check PM for details.