Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old March 29th 05, 10:27 PM
Pester
 
Posts: n/a
Default Using Indirect Function

When using the Indirect function, how do I look for a tab or sheet that is in
a different Excell file. In this case,

INDIRECT(A4&"!b5") if in AR4, summary is typed then the formula will
look for the value that is in b5 from the summary Tab or sheet. but what if I
am interested in a Tab that is in a different file?

Pester

  #2   Report Post  
Old March 30th 05, 01:04 AM
Dave Peterson
 
Posts: n/a
Default

The bad news is =indirect() won't work with closed files.

Will that other workbook be open?

If no, then maybe you could use a userdefined function created by Harlan Grove:
http://www.google.com/groups?selm=sH...wsranger. com

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm


Pester wrote:

When using the Indirect function, how do I look for a tab or sheet that is in
a different Excell file. In this case,

INDIRECT(A4&"!b5") if in AR4, summary is typed then the formula will
look for the value that is in b5 from the summary Tab or sheet. but what if I
am interested in a Tab that is in a different file?

Pester


--

Dave Peterson


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
Indirect Function Doesn't like non-contiguous ranges Excel Discussion (Misc queries) 7 December 3rd 10 09:59 AM
indirect worksheet function in excel richard_annor Excel Worksheet Functions 1 March 6th 05 11:10 PM
INDIRECT function error Anthony Slater Excel Discussion (Misc queries) 3 February 21st 05 06:26 PM
INDIRECT function question Joe Excel Worksheet Functions 1 February 14th 05 03:54 PM
Indirect( ) function loosing values when spreadsheets are closed Word4Dummies Excel Worksheet Functions 2 February 13th 05 12:41 PM


All times are GMT +1. The time now is 10:34 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017