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 |
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) |