Hi Team,
i have need to compare two sheet and identify the new item and deleted item using the below formula on column C on respective Sheets
Can you help me with the macro with the Formula and Copy the line Respective Sheets.
Sheet 1 - Rows with Value "New Item" to New item Sheet
Sheet 2 - Rows With Value "Deleted Item" to Deleted item sheet
i have need to compare two sheet and identify the new item and deleted item using the below formula on column C on respective Sheets
Can you help me with the macro with the Formula and Copy the line Respective Sheets.
Sheet 1 - Rows with Value "New Item" to New item Sheet
Sheet 2 - Rows With Value "Deleted Item" to Deleted item sheet