LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Anift
 
Posts: n/a
Default retrieving values from a specified sheet

Thanks Pete,

I didnt know you can specify the sheet's name in that..

Thanks a ton


"Pete_UK" wrote:

Check out the INDIRECT( ) function in Excel Help. With this you can
specify the address (including sheet name) of the cell you want to get
data from.

Hope this helps.

Pete




 
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
Need to look up value in another Sheet based on criteria in first sheet. Stacey Excel Worksheet Functions 1 March 28th 06 06:22 AM
Excel how do I link text values in one sheet to another sheet? chrisjtm Excel Discussion (Misc queries) 3 March 9th 06 06:09 AM
Does excel recognise names rather than cells? Sue Excel Worksheet Functions 9 May 22nd 05 04:51 AM
consolidate values to a checklist on sheet 2 moviestar Excel Discussion (Misc queries) 1 April 20th 05 06:15 AM
Naming & renaming a sheet tab Cgbilliar Excel Worksheet Functions 1 November 7th 04 05:57 PM


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