Cascading Deletes across multiple sheets
Thanks Steve,
I actually wanted to find out if programatically, we can
detect the deletes say, with an event handler that can
propagate the deletes to other sheets either based on the
rows that were deleted or the ids that are missing.
-----Original Message-----
Fidelis,
Just select all of the sheets holding the Shift key (or
use the Ctrl key if
the sheets are separated by a sheet you don't want to
change)
Select the rows to delete, and delete them. All sheets
will be changed.
Be sure to deselect the grouped sheets or any entry you
make will be
duplicated on all the sheets.
By-the-by - this is an easy way to get the same entry on
multiple sheets.
--
sb
"Fidelis" wrote in message
...
Hello,
I am retrieving data from the database into 4
separate
sheets. price, sold, unsold and misc
each of these sheets will have identical number of
records
which will vary depending on user parameters.
Each record is tagged with an ID in column one.
It is possible that users may not want certain records
in
their analysis and may choose to remove them by
selecting
and then deleting.
Can anyone tell me if I can cascade the delete across
other sheets automatically from any one of the sheets ?
Thanks in advance
Fidelis
.
|