View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Paul Condron Paul Condron is offline
external usenet poster
 
Posts: 5
Default link a cell in the 'Master' worksheet list to a 'Detail' worksheet

I have a 'Master' worksheet containing a list of the other worksheets in this
workbook. The list will be added to regularly. I want to create a macro that
when run will take the worksheet name that is highlighted in the 'master'
list and GoTo cell A1 on the related 'Detail' sheet.
Any help would be much appreciated.