Spreadsheet With Multiple Data Sources

  • Thread starter Thread starter leimst
  • Start date Start date
L

leimst

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
 
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.
 
Will that work with the .html doc as well?

Nth said:
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.
Click to expand...
 
Back
Top