Prev: Delete some column headings from an autofiltered range.
Next: Workday function not working
From: Kate on 17 Feb 2010 05:44
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
From: Bernard Liengme on 17 Feb 2010 08:54
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" <Kate(a)discussions.microsoft.com> wrote in message
news:2CAABB3F-FCBA-48D5-95FB-38EAC0DB6D45(a)microsoft.com...
> 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

 | 
Pages: 1
Prev: Delete some column headings from an autofiltered range.
Next: Workday function not working