View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
leimst leimst is offline
external usenet poster
 
Posts: 34
Default 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