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 ~
|