Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto insert/delete on other sheet
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
insert nd delete row in protect sheet | Excel Discussion (Misc queries) | |||
Capturing Insert/Delete Events in Excel Sheet using c# | Excel Worksheet Functions | |||
Macro auto insert/delete | Excel Discussion (Misc queries) | |||
how to insert row or delete while the auto filter is turn on? | Excel Discussion (Misc queries) | |||
Auto-Insert & Delete Comments | Excel Programming |