drums4monty
10-06-2008, 09:28 AM
Hi
I have a workbook with 2 worksheets. In Col A of both sheets is a ref number. I need to check both sheets and if the ref number appears on both sheets, and there is no data (currency figure) in Col E of Sheet 1 delete the row, but if there is data (currency figure) in Col E of Sheet 1, keep it. The sheets could be of different row lengths.
Can anyone out there help?
Alan
I have a workbook with 2 worksheets. In Col A of both sheets is a ref number. I need to check both sheets and if the ref number appears on both sheets, and there is no data (currency figure) in Col E of Sheet 1 delete the row, but if there is data (currency figure) in Col E of Sheet 1, keep it. The sheets could be of different row lengths.
Can anyone out there help?
Alan