urgent excel macro file needed

I will run the macro on main stock file. Once i run the macro, it should ask me to select the sale data file. I am attaching the sample of sale data file

Essentially once the macro is run, it should do the following:-

Part 1

1) Search for silimar SKU from sales data file and see if they exist in Main stock file

2) If the SKU exist, then check if "fulfillment entity"

2a) If it is "WFS fulfilled": then increase quantity in Total Sold column K by the number appearing in hte sale data file column B.

2b) Check the date stamp appearing in column column A in the sales data file.

Then increase the quantity for the same month in main stock file

For example : if the sale data says month April, then update the quantity in column M.

If the sale data says month May, then update the qunaitty in column N etc

2c) If the fulfillment entity is "seller fulfilled" then DO NOT increase the total sold column K (step 2a) above, but do increase the sale month (step 2b) above

Part 2

Create another macro on main stock file, the purpose of this macro is to find the most popular selling designs within any month (the monthly sales data will come from column M (which is april), column N, which is May, column O which will be June etc

It is important to note that we need the most popular selling design (which is combined total of many different skus belong to that design). For example the first design in the file, it has sku starting from row 2 till row 9

The 3rd design is from row 18 to row 25.

So the goal is to collect the combined monthly sale of all the SKU belonging to each product, and then arrange them based on highest sale to lowest sale, in the most popular design sheet. It will be ok that each time this macro is run, a new sheet is created, so that the old "most popular design sheet" is not overwritten

Skills: Visual Basic, Excel Macros

See more: excel macro reading file, excel macro needed, dat file excel macro, excel macro file names directory, excel macro programmer needed, excel macro file input, excel macro file output, excel macro file write, excel macro file internet, excel macro file processing, excel macro file read write, excel macro progrmmer needed, excel macro file web application, excel macro visual basic help needed urgent, excel macro file merging, excel macro file location, urgent excel macro, open excel macro file online

About the Employer:
( 408 reviews ) Victoria, Canada

Project ID: #30170188

Awarded to:


Hi, I am well versed with automation in Excel using macros and help to write the macro for the stock files. The attachment you mentioned seems to be missing. Kindly share the same. Looking forward to your response. More

$50 USD in 1 day
(108 Reviews)

11 freelancers are bidding on average $48 for this job

(170 Reviews)
(152 Reviews)

Hi, Please share your files to review. They are not attached in descriptions. I have over 10 years of professional Excel VBA experience and have done more then 300 related projects here. I am available to start right More

$35 USD in 1 day
(127 Reviews)
(106 Reviews)
(169 Reviews)

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

$30 USD in 1 day
(84 Reviews)
(31 Reviews)

Hi there, I am Shain – well expert VBA developer with good hands-on experience. I went through your project details and having the basic understanding of your requirement. I can build this macro for you to get quantity More

$40 USD in 3 days
(7 Reviews)

Hi, I am an expert excel programmer. I will be able to do the three task for sure. Please contact me to discuss details. Best Regards, Masud.

$45 USD in 2 days
(0 Reviews)

I have developed macros for a company for years specifically in accounting related area such as inventory accruals

$30 USD in 1 day
(0 Reviews)