Results 1 to 8 of 8

Indirect.Ext

Threaded View

lisach Indirect.Ext 02-12-2012, 01:57 PM
Pete_UK Re: Need assitance with... 02-12-2012, 02:37 PM
lisach Re: Need assitance with... 02-12-2012, 02:59 PM
lisach Re: Need assitance with... 02-12-2012, 03:13 PM
Pete_UK Re: Indirect.Ext 02-12-2012, 04:43 PM
lisach Re: Indirect.Ext 02-13-2012, 03:17 PM
Pete_UK Re: Indirect.Ext 02-13-2012, 04:16 PM
lisach Re: Indirect.Ext 02-18-2012, 11:29 AM
  1. 02-12-2012, 01:57 PM #1
    lisach is offline
    Registered User
    Join Date
    01-20-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2010
    Posts
    61

    Indirect.Ext

    Thanks to a great post I found here, I installed the Morefunc Add-In. I can now pull the value from a specific cell in a closed workbook. YEAH! But... I need more help. I have a master sheet where in Column A I have 52 different workbooks listed. Each workbook is the same just for a different week. Week Ending 02-10-2007.xls ... Week Ending 02-17-2007.xls ... Week Ending 02-24-2007.xls ... etc.... The adjacent cells in the next columns need to pull the value from that workbook from the specific sheet "weekend" cell B24 C24 B25 C25

    Using the INDIRECT.EXT function I can do that. But I don't want to type out the formula in each cell referencing the 52 different workbooks. I would prefer to just look at column A and pull the name from there.

    I have attached the sheet for your consideration.
    thanks in advance.

    2007 Summary.xlsx
    Last edited by lisach; 02-18-2012 at 11:29 AM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1