Formula to get from sheet by indirect()?

cav~firez22

Well-known Member
Joined
Jun 21, 2006
Messages
543
ok, i have 2 spreadsheets, both are updated separately.

One sheet has new sheets added weekly, while the other is 1 sheet,

I need the workbook with 1 sheet to pull information from the one that has new sheets added weekly

Each new sheet is named accoring to week. (eg.. 10 01 06)
so the next sheet that is added will be 10 08 06
and then 10 15 06

and soforth.
Back on the single sheet work book, colums are labed accordingly.

L m
3 10/01/06 10/8/6 and sofort

4

5

i need L5 to equil the sum of c7 +E7 from the other workbook on the sheet that matches the date in L3


If this is too confusing, then let me know, however i feel it is because my brain is now smokeing.

ANY help would be more than greatly appreciated..
 

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"

cav~firez22

Well-known Member
Joined
Jun 21, 2006
Messages
543
='[Collections KPI.xls]10 01 06'!$E$10+'[Collections KPI.xls]10 01 06'!$H$10

That is the equation i have.

What i would love to have it to have the 10 01 06 be the indirect Value of L2

Codes would be helpful too...

and be able to just cary that on.. is that possible???
 

jimrward

Well-known Member
Joined
Feb 24, 2003
Messages
1,799
Office Version
  1. 2016
  2. 2013
  3. 2011
  4. 2010
  5. 2007
Platform
  1. Windows
try something like the following

=indirect("'[Collections KPI.xls]" & L2 & "'!$E$10")+ .... and repeat for second part, note it is not 3 pips in a row, it is double quote followed by single to start with and repeated in the middle and finish with double quote
 

cav~firez22

Well-known Member
Joined
Jun 21, 2006
Messages
543
OOPS..

one more, if Collections KPI.xls is located in a diferent location, say....
O:\Shared Services\Continuous Improvement\Manual Data\KPI's\Collections KPI.xls

How could that be implemented into?? Am havin a rough timne with tthis...

:)
 

Forum statistics

Threads
1,172,166
Messages
5,879,417
Members
433,427
Latest member
OutofOffice

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top