Excel Data Reading from another Excel Shheet
Solved/Closed
Related:
- Excel Data Reading from another Excel Shheet
- Transfer data from one excel worksheet to another automatically - Guide
- Ps3 not reading discs - Guide
- Excel marksheet - Guide
- Excel free download - Download - Spreadsheets
- Number to words in excel - Guide
6 responses
Given two (or more) workbooks where A needs data from some other workbookB.cell,
in Workbook A at the location desired enter
=[pathtoWorkboolX.xls]sheetname!cellReference
Notice the sheetname!cellreference is how to get data from one sheet to another in the same workbook
so adding the [pathname] just addes the workbook location.
If you need to navigate on the directories, just start to enter =workbook and tab to get the file browser.
This will then create an absolute path the the file, eg
=c:\xxx\yyy\zzz\workbook
in Workbook A at the location desired enter
=[pathtoWorkboolX.xls]sheetname!cellReference
Notice the sheetname!cellreference is how to get data from one sheet to another in the same workbook
so adding the [pathname] just addes the workbook location.
If you need to navigate on the directories, just start to enter =workbook and tab to get the file browser.
This will then create an absolute path the the file, eg
=c:\xxx\yyy\zzz\workbook
im not an excel wiz but I know that say you have two xls documents and you want to make a reference in the second document to the first then you can open up both of them and then choose right click on the sheet in the first doc and choose move or copy and then choose make a copy and choose the second doc as the place to put the copy.
Now you should have a new sheet in your second document that have exactly the same data as in the sheet of your first document. Notice that on this new sheet, each cell refers to the first document's sheet so you can use those codee in the cells to refer to the first document.
You will need to experiment with updating, i'm not sure how it would work. You might have to reopen the document for it to update.
Hope this helps
Now you should have a new sheet in your second document that have exactly the same data as in the sheet of your first document. Notice that on this new sheet, each cell refers to the first document's sheet so you can use those codee in the cells to refer to the first document.
You will need to experiment with updating, i'm not sure how it would work. You might have to reopen the document for it to update.
Hope this helps
I am trying to create a second excel spreadsheet by copying the original. When I do so, I loose my formula in the new document. Is there a way to copy an excel spreadsheet without loosiing the formula?
If U contact me on my mail I can convert your file as u required
my mail ID as156@rediffmail.com - This is free in my interest
since I am working in same field
Regards
A.S.Shukla
my mail ID as156@rediffmail.com - This is free in my interest
since I am working in same field
Regards
A.S.Shukla
Didn't find the answer you are looking for?
Ask a question
SAV,
To copy a spreadsheet to the next one open the orginal and in the same excel sheet program start a new window.
Make sure you highlight the whole screen ctrl-A, from the original.
Click on the new one and hit Ctrl-V.
I did it just to test it and it worked fine. If it is not copying perhaps you have something turned off or the version is off. I am using Excel 2007.
, respectfully,
Ryan
To copy a spreadsheet to the next one open the orginal and in the same excel sheet program start a new window.
Make sure you highlight the whole screen ctrl-A, from the original.
Click on the new one and hit Ctrl-V.
I did it just to test it and it worked fine. If it is not copying perhaps you have something turned off or the version is off. I am using Excel 2007.
, respectfully,
Ryan
May 31, 2009 at 04:48 AM
Although I have not asked this question but was just searching this title.
And your solution has solved my all problems..
Thanks a lot joe..
Aug 4, 2009 at 09:55 AM
=workbook(F:\Store\Toys\ProviderA.xls) ; WORKSHEET(Products) ; CELL("contents"; AH6)
none of the above transfers data to a new.xls workbook. Where is the mistake??
Oct 26, 2009 at 04:42 AM
Jan 21, 2010 at 08:47 AM
Given: 3 Excel Files: "QuoteSummary.xls", "QuoteA.xls", "QuoteB.xls".
QuoteSummary.xls references the Option A and Option B files to compile the results. All the files are in the same directory so I didn't need the full path. In QuoteSummary.xls, there are two cells that reference the other two files. They contain:
='[QuoteA.xls]Quote Results'!$E$48
='[QuoteB.xls]Quote Results'!$E$48
The "Quote Results" is the name of my Worksheet in the OptionA and OptionB files.
You can type this all manually into the cells in the summary workbook, but I find it's much easier to have all the files open, click on the cell in the summary workbook, hit = key, then go up to the Window pull down menu, select the other file that you want to reference, select the Worksheet and Cell in that other file and hit enter. This fills in the formula for you and returns you back to the summary workbook.
(Steps done on Excel 2003)
Feb 1, 2010 at 10:38 AM
That was enormously helpful.
Thanks.
I have another question.
Given the general formula,
=[pathtoWorkboolX.xls]sheetname!cellReference
What I am doing is Hard-coding the names of external workbook and its sheetname.
To be precise, I am using: =SUM([mainBook.xls]Sheet1!$P$296:$P$336)
Is there any way such that the source workbook (WorkboolX.xls) could be selected dynamically, maybe an explorer window pops up and then I select the source workbook and it gets inserted into this formula ??
Thanks again in advance.