Anybody care to help? Much Mahalos (thanks very much) in advance for trying.

I want to be able to gather data from specific cells within multiple excel
spreadsheet files and have them appear on another excel file that will be a
summary list of all the data collected from the other excel files. In other
words, have stuff from a bunch of excel files be automatically imported into
a single excel file.

I've been playing around with the "import external data" functions with
little success. Is there another way? I'm using Microsoft Office Excel 2003.

Are you wanting those values to simply appear in various cells of your
"Summary Sheet"?

If that is the case, all you need to do (while both sheets are open) is type
an "=" sign in the cell that you want the data to appear in, and then go to
the sheet where the data comes from and click on that cell. Press enter, and
that means you have created a "link". Each time you open the "Summary Sheet"
excel will ask if you want to update links. If you say yes then the current
figures from your source sheet will appear. If not, the figures that were
last shown in your summary sheet will remain.

I hope that made sense.

Arla

"78degreesinHI" wrote:

Anybody care to help? Much Mahalos (thanks very much) in advance for trying.

I want to be able to gather data from specific cells within multiple excel
spreadsheet files and have them appear on another excel file that will be a
summary list of all the data collected from the other excel files. In other
words, have stuff from a bunch of excel files be automatically imported into
a single excel file.

I've been playing around with the "import external data" functions with
little success. Is there another way? I'm using Microsoft Office Excel 2003.

Thanks "Arla",

Links - of course. Great! Would you know how to eliminate any blank cells
from empty links so that my summary list would have consecutive line items?


"Arla" wrote:

Are you wanting those values to simply appear in various cells of your
"Summary Sheet"?

If that is the case, all you need to do (while both sheets are open) is type
an "=" sign in the cell that you want the data to appear in, and then go to
the sheet where the data comes from and click on that cell. Press enter, and
that means you have created a "link". Each time you open the "Summary Sheet"
excel will ask if you want to update links. If you say yes then the current
figures from your source sheet will appear. If not, the figures that were
last shown in your summary sheet will remain.

I hope that made sense.

Arla

"78degreesinHI" wrote:

Anybody care to help? Much Mahalos (thanks very much) in advance for trying.

I want to be able to gather data from specific cells within multiple excel
spreadsheet files and have them appear on another excel file that will be a
summary list of all the data collected from the other excel files. In other
words, have stuff from a bunch of excel files be automatically imported into
a single excel file.

I've been playing around with the "import external data" functions with
little success. Is there another way? I'm using Microsoft Office Excel 2003.

You can put a filter on your data, and choose to show "non-blank" cells.

"78degreesinHI" wrote:

Thanks "Arla",

Links - of course. Great! Would you know how to eliminate any blank cells
from empty links so that my summary list would have consecutive line items?


"Arla" wrote:

Are you wanting those values to simply appear in various cells of your
"Summary Sheet"?

If that is the case, all you need to do (while both sheets are open) is type
an "=" sign in the cell that you want the data to appear in, and then go to
the sheet where the data comes from and click on that cell. Press enter, and
that means you have created a "link". Each time you open the "Summary Sheet"
excel will ask if you want to update links. If you say yes then the current
figures from your source sheet will appear. If not, the figures that were
last shown in your summary sheet will remain.

I hope that made sense.

Arla

"78degreesinHI" wrote:

Anybody care to help? Much Mahalos (thanks very much) in advance for trying.

I want to be able to gather data from specific cells within multiple excel
spreadsheet files and have them appear on another excel file that will be a
summary list of all the data collected from the other excel files. In other
words, have stuff from a bunch of excel files be automatically imported into
a single excel file.

I've been playing around with the "import external data" functions with
little success. Is there another way? I'm using Microsoft Office Excel 2003.

Close to the same situation, except I need to be able to pull data from two
seperate cells which are not adjoining cells. Once cell contains text, the
other a time value. Since the file is imported on a montly basis and the cell
position is not constant. I tried to create a macro with the "find" function,
but the multiple cells and differing postions wreck havoc with that.
Suggestions? Thanks

Cbus

"Arla" wrote:

You can put a filter on your data, and choose to show "non-blank" cells.

"78degreesinHI" wrote:

Thanks "Arla",

Links - of course. Great! Would you know how to eliminate any blank cells
from empty links so that my summary list would have consecutive line items?


"Arla" wrote:

Are you wanting those values to simply appear in various cells of your
"Summary Sheet"?

If that is the case, all you need to do (while both sheets are open) is type
an "=" sign in the cell that you want the data to appear in, and then go to
the sheet where the data comes from and click on that cell. Press enter, and
that means you have created a "link". Each time you open the "Summary Sheet"
excel will ask if you want to update links. If you say yes then the current
figures from your source sheet will appear. If not, the figures that were
last shown in your summary sheet will remain.

I hope that made sense.

Arla

"78degreesinHI" wrote:

Anybody care to help? Much Mahalos (thanks very much) in advance for trying.

I want to be able to gather data from specific cells within multiple excel
spreadsheet files and have them appear on another excel file that will be a
summary list of all the data collected from the other excel files. In other
words, have stuff from a bunch of excel files be automatically imported into
a single excel file.

I've been playing around with the "import external data" functions with
little success. Is there another way? I'm using Microsoft Office Excel 2003.