Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pulling Data from one worksheet into another
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pulling Data from one worksheet into another
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pulling data into today's worksheet from yesterday's worksheet | Excel Discussion (Misc queries) | |||
Pulling data from another worksheet | Excel Discussion (Misc queries) | |||
Pulling data through to another worksheet | New Users to Excel | |||
Pulling data from one worksheet to another | Excel Worksheet Functions | |||
Pulling Data from Another Worksheet | Excel Discussion (Misc queries) |