Automatically updating data from another excel spreadsheet

[Guest]

I have set up a spreadsheet which required data from another spreadsheet and
want to know how i can set this up to update every time i open the sreadsheet.

I want the full page of the source data copied accross to a worksheet in my
main excel file.

Can anyone help? It is a macro code i need?

 

[FuzzyD]

This is what i do. A word of warning : I am a Beginner !!!

Suppose you want Data from Workbook "1" - Sheet 1 to be copied as is onto Workbook "2" - Sheet 1, everytime u open Wrkbook 2. You can Use this formula on Cell A1 of Workbook 2 =[1.xls]Sheet1!A1. Then copy the formula for the whole sheet.

Now, the only assumption here is, that both 1 & 2 are in the same folder on the same machine. If not, please use the correct network & folder path in the formula.

Am sure the gurus will have a more erudite and elegant solution to this.

 

[Guest]

If you want ALL the data copied, and the source is a single file, you COULD
set up an equation in every cell (ex: in A1:
=[AnotherBook.xls]AnotherSheet!A1). But it's big and pretty ugly.
The cleaner way, by far, would be VBA code in the Workbook_Open method that
automatically opens the source sheet and copies the entire sheet over.