LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Using Cell Contents to Select Worksheet with Same Name as Cell Con

I am a quantitative analyst who is the leader of our department's Excel users
group (Multi-Channel Marketing department of Eastbay, Inc. in Wausau,
Wisconsin). I have a friend who is a former co-worker in my department, but
is now a senior credit analyst with a company in Chicago.

If possible, this credit analyst would like to have Excel take the contents
of a cell in the workbook, and use it to select a worksheet (in that same
workbook) that has the same name as the contents or value of that cell. This
seems to be a "twist" on the topic of automated worksheet names that has
generated several postings. Any help will be greatly appreciated by both of
us. Thanks for any help that can be provided!
 
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
Use of the Contents of a cell as a worksheet name in a function tooMuchFun Excel Worksheet Functions 3 July 3rd 07 04:39 AM
I cannot select a single cell or pull down cell contents Carolyn Fahm Excel Worksheet Functions 0 January 24th 06 04:54 PM
How do I select & use contents of first non-blank cell in row? plf100 Excel Worksheet Functions 9 November 15th 05 12:16 PM
Reflect cell contents into another worksheet Vince Excel Discussion (Misc queries) 1 August 12th 05 04:36 PM
Reflect cell contents into another worksheet Vince Excel Discussion (Misc queries) 2 August 12th 05 04:36 PM


All times are GMT +1. The time now is 02:00 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"