Use VBA to Copy & Paste Unique Value from One Worksheet to Another (Paste as Values)

Important Notice

Please note that on 14th December 2023 users will experience an expected outage whilst we make upgrades to our network. We anticipate this process may take a couple of hours and so we apologise in advance for any inconvenience.

  • 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!

  • You will need to edit the sheet numbers to match your workbook :

  • Hi,

    This is working, BUT I need the values to paste WITHOUT formatting and to remove duplicates & blanks.

    Thank you!

  • Hello JH,

    Another option:-

    I hope that this helps.



  • You're welcome JH. I'm glad to have been able to assist.

    I gather that you worked out how to change the destination target from A14 to A6 (opening post/post #5).

    Good luck with your project.



Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!