+ Reply to Thread
Results 1 to 4 of 4

Need VBA code to lookup vaue through micr code copy matching rows to under group

  1. #1
    Forum Contributor
    Join Date
    02-28-2016
    Location
    australia
    MS-Off Ver
    2019
    Posts
    194

    Need VBA code to lookup vaue through micr code copy matching rows to under group

    Dear sir

    I have master workbooks which contains scrap details of server In sheet FPI_Master contains master consolidate report, In Sheet Loop MICR code & Groups

    i want lookup through MICR code to master sheet Kcolumn values copy which are get result and paste under group of FPI individually.

    There are some group like CN,Duplicate,Lop,Replace server,Repair...etc so Code micr which match to K:K in master those lines copy to summary with header of group FPI Report for the Month of Mar'16

    summary is expect result.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    08-16-2015
    Location
    Antwerpen, Belgium
    MS-Off Ver
    2007-2016
    Posts
    2,380

    Re: Need VBA code to lookup vaue through micr code copy matching rows to under group

    This one you runs with the button in sheets "loop"

    result in sheets "test"

    Please Login or Register  to view this content.
    Kind regards
    Leo
    Attached Files Attached Files

  3. #3
    Forum Expert
    Join Date
    11-23-2005
    Location
    Rome
    MS-Off Ver
    Ms Office 2016
    Posts
    1,628

    Re: Need VBA code to lookup vaue through micr code copy matching rows to under group

    You could try with this code, run Macro1:
    Please Login or Register  to view this content.
    Regards,
    Antonio

  4. #4
    Forum Contributor
    Join Date
    02-28-2016
    Location
    australia
    MS-Off Ver
    2019
    Posts
    194

    Re: Need VBA code to lookup vaue through micr code copy matching rows to under group

    Thanks Experts It works sorry for late reply. Solved

+ 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. [help with code] need to update existing code to copy and keep rows on input page
    By scott micklo in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-25-2016, 01:36 PM
  2. [SOLVED] Code to group rows with the same time value?
    By bvercher in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-03-2015, 11:07 AM
  3. Help with VBA code for selecting Multi Rows in Subtotal Group
    By isisisis in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-28-2014, 07:34 PM
  4. [SOLVED] Need VBA code to count number of rows & split into group of 7 rows in same sheet
    By amy_d2 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 06-05-2013, 11:03 AM
  5. Replies: 2
    Last Post: 11-05-2012, 09:28 AM
  6. code required to copy and paste rows matching a criteria.
    By Duguid1 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-30-2008, 04:49 AM
  7. VBA Code to Group Rows Based on Cell Contents
    By Pliskers in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-10-2006, 03:29 AM

Tags for this Thread

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