Creating an exception for a macro button.

[jonvanwyk]

The macro below is simply a "Next" button that takes the user to the next appropriate worksheet. I need to modify it so that it performs the following function:

If cell "J18" in worksheet "Menu" is equal to "N/A", then go to cell "F1" in worksheet "Menu", otherwise go to cell "A1" in worksheet "27".

Please Login or Register  to view this content.

[StevenM]

Maybe?

Please Login or Register  to view this content.

[jonvanwyk]

Perfect. Thank you.