Creating a formula form text in different cells

**clowesr** · 12-10-2013, 07:23 AM

Hi All

I'm a bit stuck with what to do with this one, I have a formula which looks in a folder for a file and returns the cell I want from that folder and work book

='H:\NCHO\Call Centre\Call Centre Resourcing\Stats\[NHC_Telephony_Daily_2012-11-27.xls]NHC Daily'!$E$55

as you can see I have a date in the middle, I want it to reference to a cell with a date in and return the information from that document with the change in date. So all I have to do is drag the formula down and it will return the info i want out of each report.

I think it might be an add on that I need to download?

Cheers

**XOR LX** · 12-10-2013, 07:34 AM

Hi,

Assuming the cell which contains the relevant workbook name is A1, something like:

=INDIRECT("'H:\NCHO\Call Centre\Call Centre Resourcing\Stats\[NHC_Telephony_Daily_"&TEXT(A1,"yyyy-mm-dd")&".xls]NHC Daily'!$E$55")

However, INDIRECT will not work on closed workbooks, so if that is a requirement you will indeed need to install an add-in, e.g. INDIRECT.EXT (see link below).

http://www.excelforum.com/excel-form...-workbook.html

Regards

Creating a formula form text in different cells

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Creating a formula form text in different cells

Re: Creating a formula form text in different cells

Thread Information

Users Browsing this Thread

Similar Threads

Creating a form in Excel that auto generates a form number

[SOLVED] Creating a formula to populate data in particular cells based on conditions in other cells

Creating a Survey-Style Form Using Radio Buttons in Cells

[SOLVED] Creating a formula to remind me when a form is due

Creating entry form to input data into specific cells based on dropdown selection

Bookmarks

Bookmarks

Posting Permissions