DELETE ROWS ON 2 SHEETS

verluc · May 25th, 2002, 08:57 AM

I have a workbook with 2 sheets.
In sheet1, range A1:A10000 I have symbols.
In sheet2, range A1:A10000 I have the name of this symbols.
Question : has somebody a macro,when I delete a row in sheets1 this automatickly also delete the same row in sheet2

Many thanks for help.

RET79 · May 25th, 2002, 11:39 AM

not a macro for you yet, but, have you tried grouping sheets and deleting a row?

OK, if not, try this:

put numbers from 1 to 10 in A1 to A10 of two different sheets.

Now, press down control and select the other sheet. Both sheets will now be selected at same time.

Delete row 5. It should have been deleted automatically on both sheets, check it out.

To ungroup sheets, right click on the sheet tab and click 'ungroup sheets'.

Hope this helps, could be a good starting point.

RET79

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 25th, 2002, 08:57 AM	#1
verluc Board Regular Join Date: Mar 2002 Posts: 1,290	I have a workbook with 2 sheets. In sheet1, range A1:A10000 I have symbols. In sheet2, range A1:A10000 I have the name of this symbols. Question : has somebody a macro,when I delete a row in sheets1 this automatickly also delete the same row in sheet2 Many thanks for help.

May 25th, 2002, 11:39 AM	#2
RET79 Board Regular Join Date: Mar 2002 Location: England, UK. Posts: 526	not a macro for you yet, but, have you tried grouping sheets and deleting a row? OK, if not, try this: put numbers from 1 to 10 in A1 to A10 of two different sheets. Now, press down control and select the other sheet. Both sheets will now be selected at same time. Delete row 5. It should have been deleted automatically on both sheets, check it out. To ungroup sheets, right click on the sheet tab and click 'ungroup sheets'. Hope this helps, could be a good starting point. RET79