View Single Post
  #1   Report Post  
don
 
Posts: n/a
Default synchronize multiple worksheets

I have 7 worksheets in an Excel 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.
I realize this will be a VBA and I have no experience so i hope someone can
explain this in explicit terms.
thank you
don