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

IN PROGRESS
Bids
22
Avg Bid (AUD)
$135
Project Budget (AUD)
$30 - $250

Project Description:
Hi all,

We have an Excel with : (See file : stock take and profit.xlsx)
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 : sales2903.csv ,

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 profit.xlsx 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.

Skills required:
Data Entry, Data Processing, Excel
Additional Files: sales2903.csv stock+take+and+profit.xlsx
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 98
in 3 days
$ 105
in 3 days
$ 200
in 10 days
$ 75
in 5 days
$ 99
in 2 days
$ 154
in 3 days
Hire rajanlengde
$ 105
in 3 days
Hire Lotusdeveloper
$ 154
in 3 days
Hire excel4engineers
$ 40
in 3 days
Hire SteveP495
$ 250
in 5 days