Macro to move between worksheets

[banga101]

Hello all, this is my first time in the forum room, I have a work book with 6 worksheets, sheet2 is called Maersk, sheet3 Mariana, and so on
I need a macro so when I type Mariana in sheet1 g20 and hit enter it go's to Mariana sheet

[jewelsharma]

This macro should be copied to the "Worksheet_Change" event in Sheet1

Please Login or Register  to view this content.

[Marc L]

Hi,

code to insert in the Sheet1 module :

Please Login or Register  to view this content.

[banga101]

Hi jewelsharma
That was Exactly what I wanted It work great thank you
I wasn't even close trying to get it to work
Once again thank you

Banga101

[jewelsharma]

Happy to help mate
Please be so kind to mark the thread as SOLVED.

Warm regards,
Jewel

[Marc L]

I hope banga101 yours workbooks have few worksheets …