+ Reply to Thread
Results 1 to 4 of 4

excel file operation

  1. #1
    Registered User
    Join Date
    09-17-2008
    Location
    Mongolia
    Posts
    2

    excel file operation

    Hi

    I have two excel files with identical record structure. One is subset of another. In first file I have arround 10000 records and in subset file arround 1000. I need to prepare file which is (first file - second file) with 9000 records at the end.

    If someone can helpme?

    regards
    bart

  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200
    Do you mean that you want to remove the 1000 records from the main sheet?

    Also, please try to be more careful with your question titles.
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  3. #3
    Registered User
    Join Date
    09-17-2008
    Location
    Mongolia
    Posts
    2
    Yes, I have to remove this 1000 from main sheet.

    regards
    bart76

  4. #4
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200
    You could write a vba procedure to loop through the 1000 records & delete them from the other list.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Code to Export Excel Data to Text File
    By ashkash in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 02-13-2012, 05:59 AM
  2. Problem detecting Excel 2003 file change.
    By bashara in forum Excel General
    Replies: 1
    Last Post: 04-11-2008, 04:05 AM
  3. Automated Import of .csv File into Excel Using Variable as Connection Path?
    By dsfcom in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-05-2008, 10:50 AM
  4. Rename Excel File via FTP using macro
    By buczacz in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-12-2007, 04:20 PM
  5. Excel 97 cannot open Unicode csv file
    By antonyfrancis in forum Excel General
    Replies: 1
    Last Post: 03-03-2007, 02:31 PM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1