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.
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
