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
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