Excel spreadsheet work using LookUp data and product codes to keep track of sales, cost, shipping, profit etc..

Hello,

I am looking for someone to make an excel spreadsheet to keep track of my sales and costs. I have had similar ones before, that work with LookUp data and VLookUp. Basically I need a weekly sheet that also totals monthly/yearly and works with product codes. When the individual product code is entered, I need the fixed values for the shipping cost, drop shipping cost, and cost of the individual components of the products to appear automatically and total up at the bottom of the page and also at the weekly, monthly, and yearly tab. I also want it to have the ability to factor in multiple orders of the same product. For example, there could be a column that accounts for quantity. I have about 50 codes to begin with, but want the ability to add another 100+. I have attached an example of a similar sheet that I have used in the past to help get the idea, but this one is very complicated and had a lot of bugs. I need one that is more simple and works properly.

Please contact me if you have any questions.

Thanks

엑셀

프로젝트 ID: #4714177

프로젝트 소개