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

In Progress

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.

Skills: Data Entry, Data Processing, Excel

See more: vba stock, sell excel automation, stock macro, excel vba macro file, sell macro excel, excel vba stock code, vba automation report, generate report excel vba, automation reports vba, vba macro generate product, excel macro automation, generate reports excel, vba excel can stock, vba report automation, stock details excel vba, stock excel reports, price for vba for excel, how to get into sales, excel macro how to, data entry macro, daracon, how to get excel for free, excel vba with, excel vba and, excel 2013 vba

About the Employer:
( 12 reviews ) burwood east, Australia

Project ID: #4378682

Awarded to:

rajanlengde

I can do this well please see PMB for details.

$105 AUD in 3 days
(6 Reviews)
3.5

22 freelancers are bidding on average $135 for this job

sonarkaushik

Sir, I can do the project. Refer PMB. Looking for further discussions in this matter. with thanks and regards

$98 AUD in 3 days
(59 Reviews)
5.7
dangersystem

Dear sir, I am a professional data entry worker & can complete this project with your requirements, please see my private message for details!!

$105 AUD in 3 days
(45 Reviews)
4.8
jal540

I have developed many custom Excel applications using VBA. I have excellent ratings.

$200 AUD in 10 days
(11 Reviews)
4.2
seaanddream

Hi, your excel vba coding expert here. I believe you prefer to work with a top-rated freelancer to have the best result. Regards,

$75 AUD in 5 days
(13 Reviews)
3.6
Tablassus

More than 15 years of programming experience. Professional VBA solutions and webscraping, data mining and automated bots. Please check a few sample works in PM. Best regards Filipe Francisco , VB Expert =============== More

$99 AUD in 2 days
(9 Reviews)
3.6
vikashgadia

we are macro specialist would like to offer our services to u..

$154 AUD in 3 days
(14 Reviews)
3.5
Lotusdeveloper

Dear Sir, I am interested to work on this project. I have more than 10 years of exp in software development field. I have good experience in Lotus Notes, VBA, Crystal report, MS SQL and MySQL. I have also good exper More

$154 AUD in 3 days
(18 Reviews)
3.2
excel4engineers

Please check my private message to get my exclusive offer.

$40 AUD in 3 days
(9 Reviews)
3.0
SteveP495

Excel (inc VBA) expert here (and teach the same). Am currently finishing off two business related spreadsheets (cashflow related) and am available for start probably tomorrow. My pedigree in your PM. SteveP.

$250 AUD in 5 days
(1 Review)
2.8
isupportu

Hi, I can Do this :-) Please check PM..

$110 AUD in 2 days
(5 Reviews)
2.7
srdas2012

Hi VBA /VB Expert can bring almost Vb in Excel macro

$182 AUD in 8 days
(2 Reviews)
2.1
paintthesky14

Hi Daracon, I can very well do this project. I saw both the sheets and have some ideas on this. Please refer to your PMB for further details and attachments. I am sure you are gonna love this :) Regards More

$154 AUD in 7 days
(2 Reviews)
2.0
mjl78

I am a successdul freelancer with 20 years experience with excel and also know visual basic (VB). Automating data transfers from one excel file to another is a process I know very well, as well as creating necessary r More

$137 AUD in 3 days
(3 Reviews)
1.9
TCNGraphicExpert

Understood your project requirements. Ready to create automate task. We're professional Excel VBA Macro expert, and our solution for will complete your project. So, consider our bid to get started. Regards

$200 AUD in 10 days
(1 Review)
1.6
suriyant

With 10+ years Excel and VBA programming. I read to start.

$132 AUD in 2 days
(1 Review)
1.0
martinbaralis

Dear daracon, I am the best freelancer for this project, i have got a lot experience although to be new in freelancer.com. Actually i am working in this kind of projects.

$100 AUD in 3 days
(0 Reviews)
0.0
igotmail9

Dear Sponsor, Please see my PM. With warm regards, Krishna

$150 AUD in 5 days
(0 Reviews)
0.0
sudewa

Hi, I can do this project for you. I can send you an example macro I have done to show my Excel skills. Thanks, Sudewa

$250 AUD in 3 days
(0 Reviews)
0.0
kaushikdass

I have check your files, I will arrange the same according to your need.

$137 AUD in 3 days
(0 Reviews)
0.0
amar198amar198

Hi, I've 12+years of development experience in VB 6.0 and VBA projects. Would complete this project quickly and accurately.

$100 AUD in 3 days
(0 Reviews)
0.0