Spreadsheet With Multiple Data Sources
 

Hi,
I have a spreadsheet that is populated with data obtained from several other
spreadsheets and an .html document also. Is there a fairly simple and
efficient way to automate a process like that? It is a process that I will
have to perform monthly.

Thanks in advance,

Brian

Spreadsheet With Multiple Data Sources
 

Pivot table.
When you get to define the external data source you will be taken to MS
Query.
In MS Query you can link diferent tables (if they have a common field to use
as a key) and display consolidated data in your PT.


"leimst" a écrit dans le message de news:
...
Hi,
I have a spreadsheet that is populated with data obtained from several
other spreadsheets and an .html document also. Is there a fairly simple
and efficient way to automate a process like that? It is a process that I
will have to perform monthly.

Thanks in advance,

Brian

Spreadsheet With Multiple Data Sources
 

Will that work with the .html doc as well?

"Nth" wrote in message
...
Pivot table.
When you get to define the external data source you will be taken to MS
Query.
In MS Query you can link diferent tables (if they have a common field to
use as a key) and display consolidated data in your PT.


"leimst" a écrit dans le message de news:
...
Hi,
I have a spreadsheet that is populated with data obtained from several
other spreadsheets and an .html document also. Is there a fairly simple
and efficient way to automate a process like that? It is a process that
I will have to perform monthly.

Thanks in advance,

Brian