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

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

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

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.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
" wrote:
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#.