Reflect cell contents into another worksheet
 

I have forgotten how to reflect data that is present in one worksheet
cell into a specific cell of a second worksheet. IOW, repeat cell
contents in a second worksheet.

I simply do not make use of MS Excel97 often enough to remember the
procedures !

Please help.

Regards,
~ Vince ~

Hi Vince,

Try this:
- Go to the desired cell in your second worksheet.
- Press the = key to start a formula.
- Click on the first worksheet to select it and then click on the desired
cell. You should see the formula now contains a reference to the desired
cell.
- Press return. You should now see the value in the cell from worksheet 1
repeated in the cell on worksheet 2.

Is this what you wanted to achieve?

Kind regards,

Mark


"Vince" wrote:


I have forgotten how to reflect data that is present in one worksheet
cell into a specific cell of a second worksheet. IOW, repeat cell
contents in a second worksheet.

I simply do not make use of MS Excel97 often enough to remember the
procedures !

Please help.

Regards,
~ Vince ~

Example 1: =[Book2]Sheet1!$A$1
Example 2: ='[Copy of piezeros.xls]Sheet1'!$B$1 (note single quotes
because file name has spaces)
Formula is best done by typing = and then click on the cell in the second
book.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Vince" wrote in message
...

I have forgotten how to reflect data that is present in one worksheet
cell into a specific cell of a second worksheet. IOW, repeat cell
contents in a second worksheet.

I simply do not make use of MS Excel97 often enough to remember the
procedures !

Please help.

Regards,
~ Vince ~