Simple questions: '[Final.XLS]07.01.04'! and using cells

poopdepants

New Member
Joined
Nov 29, 2005
Messages
13
Hey guys

I'm calling data from other sheets.

I autofilled the address and got this:

'[Final.XLS]07.01.04'! (And then the cell number)

Where does the 07.01.04 come from? It is not a folder name.

Also, I was wondering if I can use a cell on the sheet to call up data in the other cells.

Cell A1 contains the filename.

I've tried '[A1]'! with no success. I'm a n00b. What do I do?
 

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.

BJungheim

Well-known Member
Joined
Jul 24, 2004
Messages
914
07.01.04 in this case appears to be the sheet name.

As for the second question you would need the function =INDIRECT.EXT(). I can't recall offhand what Add-In it's part of but if you do a search on this site for it you'll be able to find it and how to use is.
 

joelnichols

Active Member
Joined
Apr 13, 2004
Messages
384
I'm not real sure what your looking for but here are a few ways to get data from another sheet.

Data is here:
Book3
ABCD
11-Jan10
22-Jan20
33-Jan30
44-Jan40
5
Sheet1


and is pulled to this sheet.
Book2
ABCD
11-Jan10[Book3]Sheet1!$B$1
2
33-Jan30[Book3]Sheet1!$B$3
4
Sheet1


That any help?
 

poopdepants

New Member
Joined
Nov 29, 2005
Messages
13

ADVERTISEMENT

I want to use cell A1 as the source for filename.

I know I need to use the INDIRECT command, but I have no idea how to implement it.
 

poopdepants

New Member
Joined
Nov 29, 2005
Messages
13
=SUMIF('[=INDIRECT("&C11&".xls)]job costings'!$D15:G732,"1.1",'[=INDIRECT("&C11&".xls)]job costings'!$F15:F1564)

is the code I am using at the moment.

Note that instead of A1 I'm referencing to c11
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,130
Messages
5,835,569
Members
430,367
Latest member
glastonbury

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