Pulling data from one worksheet into another

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

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

Thanks for your help!

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

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