Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
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#.

  #2   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
 
Posts: 9,221
Default 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#.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I check the "P" or "A" in the attendance sheet Capricorn Excel Worksheet Functions 1 June 8th 06 01:00 PM
How do i enable "Group" & "Ungroup" in a protected sheet ruddojo Excel Discussion (Misc queries) 0 June 2nd 06 02:01 AM
Questionnaire sheet: Select "yes" or "no," and only one can be selected bpatterson Excel Worksheet Functions 2 April 14th 06 12:04 AM
Complex if test program possible? If "value" "value", paste "value" in another cell? jseabold Excel Discussion (Misc queries) 1 January 30th 06 11:01 PM
How to fill in "BLANK" Cells Automactically...Large Spread Sheet msbutton27 Excel Discussion (Misc queries) 3 January 15th 06 05:12 PM


All times are GMT +1. The time now is 04:58 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"