Dear Peter, You can Import Data From Data Menu.In DATA Menu Go to Get External Data, then select Existing Connections,then you will get a dialog box,in that select browse for more then select the file you need to import, then press ok. Then you will get a query about what sheets of the workbook you need to import and where you need to import .Once you specify your requirements you can have your data imported according to your needs.I am Attaching the file in which i have impoterd the data of Data One sheet to Import_and_Calc.xlsx.
Regards, VijayKumar -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
Import_and_Calc.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
