MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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.

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

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

Posted by Sandi Brown on October 23, 2001 8:20 AM

Thanks for your help!

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

Posted by Richard S on October 23, 2001 3:26 PM

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.