How to lookup a cell value in sheet 1 and copy/paste the value of the adjacent cell into another sheet?

  • Hi,

    I have a workbook with a large amount of information and multiple sheets.

    In Sheet 1, I need to identify numerical values in column A that are >0, then copy and paste the corresponding value on the same row in column B and Column C to Sheet 4 (output sheet). I need to repeat this for Sheets 2 and 3, and paste all information into Sheet 4, then remove duplicates.

    Any help would be greatly appreciated.

    Many thanks

  • Hi, thanks for the response - I am looking for VBA code to copy and paste the Identifier (Column A) and the code (Column B) into Sheet4 Output where the Amount (Column B) >0 in Sheet 1, 2 and 3. I would then like to remove duplicates from the list so that I have a complete list of code which hold an amount >0 for each identifier.

    Thanks for your help.

Participate now!

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