LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Joe Joe is offline
external usenet poster
 
Posts: 476
Default Lookup a range in another file?

The current file has multiple tabs with many lookup formulas and the
performance is slowing down considerably.

I have 4 main tabs which contain the source data name ranges. Can I move
these tabs to a separate file and have the lookup formulas in the original
file reference the ranges in this new file?

Any help would be appreciated.

Thanks, Joe
 
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
help with lookup and range Mona Excel Worksheet Functions 3 January 10th 08 11:48 PM
Lookup & copy range Saintsman Excel Discussion (Misc queries) 3 April 16th 07 12:10 PM
Lookup in a range. Paul Excel Discussion (Misc queries) 4 February 1st 06 08:51 PM
Lookup in named range JaB Excel Discussion (Misc queries) 3 September 26th 05 01:51 PM
Range Lookup Jake Excel Discussion (Misc queries) 2 April 28th 05 11:02 PM


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

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

About Us

"It's about Microsoft Excel"