Assuming your sheets are named "A' and "B", then in cell A1 of Sheet "B", but
this formula
=A!A1
Then whatever is entered into cell A1 of Sheet "A" will also appear in cell
A1 of sheet "B"

Vaya con Dios,
Chuck, CABGx3





"Ben Rivera" wrote:

I have one spreadsheet with 2 worksheets (A and B). Is there any way to
setup a formula that will copy text input into B from A?
Thanx