link a cell in the 'Master' worksheet list to a 'Detail' worksheet
=INDIRECT("'"&A2&"'!A1)
where A2 holds the sheet name
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
"Paul Condron" wrote in message
...
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.
|