Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Inserting a row in sheet A should Insert a row in sheet B, removing a row in Sheet A should remove the corresponding row in sheet B
Hi,
I need a excel programming which does the following: Whenever I insert a row in sheet A a corresponding row in sheet B needs to be inserted. The correspondence is given by a offset to a named top row When removing a row in sheet A the corresponding row in sheet B should be removed. How can I react on insertion and deletion in excel? Best regards Hannes |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Inserting a row in sheet A should Insert a row in sheet B, removing a row in Sheet A should remove the corresponding row in sheet B
Hannes,
There is no row insert or delete events to react to, so you need to build a macro that does the initial delete and handles the consequence, like myRow = 8 Worksheets("SheetB").Rows(8).entirerow.delete Worksheets("SheetA").Rows(8).entirerow.delete and myRow = 8 Worksheets("SheetB").Rows(8).entirerow.insert Worksheets("SheetA").Rows(8).entirerow.insert -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Hannes Heckner" wrote in message ... Hi, I need a excel programming which does the following: Whenever I insert a row in sheet A a corresponding row in sheet B needs to be inserted. The correspondence is given by a offset to a named top row When removing a row in sheet A the corresponding row in sheet B should be removed. How can I react on insertion and deletion in excel? Best regards Hannes |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copied from web page to excel sheet and cant remove from sheet | Excel Worksheet Functions | |||
copied from web page to excel sheet and cant remove from sheet | Excel Worksheet Functions | |||
excel sheet bootom half sheet goes behind top part of sheet | Excel Worksheet Functions | |||
Duplicate sheet, autonumber sheet, record data on another sheet | Excel Worksheet Functions | |||
Finding Info from sheet 1 and removing only those rows from sheet | Excel Discussion (Misc queries) |