Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 2 of 2

Thread: Export data from one .xls file to another .xls file?

  1. #1
    Join Date
    3rd February 2005
    Posts
    1

    Export data from one .xls file to another .xls file?

    How do I export data from one .xls file to another .xls file? For example, one sheet has all the data for patients, time of surgery, age, etc. We needed to export data to another excel file (a daily template) that does not disclose certain rows, columns, or cells of information, i.e. do not disclose age of patient, etc.

    Bottom line is how to get certain rows, cells, or columns that you specify to show on another excel file, exported.

    Thanks!

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    28th January 2003
    Location
    Solihull - England
    Posts
    8,678

    Re: Export data from one .xls file to another .xls file?

    You could use ADO to import selected columns to the other file from the master file.

    Here is an example

    Remote transfer of data - XL to XL
    Kind Regards, Will Riley

    Web Presence:
    LinkedIn: Will Riley

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Possible Answers

  1. VBA To Export To Xls File
    By heravnda in forum EXCEL HELP
    Replies: 2
    Last Post: December 13th, 2007, 05:20
  2. Export Data As Text 1000 Rows Per File
    By geonicho in forum EXCEL HELP
    Replies: 11
    Last Post: March 30th, 2007, 06:48
  3. Replies: 5
    Last Post: September 22nd, 2005, 23:30
  4. export ticking data to external file
    By khairy in forum EXCEL HELP
    Replies: 17
    Last Post: January 13th, 2005, 09:57
  5. Export Data to .txt secuential file
    By PoliticKiller in forum EXCEL HELP
    Replies: 3
    Last Post: December 8th, 2004, 08:12

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
porno