moving to to different sheet

wiredgecko · #1 12-03-2014, 09:20 AM

hello, i'm hoping someone can assist me. for starters i am very new and inexperience in VBA.

scenario is:

i have four sheets, for simplicity lets call sheet 1 "names", sheet 2 "bob", sheet 3 "tom" and sheet 4 "sue".
on sheet "names" i have a drop list with the names and depending on which name is chosen the pointer will be moved to A1 of the sheet which matches the name chosen.

thanks

charlesdh · #2 12-04-2014, 01:31 PM

Hi,

This is a worksheet event code that may work when the data in "A1" changes.
Paste this in the worksheet code module for the sheet that you named as "Names".

Code:

Private Sub Worksheet_Change(ByVal Target As Range)
Dim Mysheet As String
If Target.Address = "$A$1" Then
    Mysheet = Target.Text
    Sheets(Mysheet).Activate
    Range("A1").Select
End If

End Sub

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Create a New Sheet from Existing Sheet with Specific Columns	malam	Excel Programming	1	10-17-2014 10:01 PM
Is it possible to take a row on sheet 1 and transfer the info to sheet 2 by rows on conditions.	rogcar75	Excel	3	08-28-2014 05:21 PM
Moving cell content without moving borders & shading?	unittwentyfive	Excel	1	10-25-2013 12:56 PM
Moving Duplicate records to new sheet	Woolstar	Excel Programming	5	01-16-2012 01:46 AM
Moving formula range multiple cells when moving sum over one cell	FraserKitchell	Excel	4	02-26-2010 10:38 AM