+ Reply to Thread
Results 1 to 2 of 2

Check of new data in a table

Hybrid View

  1. #1
    Registered User
    Join Date
    07-17-2012
    Location
    Delhi, India
    MS-Off Ver
    Excel 2003
    Posts
    16

    Check of new data in a table

    Hello,

    My problem is as follows
    I have a table kept in sheet1 of a excel a.xls as follows
    1
    2
    3
    4
    5
    6
    7
    8

    I have a separate excel b.xls whos entry is as follows
    11
    12
    13
    1
    2
    3
    15

    now what i need to do is
    a.xls is checked against entries of b.xls, if entries of a.xls match with b.xls nothing happens, if entries of a.xls do not match with b.xls
    these new entries are placed below in b.xls

    the output of the macro shall result in b.xls become as follows
    11
    12
    13
    1
    2
    3
    15
    4
    5
    6
    7
    8

    Please help anyone

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Check of new data in a table

    Will a.xls and b.xls be open when you run the macro?

    Should the macro run from an independent file?

    Is it only column A that should be copied or the whole row?
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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