Archive of Mr Excel Message Board


Back to General Excel archive index
Back to archive home

Pulling data from one worksheet into another

Posted by Sandi Brown on October 23, 2001 7:26 AM
I need to know how to pull the data from one cell on another worksheet into a seperate worksheet.

Re: Pulling data from one worksheet into another

Posted by Aladin Akyurek on October 23, 2001 7:33 AM

Sandi --

You need to specify a bit more what you want.

Lets say that you have a value in A1 in Sheet1 and you want to pull this off to E1 in Sheet2.

In E1 in Sheet2 enter: =Sheet1!A1


Re: Pulling data from one worksheet into another

Posted by Tom Urtis on October 23, 2001 7:35 AM
Will paste linking do the trick?
Go to your source file and activate the cell that contains the data you want to have pulled. Click Edit > Copy. Then go to your destination workbook and activate the cell where you want that source data to be automatically displayed, and click Edit > Paste special > Paste Link, then hit the Esc key to clear the clipboard.

Tom Urtis


Re: Pulling data from one worksheet into another

Posted by Sandi Brown on October 23, 2001 8:20 AM
Thanks for your help!


Re: Pulling data from one worksheet into another

Posted by Sandi Brown on October 23, 2001 11:17 AM
I have built a series of wooksheets in one excel document. The 1st page is Income Statement. I want to bring the cell data value from this sheet to the next wooksheet called balance sheet. (I am trying to move net income into the balance sheet). So, the cell #is F39 on the Income Statement worksheet and I want this value to appear in G 42 on the Balance sheet work sheet .... thanks in advance for your help


Re: Pulling data from one worksheet into another

Posted by Richard S on October 23, 2001 3:26 PM
Sandi
I assume Aladins response answers your question. In cell G42 on the balance sheet, enter the formula =Income Statement F39, assuming the income statement sheet is called Income Statement. To ensure accuracy, it's better to type =, then click on the sheet and cell required.
Richard


This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.