software

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 quot;import external dataquot; 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
quot;Summary Sheetquot;?

If that is the case, all you need to do (while both sheets are open) is type
an quot;=quot; 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 quot;linkquot;. Each time you open the quot;Summary Sheetquot;
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

quot;78degreesinHIquot; wrote:

gt; Anybody care to help? Much Mahalos (thanks very much) in advance for trying.
gt;
gt; I want to be able to gather data from specific cells within multiple excel
gt; spreadsheet files and have them appear on another excel file that will be a
gt; summary list of all the data collected from the other excel files. In other
gt; words, have stuff from a bunch of excel files be automatically imported into
gt; a single excel file.
gt;
gt; I've been playing around with the quot;import external dataquot; functions with
gt; little success. Is there another way? I'm using Microsoft Office Excel 2003.

Thanks quot;Arlaquot;,

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?quot;Arlaquot; wrote:

gt; Are you wanting those values to simply appear in various cells of your
gt; quot;Summary Sheetquot;?
gt;
gt; If that is the case, all you need to do (while both sheets are open) is type
gt; an quot;=quot; sign in the cell that you want the data to appear in, and then go to
gt; the sheet where the data comes from and click on that cell. Press enter, and
gt; that means you have created a quot;linkquot;. Each time you open the quot;Summary Sheetquot;
gt; excel will ask if you want to update links. If you say yes then the current
gt; figures from your source sheet will appear. If not, the figures that were
gt; last shown in your summary sheet will remain.
gt;
gt; I hope that made sense.
gt;
gt; Arla
gt;
gt; quot;78degreesinHIquot; wrote:
gt;
gt; gt; Anybody care to help? Much Mahalos (thanks very much) in advance for trying.
gt; gt;
gt; gt; I want to be able to gather data from specific cells within multiple excel
gt; gt; spreadsheet files and have them appear on another excel file that will be a
gt; gt; summary list of all the data collected from the other excel files. In other
gt; gt; words, have stuff from a bunch of excel files be automatically imported into
gt; gt; a single excel file.
gt; gt;
gt; gt; I've been playing around with the quot;import external dataquot; functions with
gt; gt; 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 quot;non-blankquot; cells.

quot;78degreesinHIquot; wrote:

gt; Thanks quot;Arlaquot;,
gt;
gt; Links - of course. Great! Would you know how to eliminate any blank cells
gt; from empty links so that my summary list would have consecutive line items?
gt;
gt;
gt; quot;Arlaquot; wrote:
gt;
gt; gt; Are you wanting those values to simply appear in various cells of your
gt; gt; quot;Summary Sheetquot;?
gt; gt;
gt; gt; If that is the case, all you need to do (while both sheets are open) is type
gt; gt; an quot;=quot; sign in the cell that you want the data to appear in, and then go to
gt; gt; the sheet where the data comes from and click on that cell. Press enter, and
gt; gt; that means you have created a quot;linkquot;. Each time you open the quot;Summary Sheetquot;
gt; gt; excel will ask if you want to update links. If you say yes then the current
gt; gt; figures from your source sheet will appear. If not, the figures that were
gt; gt; last shown in your summary sheet will remain.
gt; gt;
gt; gt; I hope that made sense.
gt; gt;
gt; gt; Arla
gt; gt;
gt; gt; quot;78degreesinHIquot; wrote:
gt; gt;
gt; gt; gt; Anybody care to help? Much Mahalos (thanks very much) in advance for trying.
gt; gt; gt;
gt; gt; gt; I want to be able to gather data from specific cells within multiple excel
gt; gt; gt; spreadsheet files and have them appear on another excel file that will be a
gt; gt; gt; summary list of all the data collected from the other excel files. In other
gt; gt; gt; words, have stuff from a bunch of excel files be automatically imported into
gt; gt; gt; a single excel file.
gt; gt; gt;
gt; gt; gt; I've been playing around with the quot;import external dataquot; functions with
gt; gt; gt; 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 quot;findquot; function,
but the multiple cells and differing postions wreck havoc with that.
Suggestions? Thanks

Cbus

quot;Arlaquot; wrote:

gt; You can put a filter on your data, and choose to show quot;non-blankquot; cells.
gt;
gt; quot;78degreesinHIquot; wrote:
gt;
gt; gt; Thanks quot;Arlaquot;,
gt; gt;
gt; gt; Links - of course. Great! Would you know how to eliminate any blank cells
gt; gt; from empty links so that my summary list would have consecutive line items?
gt; gt;
gt; gt;
gt; gt; quot;Arlaquot; wrote:
gt; gt;
gt; gt; gt; Are you wanting those values to simply appear in various cells of your
gt; gt; gt; quot;Summary Sheetquot;?
gt; gt; gt;
gt; gt; gt; If that is the case, all you need to do (while both sheets are open) is type
gt; gt; gt; an quot;=quot; sign in the cell that you want the data to appear in, and then go to
gt; gt; gt; the sheet where the data comes from and click on that cell. Press enter, and
gt; gt; gt; that means you have created a quot;linkquot;. Each time you open the quot;Summary Sheetquot;
gt; gt; gt; excel will ask if you want to update links. If you say yes then the current
gt; gt; gt; figures from your source sheet will appear. If not, the figures that were
gt; gt; gt; last shown in your summary sheet will remain.
gt; gt; gt;
gt; gt; gt; I hope that made sense.
gt; gt; gt;
gt; gt; gt; Arla
gt; gt; gt;
gt; gt; gt; quot;78degreesinHIquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; Anybody care to help? Much Mahalos (thanks very much) in advance for trying.
gt; gt; gt; gt;
gt; gt; gt; gt; I want to be able to gather data from specific cells within multiple excel
gt; gt; gt; gt; spreadsheet files and have them appear on another excel file that will be a
gt; gt; gt; gt; summary list of all the data collected from the other excel files. In other
gt; gt; gt; gt; words, have stuff from a bunch of excel files be automatically imported into
gt; gt; gt; gt; a single excel file.
gt; gt; gt; gt;
gt; gt; gt; gt; I've been playing around with the quot;import external dataquot; functions with
gt; gt; gt; gt; little success. Is there another way? I'm using Microsoft Office Excel 2003.