Need some ideas how to calculate daily operation costing

Dear all,

I would like to make a tracking report for my promoter sampling activity, currently I facing a few questions that I couldn't find a way to figure out how it should be done in VBA.

As mention above, it is to track my promoter sampling activity costing therefore beside the sample cost below are the things that I need to think of solution to able to get the figure daily, weekly and monthly (To which this report will be done in later part)

1. Cooking Oil (It can be 2kg or 5kg and price different) - (2kg use for 3 days; 5kg use for 6 days)
2. Kitchen Towel (It can be 2 roll or 6 roll per pack - Price may be different) - (1 roll use about 6 days)
3. Toothpick (1 box contain of 1000pcs) - (1 box use about 18 days)

I having a problem to find solution how to calculate the operation cost, as I need to key in the report weekly.

For example:

1/1/16 I bought 5kg cooking oil (last for 6 days), I key in into combo box, but the record will recorded as 5kg cooking oil price and only for that 1-3/1/16 usage. Later on 7/1/16 I still have balance of 2.5kg but how do I key into combo box record? If I key in, it will have double price recorded. If I divided the price earlier and what if I forgot the actual price on 7/7/16, how to I able to key in the correct costing?

Same goes to kitchen towel and toothpick. This problem has keeping my out of idea how to do it in VBA combo box and keep the record in one sheet which later will be use to extract the data out for daily, weekly and monthly summary report.

Any inputs from expert here will be much appreciated.

Thank you!

Hi there, you may refer to attached sample manual file.

Let me know if you didn't understand the file.

Thank you.

Originally Posted by oeldere

1. It would help to see the workbook.

You get better help on your question if you add a small excel file, without confidential information.

Please also add manualy the expected result in your file.

To Attach a File:

1. Scroll down to the window below your post Additional Options
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.

Originally Posted by oeldere

Probably you missed this line.

hi there this is my end result for currently, because the purpose of this sheet its the database.

thats why i need some idea how do i able to achieve this result using combobox based on the problem i have.

thank you.