have a workbook which contains 14 pages,
the first page contains employee info, and the other 13 pages read info from
the first page
the first page also reads info from the other 13 pages

if a row is deleted on page one is their a way to delete all the matching
rows on the other pages

thanks in advance

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

--
Don Guillett
SalesAid Software

"Rich" wrote in message
...
have a workbook which contains 14 pages,
the first page contains employee info, and the other 13 pages read info
from
the first page
the first page also reads info from the other 13 pages

if a row is deleted on page one is their a way to delete all the matching
rows on the other pages

thanks in advance

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

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

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

at the min i am using the following:-

Sub line9()
Resp = MsgBox(Prompt:="This Action Will Reset All Pre Entered Data For This
Employee Continue?", Buttons:=vbYesNo)
If Resp = vbNo Then Exit Sub
Resp = MsgBox(Prompt:="Are You Sure You Want To Continue - This Action Can
Not Be Undone", Buttons:=vbYesNo)
If Resp = vbNo Then Exit Sub
Application.ScreenUpdating = False
Sheets(Array("Jan", "Feb", "March", "April", "May", "June", "July", "Aug",
"Sep", "Oct", _
"Nov", "Dec")).Select
Range("E9:AI9").Select
Selection.ClearContents
Sheets("Overview").Select
Range("B9:E9").Select
Selection.ClearContents
Range("B9").Select
Application.ScreenUpdating = True
End Sub

using this macro i would have to write it approx 130 times down the main
page next to each persons name. i was hoping to be able to do a "one hit"
button which when i click on it, it will ask me which row to delete rather
than having 130 macros saying the same thing