Closed

Add Features to a Macro Enabled Spreadsheet

This project received 5 bids from talented freelancers with an average bid price of £228 GBP.

Get free quotes for a project like this
Employer working
Project Budget
£20 - £250 GBP
Total Bids
5
Project Description

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.

Best Regards,

Ben

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online