Thread
:
HOW DO i SYNCHRONIZE MULTIPLE WORKSHEETS IN EXCEL?
View Single Post
#
2
Don Guillett
Posts: n/a
try this by right click on excel icon in upper left of workbook(next to
FILE)insert this.
However, it will not fire until you goto the next worksheet.
Private Sub Workbook_SheetDeactivate(ByVal Sh As Object)
Sheets.Select
ActiveCell.EntireRow.Select
ActiveSheet.Select
--
Don Guillett
SalesAid Software
"saranat" wrote in message
...
I have 7 worksheets in a workbook.
all the worksheets have a lastname, firstname, employee ID in the A,B,C
columns of every worksheet.
I need to synchronize the worksheets so that when I click on an employee
name in any worksheet and select a different worksheet I see the same row
as
the original employee name.
Reply With Quote