give us more detailed info and we can help.

--
Don Guillett
SalesAid Software

"Rich" wrote in message
...
thanks

yes all the matching data is on the same row, , what i am looking for is a
way to delete the matching records, without the need to select all sheets,
because using that option if someone starts to reenter data when all the
sheets are selected it will also enter the data on all the other sheets.

i guess it will have to be some kink of makro, ? but rather than have a
macro on each line i guess i would need one that asks who to delete then
deletes him off eash page along with his matching data

thanks anyway
"Alan Beban" wrote:

Don Guillett wrote:
Select all sheets or just the ones you want. Then use the right arrow
key
delete function on any of the sheets.

This only works if the matching records are on the same row as the
record to be deleted.

Alan Beban