LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 112
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pulling data into today's worksheet from yesterday's worksheet Big UT Fan Excel Discussion (Misc queries) 4 December 12th 08 07:20 PM
Pulling data from another worksheet Susan Excel Discussion (Misc queries) 2 June 20th 08 06:53 PM
Pulling data through to another worksheet Sarah (OGI) New Users to Excel 0 June 6th 08 02:30 PM
Pulling data from one worksheet to another JoeJoe Excel Worksheet Functions 3 August 17th 06 04:51 PM
Pulling Data from Another Worksheet AntnyMI Excel Discussion (Misc queries) 0 July 25th 06 06:09 PM


All times are GMT +1. The time now is 10:36 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"