Hi

Starting from cell C22 on Sheet2, enter = then navigate to D14 on Sheet1
and press enter
You should see in the cell =Sheet1!D14
Now, anything you enter in D14 on Sheet1 will also appear on Sheet2 C22

To link other cells, either follow the same procedure, or just put the
sheetname followed by an Exclamation mark in front of the cell reference
you want.

--
Regards

Roger Govier


"W0rks Grp" <W0rks wrote in message
...
I am trying to create two forms that use some of the same info without
having
to enter twice eg; cell D14 - sheet 1 to be sent to and appear on cell
C22 -
sheet 2, can this be done