Search : in
By :

Excel Data Reading from another Excel Shheet

Last answer on Oct 26, 2009 8:42:56 am GMT Mohinder, on Nov 1, 2008 7:11:29 am GMT 
 Report this message to moderators

Dear People,

I have a small Requirement in Excel. Can you please help me out?

Problem Description:

Content of Raw Material Prices are maintained in a Xl sheet.


These Material Prices are then used for Calculating the total Price of a Component in another Xl sheet using a Formula.


Requirements:

1. The Component Cost Xl File should be able to recognise the Raw Material Price File.
2. The Cost of the Material should be then read from 1st Excel sheet.
3. Calculation in the Component sheet should update depending on the Material Prices.
4. The Update should be carried out in a simplified mean, either by Macro or some other easier Method.
5. Integration steps should be easy and should take care of the Problems regarding different Paths.
6. The Extension of the Components as well as Material should be automatically taken care of (automation).

Sample

Sheet 1: MaterialPrice.xls, Path´: d:\\xyz

Raw Material Price

Aluminium 5,34
Steel 3,35



ComponentCal.xls , Path : d:\\abc\\def\\

Component Weight(Kg) RawMaterial% Total Price

Gear 46 Aluminium 50% 46*0,5*Aluminium + 46*0,5*Steel (from 1st Sheet)
Steel 50%


Thank you in Advance! Hope some day I am able to solve some of yours Issues!

Best Regards,
MOhinder

Configuration: Windows XP
Firefox 2.0.0.17

Best answers for « Excel Data Reading from another Excel Shheet » in :
VBA: Finding Hdc in an Excel worksheet or UserForm ShowVBA: Finding Hdc in an Excel worksheet or UserForm Here are two small examples on how to find Hdc in a worksheet: By clicking on Sheet1 the UserForm is displayed. Put the pointer on UF, hold the left mouse button down and drag the...
How to convert Excel into PDF? ShowHow to convert Excel into PDF? Here is a small tips about how to convert your excel files into PDF for your presentation. Step 1 PDF995 is software that gets installed on your computer which enables you to print any sources of document to...
Delete duplicates in an Excel column ShowDelete duplicates in an Excel column To remove duplicates in an Excel column: Click on the Data menu Filter Advanced Filter In this menu, select the column where the duplicates Check the box "Extract without duplication"...
Download XlsToOra ShowDescription The application is designed by WithData Software. XlsToOra is a tool that allows you to import you Excel data to Oracle database. Simple and easy to use, the application has been awarded from certain popular places. The application...
Read-only memory (ROM) ShowRead-only memory (ROM) There is a type of memory that stores data without electrical current; it is the ROM (Read Only Memory) or is sometimes called non-volatile memory as it is not erased when the system is switched off. This type of memory...

1

chris, on Nov 1, 2008 1:12:02 pm GMT

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

Reply to chris

2

jobeard, on Mar 4, 2009 4:47:53 pm GMT
  • +18

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

Reply to jobeard

4

Neeraj Jain, on May 31, 2009 9:48:45 am BST

Hi
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..

Reply to Neeraj Jain

5

Nick, on Aug 4, 2009 2:55:06 pm BST
  • +12

=workbook(F:\Store\Toys\ProviderA.xls) ; WORKSHEET(Products) ; CELL("contents", AH6)
=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??

Reply to Nick

6

 STC, on Oct 26, 2009 8:42:56 am GMT

Can you give any sample excel sheet for your answer...

Reply to STC

3

SAV, on Mar 18, 2009 1:59:43 pm GMT
  • +22

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?

Reply to SAV