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