If you don't want to open the other workbook and you don't want to usa VBA, I don't know how to COPY a worksheet from one workbook to another, but you can link to desired values.
For example, in cell A1 of your destination sheet/workbook, type: =[OtherWorkbookName.XLS]Sheet1!A1 To rerieve the value from cell A1 on the worksheet "Sheet1" in the file "OtherworkbookName.XLS". If all you want is a copy, I don't understand why you don't want to open the other workbook though. OH, You can also use the QueryTable feature to link to a whole table of data (by default uses ODBC that someone else mentioned, in the background, but not VBA). Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of anil kumar Sent: Sunday, April 29, 2012 10:21 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Re: Hi friends, I want to know Hello sir, First of all thanks, secondly I don't know vba so can't use it. is excel have any formula. plz tell me. Thanks & Regards Anil -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ---------------------------------------------------------------------------- -------------------------- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com
