Excel spreadsheet work using LookUp data and product codes to keep track of sales, cost, shipping, profit etc..
$30-250 USD
Paid on delivery
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
Project ID: #4714177
About the project
Awarded to:
4 freelancers are bidding on average $133 for this job
Dear lancanator,Greetings! Highly Qualified and experienced team of professional excel experts here. Thanks. Dhruvika
Hi, i can make this but in C#, so the program logic and interface will be in C#(as you require pretty complex program) and the data will be saved to .xls file, which you can access with/without the program at any time, More
