how do you set up worksheet that connects to another sheet?
 

I am trying to set up a worksheet so that when I enter data into that sheet
it will automatically be transfered to another sheet into specific fields. I
know it is possible, I just don't know how to do it (not very computer
literate!) any suggestions will be greatly appreciated. Thanks

Look for the article "Create a link to another cell, workbook, or program" or
search for 'link cells' in the help files for step-by-step instructions.
Hope this helps.

Tara

"Phylly" wrote:

I am trying to set up a worksheet so that when I enter data into that sheet
it will automatically be transfered to another sheet into specific fields. I
know it is possible, I just don't know how to do it (not very computer
literate!) any suggestions will be greatly appreciated. Thanks

Phylly,

Lets assume that you want data from Sheet 1 to be copied automatically into
Sheet 2, and the cells that you want to copy are A2, A3, A4, B2, B3 and B4.

In Sheet 2 position your cursor in cell A2 and hit the equal (=) sign, then
select sheet1 by using the tab button and position tour cursor on cell A2
(you will see that the cell is selected by the marching ant) and hit enter.

You will see that the contents of A2 from Sheet 1 in Sheet 2.

Repeat the above for all required cells.

As soon as you make any changes in Sheet 1, they should appear automatically
in sheet 2 (in the cells that you have done the above).

HTH

Pank

"Phylly" wrote:

I am trying to set up a worksheet so that when I enter data into that sheet
it will automatically be transfered to another sheet into specific fields. I
know it is possible, I just don't know how to do it (not very computer
literate!) any suggestions will be greatly appreciated. Thanks