Susan,
Try this formula:
='Soil Conservationist'!D1&'Engineer'!D1&'Soil Scientist'!D1
This will put the results of all three sheets in one cell; if two are
blank, then it would just show the result for just one that contains
data.
For further explanation of the way this works, if a formula said =A1&B1
where A1="Jo Bloggs" and B1=3, the result would be Jo Bloggs3. If B1 was
blank, the result would be Jo Bloggs.
Clive

Susan Wrote:
Can I transfer text in one spreadsheet to another? Users choose one of
three
worksheets to fill out and then the info should transfer to a form on
another
sheet within the same workbook.

The formula ='Soil Conservationist'!D1, put within the form, worked to
transfer the info when I only had 1 worksheet for info, but I added the
other
2 and it doesn't work. I need to be able to tell it to pull the info
from
whichever of the 3 worksheets has been filled out. The names of the 3
worksheets are Soil Conservationist, Engineer, and Soil Scientist. One
of
the cells I'm working on within them is cell D1, which is where they
would
enter their name.

Susan


--
Clivey_UK
------------------------------------------------------------------------
Clivey_UK's Profile: http://www.excelforum.com/member.php...o&userid=32569
View this thread: http://www.excelforum.com/showthread...hreadid=525465