Completed

Excel VBA Macro Automation Needed for Stock Take and to Generate Reports

This project was successfully completed by rajanlengde for $105 AUD in 3 days.

Get free quotes for a project like this
Employer working
Completed by:
Skills Required
Project Budget
$30 - $250 AUD
Completed In
3 days
Total Bids
22
Project Description

Hi all,

We have an Excel with : (See file : stock take and [url removed, login to view])
1) Product initial stock details
2) Cost Price
3) We can also input the sales data into it and it will tell us how much we earn per piece and also which of it needs to be restocked

And everyday we get a sales data in an excel , see file : [url removed, login to view] ,

Now, we want an Excel Macro that automates all of this, it should:
1) Automatically import in the relevant data from sales data into the stock take and profit excel
2) Generate a report showing:
i) Total earnings of the day
ii) List of items that needs to be restocked
iii) Highest selling priced item
iv) Lowest selling priced item
v) Most sold item of the day
vi) Result errors, such as product code unknown, price unknown etc etc

There's a few things to consider
a) Stock take and [url removed, login to view] will have some columns with that "remembers" day to day changes, such as stock level, total quantities sold
b) Some products are more troublesome, for example if we have sku 900 and sku 901, it's easily done, but sometimes we sell them together, like 900+901, it will be quite troublesome to have a separate sku called 900+901. We are open to suggestions on how to solve this :)


Please feel free to have your input on this and we are also open to suggestions if you have better ways of doing what we want.

Thanks again,
Edmond.

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