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.

=INDIRECT("'"&A2&"'!A1)

where A2 holds the sheet name

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Paul Condron" <PaulCondron@discussions.microsoft.com> wrote in message
news:374FB5AC-5BA2-4BE4-A999-4CC875481941@microsoft.com...
> 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.

Bob,

Many thanks but I can't get this to work. I have played around with the " '
and ( ) but I can't seem to get the logic right. I also tried to insert a ,
before A1 but that didn't seem to help either. I'm probably doing something
stupid!
Regards
Paul

"Bob Phillips" wrote:

> =INDIRECT("'"&A2&"'!A1)
>
> where A2 holds the sheet name
>
> --
> HTH
>
> Bob Phillips
>
> (remove nothere from email address if mailing direct)
>
> "Paul Condron" <PaulCondron@discussions.microsoft.com> wrote in message
> news:374FB5AC-5BA2-4BE4-A999-4CC875481941@microsoft.com...
> > 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.
>
>
>

Paul,

The syntax is

=INDIRECT(double-quote single-quote double-quote & A2 &
double-quote single-quote double-quote ! A1 )





"Paul Condron" <PaulCondron@discussions.microsoft.com> wrote in
message
news:887D6FF3-D552-4942-A551-0F99A11730F1@microsoft.com...
> Bob,
>
> Many thanks but I can't get this to work. I have played around
> with the " '
> and ( ) but I can't seem to get the logic right. I also tried
> to insert a ,
> before A1 but that didn't seem to help either. I'm probably
> doing something
> stupid!
> Regards
> Paul
>
> "Bob Phillips" wrote:
>
>> =INDIRECT("'"&A2&"'!A1)
>>
>> where A2 holds the sheet name
>>
>> --
>> HTH
>>
>> Bob Phillips
>>
>> (remove nothere from email address if mailing direct)
>>
>> "Paul Condron" <PaulCondron@discussions.microsoft.com> wrote
>> in message
>> news:374FB5AC-5BA2-4BE4-A999-4CC875481941@microsoft.com...
>> > 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.
>>
>>
>>

Chip,

Thanks. I followed this exactly - I think but it still tells me I have an
error. The particular worksheet I tried it on is labelled - Accel_Lifts -
and so I got:

=INDIRECT("'"&Accel_Lifts&"'"!A1)

But it comes up as a syntax error!

Paul

"Chip Pearson" wrote:

> Paul,
>
> The syntax is
>
> =INDIRECT(double-quote single-quote double-quote & A2 &
> double-quote single-quote double-quote ! A1 )
>
>
>
>
>
> "Paul Condron" <PaulCondron@discussions.microsoft.com> wrote in
> message
> news:887D6FF3-D552-4942-A551-0F99A11730F1@microsoft.com...
> > Bob,
> >
> > Many thanks but I can't get this to work. I have played around
> > with the " '
> > and ( ) but I can't seem to get the logic right. I also tried
> > to insert a ,
> > before A1 but that didn't seem to help either. I'm probably
> > doing something
> > stupid!
> > Regards
> > Paul
> >
> > "Bob Phillips" wrote:
> >
> >> =INDIRECT("'"&A2&"'!A1)
> >>
> >> where A2 holds the sheet name
> >>
> >> --
> >> HTH
> >>
> >> Bob Phillips
> >>
> >> (remove nothere from email address if mailing direct)
> >>
> >> "Paul Condron" <PaulCondron@discussions.microsoft.com> wrote
> >> in message
> >> news:374FB5AC-5BA2-4BE4-A999-4CC875481941@microsoft.com...
> >> > 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.
> >>
> >>
> >>
>
>
>

I omitted the trailing quote. You don't need to substitute the cell value,
Excel will do that, so use

=INDIRECT("'"&A2&"'!A1")

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Paul Condron" <PaulCondron@discussions.microsoft.com> wrote in message
news:B1F5CC4F-7258-488D-9304-7048C6BA70B9@microsoft.com...
> Chip,
>
> Thanks. I followed this exactly - I think but it still tells me I have an
> error. The particular worksheet I tried it on is labelled - Accel_Lifts -
> and so I got:
>
> =INDIRECT("'"&Accel_Lifts&"'"!A1)
>
> But it comes up as a syntax error!
>
> Paul
>
> "Chip Pearson" wrote:
>
> > Paul,
> >
> > The syntax is
> >
> > =INDIRECT(double-quote single-quote double-quote & A2 &
> > double-quote single-quote double-quote ! A1 )
> >
> >
> >
> >
> >
> > "Paul Condron" <PaulCondron@discussions.microsoft.com> wrote in
> > message
> > news:887D6FF3-D552-4942-A551-0F99A11730F1@microsoft.com...
> > > Bob,
> > >
> > > Many thanks but I can't get this to work. I have played around
> > > with the " '
> > > and ( ) but I can't seem to get the logic right. I also tried
> > > to insert a ,
> > > before A1 but that didn't seem to help either. I'm probably
> > > doing something
> > > stupid!
> > > Regards
> > > Paul
> > >
> > > "Bob Phillips" wrote:
> > >
> > >> =INDIRECT("'"&A2&"'!A1)
> > >>
> > >> where A2 holds the sheet name
> > >>
> > >> --
> > >> HTH
> > >>
> > >> Bob Phillips
> > >>
> > >> (remove nothere from email address if mailing direct)
> > >>
> > >> "Paul Condron" <PaulCondron@discussions.microsoft.com> wrote
> > >> in message
> > >> news:374FB5AC-5BA2-4BE4-A999-4CC875481941@microsoft.com...
> > >> > 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.
> > >>
> > >>
> > >>
> >
> >
> >