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!