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.