+ Reply to Thread
Results 1 to 4 of 4

Match macro

Hybrid View

  1. #1
    Registered User
    Join Date
    06-14-2009
    Location
    india
    MS-Off Ver
    Excel 2003
    Posts
    11

    Match macro

    Hi

    I am new to the world of macros. I have data in two sheets. I need a macro which will ask me to match between two sheets on the basis of the certain criteria, Like description, ID, and qty and the macro should give me option of matching and not matching and after that it should give the data in the required format. The excel worsheet is attached for reference.

    Thanking you in advance.
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor ratcat's Avatar
    Join Date
    03-07-2008
    Location
    Rural NSW, Australia
    MS-Off Ver
    Vista 2007
    Posts
    1,111

    Re: Match macro

    G'day

    I'm still new to the world of macro but here is an answer without macros. (See attached)

    Cheers

    RC
    Attached Files Attached Files
    Have I made you happy ??? If yes, please make me happy by pressing the http://www.excelforum.com/images/buttons/reputation-40b.png Add Reputation button in my post.
    Please don't forget to do the same to other contributors of this forum.

    Thanks
    I don't void confusion, I create it

  3. #3
    Forum Contributor
    Join Date
    02-27-2008
    Posts
    764

    Re: Match macro

    Hi
    here is an answer with macros.
    Ravi
    Attached Files Attached Files

  4. #4
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Match macro

    This is a duplicate post and as such does not comply with Rule 5 of our forum rules.
    Hope that helps.

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

    Free DataBaseForm example

+ 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