LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Returning contents of a cell in another sheet in same workbook

I am using multiple sheets. I have a defined name set up in each sheet.
For example I am in Sheet 1. In sheet 1, col a I have a list of the other
Sheets, like Sheet 2, Sheet 3 etc etc.

In Col 2 of Sheet 1 I want to return the value in B2 of Sheet 2 using the
sheet 2 name that I have listed in Col a of sheet 1

Does this make sense
--
Annette
 
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
Returning Cell Contents of One Cell Based On Another Cell DallasLDY Excel Worksheet Functions 5 January 31st 07 11:00 PM
Searching in another workbook for a string and returning with the contents of the cell next to it. [email protected] Excel Worksheet Functions 1 January 12th 07 07:50 PM
Table of Contents Sheet in Workbook Solusvir Links and Linking in Excel 1 August 31st 06 09:47 AM
Returning Cell Value if someone deletes the contents of a cell mmc308 Excel Worksheet Functions 4 March 31st 06 06:41 PM
Returning contents of a cell Dan Excel Worksheet Functions 0 March 26th 06 11:48 PM


All times are GMT +1. The time now is 08:42 PM.

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"