Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cascading Drop-Down Lists | Excel Discussion (Misc queries) | |||
cascading menus | Excel Discussion (Misc queries) | |||
Cascading macros to new workbooks | Excel Worksheet Functions | |||
Cascading Lookup Functions? | Excel Worksheet Functions | |||
CASCADING LIST BOX | Excel Discussion (Misc queries) |