Hi Anil, How to copy multiple sheets between workbooks: https://office.microsoft.com/en-us/excel-help/move-or-copy-sheets-HP00520146 9.aspx
How to create linked cells: http://www.keynotesupport.com/excel-linking-worksheets.shtml How to create a QueryTable: http://www.dicks-clicks.com/excel/ExternalData.htm I hope the above tutorials are helpful. I don't understand what you mean by exporting or why you are doing it, but if it is important, and the help already given is insufficient, please explain. Asa -----Original Message----- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of anil kumar Sent: Monday, April 30, 2012 12:05 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Re: Hi friends, I want to know I exprot data from busy in 5 workbook. and now i open 1 workbook wnat to copy other 4 workbook data in open workbook -- 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
