Hi!
I am trying to get a VBA code that will help me with the attached.
Looking to Paste the top 10 SKUs based on volume and Brand (Column M and Column Q, respectively on "LW SKU Data" tab.)
I would like to Paste these to the tables on the "LW Brand Recap" tab based on the value typed in the green boxes (i.e. A37 shows "Disney", so I would like to paste the top 10 SKU values in A40:A49 that are Disney only, the same for the brands below it.)
Thank you in advance!
Yes - thank you very much!
Yes that worked! Thank you so much!!
Attached. I'm trying to get column "Q" in the "LW SKU Data" tab to paste without blanks or duplicates into column "A" (within the template starting in row "A6") in the "LW Brand Recap" tab. Brand Recap Template_Example.xlsb
Hi,
This is working, BUT I need the values to paste WITHOUT formatting and to remove duplicates & blanks.
Thank you!
Hi there,
I need help to create a VBA code that will allow me to extract values from a list (Column Q) in sheet "LW SKU Data" and paste into another sheet "Brand Recap" to column A (starting in row A14.) I'd want to paste as values, as the list in column Q is using a VLOOKUP to find the values from a different sheet.Lookinng to paste UNNIQUE VALUES with no blanks.
Will someone please tell me the code that would allow this? I am trying to create a template for multiple users, so the values will change depending on the data that is pasted.
Thank you!
