Suoritettu

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

Taidot: Visual Basic, Excel Macros

Näytä lisää: 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

Tietoa työnantajasta:
( 408 arvostelua ) Victoria, Canada

Projektin tunnus: #30170188

Myönnetty käyttäjälle:

finecodervw

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. Lisää

$50 USD 1 päivässä
(108 Arvostelua)
6.4

11 freelanceria on tarjonnut keskimäärin $48 tähän työhön

(170 arvostelua)
6.7
(152 arvostelua)
6.7
mrbrave

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 Lisää

$35 USD 1 päivässä
(127 arvostelua)
6.4
(106 arvostelua)
6.2
(169 arvostelua)
6.0
writingapp

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

$30 USD 1 päivässä
(84 arvostelua)
5.6
(31 arvostelua)
4.3
ShainJoy

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 Lisää

$40 USD 3 päivässä
(7 arvostelua)
2.6
masud4096

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 2 päivässä
(0 arvostelua)
0.0
asugihar

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

$30 USD 1 päivässä
(0 arvostelua)
0.0