I have two sheets in my workbook, sheet1 and sheet2.
Is it possible to create some sort of function or macro that can
automatically delete/insert the same row in sheet2 if I delete/insert
row(s) in sheet1 ?
For example, if I Insert Row 15 in sheet1 and it also will insert Row
15 in sheet2, Delete Row 20 in sheet1 and it will delete Row 20 in
sheet2.
I try to use event change, but don't know how to combine it with onkey
{insert/delete).
Please help.
Thanks