sheet 1, cell (n#) and sheet "N" tab name

G

Guest

This is a bit complicated.

1. GIVEN: A multi-sheet workbook, sheet 1- sheet #.

Need to enter on sheet 1, Cell A#, a "Tab Name", where entering this
changes the Target Sheet # Tab Name to what I entered on sheet 1.

Can this be done?

if not, is the following possible?

2. Reference the name of Sheet # tab name on Sheet 1, Cell a#.
 
G

Guest

Why not just right-click on the sheet navigation controls at the bottom left
corner, just to the left of the 1st visible sheet tab? That'll give you a
pop-up menu to go to any visible sheet.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Worksheet Tab Names 1
Tab sheet name 3
Excel Is this possible?? 3
Summary sheet from tab names 3
Getting sheet name and info from cell 3
tab naming from a set cell 1
Sheet Names and Auto-calculation 2
Populate Data from Summary Sheet 5

Top