From different files

  • Thread starter Thread starter That's Confidential
  • Start date Start date
T

That's Confidential

If I have a spreadsheet called "Sheet 1" saved as a file called "ABCD" and I
have a spreadsheet called "Sheet 1" saved as a file called "EFGH," Is there
anyway I can create a new spreadsheet and take data from my 2 previously
saved other files?

So for example, I open a new Excel Document, and in A1 of this new file, I
want the data from Z1 of "Sheet 1" of "ABCD". I would also like in X1 of my
new spreadsheet, the data from B1 of "Sheet 1" of "EFGH."

Could anyone give me the formulas for this if possible? Also, is it possible
to add data from various Excel saved docs, so for example I have figures
saved in different files for each month, and then in a seperate sheet in a
new file, I want the total sum of all data in A1 in each file?

Thanks in advance and sorry if this doesnt make much sense!
 
Hi
try the following:
- open all three files
- in your new sheet enter the equation sign '=' in cell A1
- now select with your mouse the other workbook and the cell you want
to 'copy'.
- hit 'Enter'
- repeat these steps or just copy the formula. It will adapt the
row/column index automatically

After this save the file and close the other workbooks
 
Back
Top