Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
when i delete a row in one worksheet, how do i...
I have a spreadsheet with multiple worksheets. Most of the worksheets
contain the same information in the first 3 columns, so I'm trying to keep all the worksheets in synch with the first one. When I delete a row in the first worksheet, can I automatically delete the same row in the subsequent worksheets? |
#2
|
|||
|
|||
when i delete a row in one worksheet, how do i...
Yes you can. You just need to select all worksheets as a group. to do this
select first worksheet, press and hold <shift, and select last woorksheet. All sheet tabs will be selected, and in excel title bar you should see [Group]. You can than edit all grouped worksheets simultaneously. To ungroup, click on worksheet tab again (without <shift). To group just few sheets use <ctrl instead <shift, and click on desired tabs. "Tim Patton" <Tim wrote in message ... I have a spreadsheet with multiple worksheets. Most of the worksheets contain the same information in the first 3 columns, so I'm trying to keep all the worksheets in synch with the first one. When I delete a row in the first worksheet, can I automatically delete the same row in the subsequent worksheets? |
#3
|
|||
|
|||
when i delete a row in one worksheet, how do i...
Thanks for your response! That's getting me close. Do you know if this is
possible through macroes? Ideally, within a macro, I'd like to be able to determine that a row was deleted and then delete the corresponding rows in the other sheets. "Mladen_Dj" wrote: Yes you can. You just need to select all worksheets as a group. to do this select first worksheet, press and hold <shift, and select last woorksheet. All sheet tabs will be selected, and in excel title bar you should see [Group]. You can than edit all grouped worksheets simultaneously. To ungroup, click on worksheet tab again (without <shift). To group just few sheets use <ctrl instead <shift, and click on desired tabs. "Tim Patton" <Tim wrote in message ... I have a spreadsheet with multiple worksheets. Most of the worksheets contain the same information in the first 3 columns, so I'm trying to keep all the worksheets in synch with the first one. When I delete a row in the first worksheet, can I automatically delete the same row in the subsequent worksheets? |
#4
|
|||
|
|||
when i delete a row in one worksheet, how do i...
Huh, not a macro guru here ;)... Anyway, I will give a try, but I'm sure
somebody will give you ansver very soon... "Tim Patton" wrote in message ... Thanks for your response! That's getting me close. Do you know if this is possible through macroes? Ideally, within a macro, I'd like to be able to determine that a row was deleted and then delete the corresponding rows in the other sheets. "Mladen_Dj" wrote: Yes you can. You just need to select all worksheets as a group. to do this select first worksheet, press and hold <shift, and select last woorksheet. All sheet tabs will be selected, and in excel title bar you should see [Group]. You can than edit all grouped worksheets simultaneously. To ungroup, click on worksheet tab again (without <shift). To group just few sheets use <ctrl instead <shift, and click on desired tabs. "Tim Patton" <Tim wrote in message ... I have a spreadsheet with multiple worksheets. Most of the worksheets contain the same information in the first 3 columns, so I'm trying to keep all the worksheets in synch with the first one. When I delete a row in the first worksheet, can I automatically delete the same row in the subsequent worksheets? |
#5
|
|||
|
|||
when i delete a row in one worksheet, how do i...
thanks again. I found the worksheet_change event and in the code I'm trying
to determine whether or not a row has been deleted. Haven't figured out how to do that yet. "Mladen_Dj" wrote: Huh, not a macro guru here ;)... Anyway, I will give a try, but I'm sure somebody will give you ansver very soon... "Tim Patton" wrote in message ... Thanks for your response! That's getting me close. Do you know if this is possible through macroes? Ideally, within a macro, I'd like to be able to determine that a row was deleted and then delete the corresponding rows in the other sheets. "Mladen_Dj" wrote: Yes you can. You just need to select all worksheets as a group. to do this select first worksheet, press and hold <shift, and select last woorksheet. All sheet tabs will be selected, and in excel title bar you should see [Group]. You can than edit all grouped worksheets simultaneously. To ungroup, click on worksheet tab again (without <shift). To group just few sheets use <ctrl instead <shift, and click on desired tabs. "Tim Patton" <Tim wrote in message ... I have a spreadsheet with multiple worksheets. Most of the worksheets contain the same information in the first 3 columns, so I'm trying to keep all the worksheets in synch with the first one. When I delete a row in the first worksheet, can I automatically delete the same row in the subsequent worksheets? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Search a worksheet, extract rows using a list from another sheet | Excel Discussion (Misc queries) | |||
Comparing a list to a Calendar worksheet. | Excel Worksheet Functions | |||
how to delete an excel file? how to e-mail a worksheet? | New Users to Excel | |||
HOW DO I DELETE A WORKSHEET IN EXCEL? NOT HIDE IT OR RENAME IT | Excel Worksheet Functions | |||
how do I delete data from a worksheet without deleting the formul. | Excel Discussion (Misc queries) |