Automatic navigation based on cell text value

I am creating a budget spreadsheet and wish to have a macro run
automatically and navigate to a specific cell of a different worksheet
based on a determined value of a cell.

For example, Cell A5 in the MAIN worksheet uses a drop down list from a
named range (RFP, MOA, PSC ...) from another worksheet. If the value
is "RFP" then I wish to navigate automatically to cell A1 of the
REQUEST worksheet where additional information is completed related to
"RFP". I'd reverse the process on the last cell of the REQUEST
worksheet, sending the user back to the MAIN worksheet to continue on.
Any ideas??

Perhaps something like this event macro in the worksheet named "Main".

Private Sub Worksheet_Change(ByVal Target As Range)
If Range("A5").Value = "REP" Then
Sheets("Request").Activate
Sheets("Request").Range("A1").Select
End If
End Sub

And this event macro in the worksheet named "Request". Change column and
row to suit your last cell in the range REP.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Column = 1 And Target.Row = 10 Then
Sheets("Main").Activate
Sheets("Main").Range("A5").Select
End If
End Sub

HTH
Regards,
Howard

"bluegrassstateworker" <andy.crumbacker@gmail.com> wrote in message
news:1154029732.076682.111360@s13g2000cwa.googlegroups.com...
>I am creating a budget spreadsheet and wish to have a macro run
> automatically and navigate to a specific cell of a different worksheet
> based on a determined value of a cell.
>
> For example, Cell A5 in the MAIN worksheet uses a drop down list from a
> named range (RFP, MOA, PSC ...) from another worksheet. If the value
> is "RFP" then I wish to navigate automatically to cell A1 of the
> REQUEST worksheet where additional information is completed related to
> "RFP". I'd reverse the process on the last cell of the REQUEST
> worksheet, sending the user back to the MAIN worksheet to continue on.
> Any ideas??
>

That did it! Thanks! Since I am likely to be moving and manipulating
the location of these cells, I am going to try to give them a name
rather than using the absolute cell reference. -- A

L. Howard Kittle wrote:
> Perhaps something like this event macro in the worksheet named "Main".
>
> Private Sub Worksheet_Change(ByVal Target As Range)
> If Range("A5").Value = "REP" Then
> Sheets("Request").Activate
> Sheets("Request").Range("A1").Select
> End If
> End Sub
>
> And this event macro in the worksheet named "Request". Change column and
> row to suit your last cell in the range REP.
>
> Private Sub Worksheet_SelectionChange(ByVal Target As Range)
> If Target.Column = 1 And Target.Row = 10 Then
> Sheets("Main").Activate
> Sheets("Main").Range("A5").Select
> End If
> End Sub
>
> HTH
> Regards,
> Howard
>
> "bluegrassstateworker" <andy.crumbacker@gmail.com> wrote in message
> news:1154029732.076682.111360@s13g2000cwa.googlegroups.com...
> >I am creating a budget spreadsheet and wish to have a macro run
> > automatically and navigate to a specific cell of a different worksheet
> > based on a determined value of a cell.
> >
> > For example, Cell A5 in the MAIN worksheet uses a drop down list from a
> > named range (RFP, MOA, PSC ...) from another worksheet. If the value
> > is "RFP" then I wish to navigate automatically to cell A1 of the
> > REQUEST worksheet where additional information is completed related to
> > "RFP". I'd reverse the process on the last cell of the REQUEST
> > worksheet, sending the user back to the MAIN worksheet to continue on.
> > Any ideas??
> >