I'm new to Excel macros and am trying to implement the following functionality. I have 2 tabs in my workbook.
a. Everytime a row is inserted in tab 1, I need to check for whether column A contains string xyz. If it does copy over all the contents of the row and insert row into Tab 2.
b.Everytime a row is deleted in tab 1. cascade the delete to tab 2 - if column a for the row contains the xyz string.
I'm learning macros so if an expert can get me started I'll finish it.
Thanks and appreciate your assistance!