Prev: Need function to return numbers at beginning of text
Next: Average numbers in noncontiguous columns ignoring 0's.
From: Ben Rivera on 15 Apr 2010 16:16 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
From: CLR on 15 Apr 2010 17:55
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 |