Urgent Excel Macro work needed

Completed Posted 2 years ago Paid on delivery
Completed Paid on delivery

I need to have macro file, which will do the following calculations:-

There will be 2 files to compare. Master File. And Inventory file whic.

Master file keeps track of all our INITIAL stock left to sell.

INVENTORY file shows the CURRENT stock left to sell.

The difference between the MASTER and INVENTORY file, shows the stock which has sold over this period.

Each inventory has a unique SKU number in column H (in the Master file)

We need 2 macros mades:-

1st Macro) Update Master File

When we run the macro, the macro should ask us to select the Master file and the inventory file (the samples are attached).

Then the following should happen:-

1) In the Masterfile, the macro would add a new column, with the date and time stamp when this marco was run. Then the macro would simply find the matching SKU numbers in the inventory file, and show this corressponding numbers with the same SKU number in Master file

2) If Inventory file has any unique SKU numbers which cannot be found in Master file, then macro should make a text file, with those SKU numbers and quantity of that item in stock

2nd Macro:

This macro would run over the Master file only. When we run this macro, it should ask us, which 2 columns of date data we want to select. For example, we select column K and column L.

THen the macro would run, and create a new output file, "Sales from date range" and give us only those SKU data which have sold over this date range. For example if an SKU sold, then all the data related to that SKU would be in this output file

The skus should be grouped togehter based on Master file SKU group

This is very urgent work and it needs to be done by today.

Visual Basic Excel Macros Excel VBA

Project ID: #30069920

About the project

5 proposals Remote project Active 2 years ago

Awarded to:

(586 Reviews)
7.7

5 freelancers are bidding on average $72 for this job

writingapp

Hi. I have written many automation Excel VBA macros. Ready to write your project. Will complete within some hours

$60 USD in 1 day
(90 Reviews)
5.6
Wanngming

Hi, bro! I have read your requirement and I noticed that I am appropriate to this project. I have rich experience with data processing using Excel formula and VBA. Everyone call me a "Prince of Excel". I promise I will More

$50 USD in 1 day
(4 Reviews)
2.4
ashwinolakiya8

i am a good candidate for this project to hard working and data admin copy paste certificate candidate

$50 USD in 2 days
(0 Reviews)
0.0