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
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.
Thanks
$50 USD in 1 day
5.0 (153 reviews)
6.6
6.6
10 freelancers are bidding on average $48 USD for this job
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 away and can complete macros within couple of hours.
Lets start and get it done quickly.
Thanks
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 of ‘SKU fulfillment’ and ‘Popular design sheet’.
Please send me the sample data and let us discuss more about it.
Thank you!