View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] kasnospam@yahoo.com is offline
external usenet poster
 
Posts: 1
Default 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#.