Suppose I have a workbook with two worksheets: Copy and Jan Sales
If in A1 of Copy I type ='Jan Sales'!A1, then the A1 cell of Copy sheet
will always display whatever is in A1 of Jan Sales sheet
I could drag this formula across and down the sheet to 'capture' other
cells.
If I was interested only in cells with text, then I would use
=IF(ISTEXT('Jan Sales'!A1),'Jan Sales'!A1,"")

Let us know if this solves the problem
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"Kate" wrote in message
...
Hi,
I have a question regarding pulling text from one worksheet into another.
Please can you help me?
I need to duplicate the information (text only) on one worksheet to
another
one as it is typed. Is there a formula I can use that will allow the data
typed in one worksheet to appear in the other one immediatley?
I have a formula that the person before was using but I don't know how to
apply it to the whole sheet. Any advice would be greatly appreciated.
The formula is =IF(ISBLANK(OFFSET(OFFSET('Design
Schedule'!$B$8,$A15,$B15),0,H$7)),"",OFFSET(OFFSET ('Design
Schedule'!$B$8,$A15,$B15),0,H$7))
Thanks