PDA

View Full Version : Solved: Macro need to direct a cell value to the corresponding named worksheet.



bananatang
08-07-2009, 07:01 AM
HI,

Need some assistance in creating a macro that will do the following.

I have pupils names in a worksheet in Column C, starting from Row 14. What i need is a single macro button that will take the user to the pupils worksheet which will have the same name.

I.e. I have put the cursor in a cell in Column C which has a text value, which will be a pupils name For example John Smith. I need the macro to send the user to the worksheet called John Smith.

Thanks

BT

mdmackillop
08-07-2009, 07:05 AM
Application.Goto Sheets(Selection.Value).Range("A1")
'or
Sheets(Selection.Value).Activate

bananatang
08-07-2009, 07:12 AM
mdmackillop, once again. Thanks very much for your help.