- Follow via:
- RSS
- Email Alert
Question
0
Votes
Excel File data transfer from another Excel File
How to transfer excel cell data from one excel file to another excel file.
5th Feb 2007
Answers (2)
0
Votes
Link to another Excel workbook
Open both workbooks and make sure the destination workbook which will contain the link to the other workbook, is saved. Select the cell you want to link from. If you want to set up a formula, enter the equal sign, or if the link is in the middle of a formula, type in the operator or the function preceding the reference to the other workbook.
Click the Window menu and select the name of the other workbook and click the worksheet that contains the cell you want. Select the cell. Press the Enter key or finish the formula in the destination worksheet.
The reference looks like this:
=[ss1.xls]Sheet1!$A2$2.
For more info, search for "Create a link to another workbook" in Excel Online Help.
Click the Window menu and select the name of the other workbook and click the worksheet that contains the cell you want. Select the cell. Press the Enter key or finish the formula in the destination worksheet.
The reference looks like this:
=[ss1.xls]Sheet1!$A2$2.
For more info, search for "Create a link to another workbook" in Excel Online Help.
5th Feb 2007
Replies
Hi, i need a lil bit more advance, instead of just copying to 1 column(A2), how can i copy all the columns exactly the same from the workbook i intended to copy from? pls help!!!! :P pls pls pls....
jimchan3384
28th May
sdfsdf
jimchan3384
28th May
0
Votes
Copying Excel cells
Now copy the formula in the destination worksheet. For example, if the data in your source workbook is in a column (e.g. A2:a10), and your destination is C2:c10, then set the formula in our destination to =[ss1.xls]Sheet1!A2 for cell C2 and copy it down. Your destination c2:c10 will be the same as your source a2:a10.
29th May
