importing Excel sheet in a workbook

abeed

Board Regular
Joined
Nov 19, 2005
Messages
79
Hi there: I have a excel file(mdata.xls) that every month changes with new data. I have another excel template that I use to generate report using this mdata.xls file. Now how can I import this excel file into my template each month.
Thanks in advance
Abeed
 

Some videos you may like

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

BrianB

Well-known Member
Joined
Feb 17, 2003
Messages
8,127
One useful way is to set up a query via Data/Get External data/New Query/<New Datasource> .. etc.

Providing the source file is a simple table and the name is kept the same, you can simply use Data/Refresh data to bring in the new data.

Another way would be to use a pivot table, when that could be rereshed in the same way.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,819
Messages
5,574,504
Members
412,599
Latest member
Schu94
Top