I have a Macros enabled spreadsheet that I import sales data into, which then works out profit on all sales (via page where I enter cost values to SKU's). I would like this spreadsheet edited to be able to accomodate a few extra features.
I would like the spreadsheet to be able to give me an overview of sales for the week/month/quarter/year, I would like it to automaticlly generate data of best selling product/biggest profit items etc.
I would also like to incorporate a stock control element, so I can enter when I buy stock, and it is deducted from the stock as and when it sells (through the use of SKU's) and then this data collated on a weekly, monthly basis to show how much stock is being used on a weekly/monthly basis which will enable me to see trends and also and easy way to see when we are running low on stock.
5 freelancers are bidding on average £228 for this job
Not good with Accounting & Finance but developing Excel macros since 1997. So, if you have a clear vision of what is to be achieved, I can be of assistance. Regards, Svet.
Hi, do you have something more detailed about the things you need? I mean, like a template in the excel with some step/step about how to get each value? Thanks