deleting rows across worksheets?
 

i have several worksheets (ie a,b,c,etc) that have variations of the same
information on them. I would like to be able to manually select a cell on
worksheet "a" and then by activating a macro ....delete the row that it is in
across all of the worksheets.
--
dr chuck

deleting rows across worksheets?
 

It's pretty easy to do it manually. Select the sheets you want this to
happen to (Ctrl-click or Shift-click on their tabs, or right click a
worksheet tab and pick Select All Sheets).

This puts you in 'Group mode'. What you do to one sheets affects all
selected sheets at that point.

--
Jim
"dr chuck" wrote in message
...
|i have several worksheets (ie a,b,c,etc) that have variations of the same
| information on them. I would like to be able to manually select a cell on
| worksheet "a" and then by activating a macro ....delete the row that it is
in
| across all of the worksheets.
| --
| dr chuck

deleting rows across worksheets?
 

Thanks Jim,

For a person who is learning how to use excel and VBA by trial and error and
necessity... sometimes the obvious and easy solutions are quite elusive.
--
dr chuck


"Jim Rech" wrote:

It's pretty easy to do it manually. Select the sheets you want this to
happen to (Ctrl-click or Shift-click on their tabs, or right click a
worksheet tab and pick Select All Sheets).

This puts you in 'Group mode'. What you do to one sheets affects all
selected sheets at that point.

--
Jim
"dr chuck" wrote in message
...
|i have several worksheets (ie a,b,c,etc) that have variations of the same
| information on them. I would like to be able to manually select a cell on
| worksheet "a" and then by activating a macro ....delete the row that it is
in
| across all of the worksheets.
| --
| dr chuck