Tuesday, November 5, 2013

Copy Values from one sheet to another but skip cells with conditionality

Copy values from column A of 'new' worksheet to column A of old worksheet.
Skip the cells that contain N/A or '0' in 'new' worksheet.
Change the color (make yello) of those cells in 'old' worksheet whose values were replaced.



No comments:

Post a Comment