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.