HOW DO i SYNCHRONIZE MULTIPLE WORKSHEETS IN EXCEL?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
If you put it in this one instead it will fire every time you change cells
in the active sheet.

Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target
As Range)
Sheets.Select
ActiveCell.EntireRow.Select
ActiveSheet.Select
End Sub
 
Think Don G. posted this instruction in his first response
try this by right click on excel icon in
upper left of workbook(next to
FILE)> insert this
Click to expand...

Maybe try these steps to get it up:
Right-click on the Excel icon in the upper left corner (Next to "File")
Choose "View Code" (this'll bring you to VBE)
Clear the defaults** appearing in the whitespace on the right
Then copy > paste Don G's code in the whitespace
(You'd need to correct the line-wrap for the first line after you copy and
paste)
Press Alt+Q to get back to Excel
-----------------
**Defaults : "Private Sub Workbook_Open() ... End Sub"
-----------------
In Excel, try it out by selecting a cell say, A2 in Sheet1
The entire row2 will be selected (i.e. highlighted)
Click on Sheet2's tab, the same row2 will be selected
Ditto when you click on Sheet3, etc
 
Thanks Max. When i tried the code it kept bringing me back to the same 1st
worksheet in which I highlighted the row.
saranat
 
don said:
Thanks Max.
Click to expand...
You're welcome !
When i tried the code it kept bringing me back to the
same 1st worksheet in which I highlighted the row.
Click to expand...

Sorry, got to leave this to Don G. or others versed in vba to respond
further to you. Believe it's presumed that the sheets are identically
structured as far as the names are concerned, e.g. Name13 will appear in say
row13 on *every* sheet, and that you'll start the name/row selection in
*Sheet1*
 
that's correct. every worksheet has the same names in the same rows as the
first worksheet.
don
 
Back
Top