+ Reply to Thread
Results 1 to 4 of 4

Macro to match and paste the required rows against value by adding required rows and merge

  1. #1
    Registered User
    Join Date
    10-15-2014
    Location
    Pakistan
    MS-Off Ver
    2007
    Posts
    51

    Macro to match and paste the required rows against value by adding required rows and merge

    I would like to seek help for a macro code which will look b:b column ids match respective ids in "Edu" and "Exp" sheets in app id column, then paste the results in education and experience field by adding required rows. For example if app id 6 has 6 different degrees in edu and and organization served in exp then all should be pasted against 6 in master sheet by adding automatic row and merging the other column to fit the size. Example is shown for app id 6 same is wanted for 8 and so on

    Highlighted area is the required result, (been done manually)


    Will appreciate the support, as i always get from this forum already
    Attached Files Attached Files
    Last edited by toofani; 07-15-2016 at 04:09 AM.

  2. #2
    Registered User
    Join Date
    10-15-2014
    Location
    Pakistan
    MS-Off Ver
    2007
    Posts
    51

    Re: Macro to match and paste the required rows against value by adding required rows and m

    anybody can helpout ?

  3. #3
    Registered User
    Join Date
    10-15-2014
    Location
    Pakistan
    MS-Off Ver
    2007
    Posts
    51

    Re: Macro to match and paste the required rows against value by adding required rows and m

    adding reply just bring it upfront

  4. #4
    Registered User
    Join Date
    10-15-2014
    Location
    Pakistan
    MS-Off Ver
    2007
    Posts
    51

    Re: Macro to match and paste the required rows against value by adding required rows and m

    that was an urgent project for me.. please help me..

+ 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. Converting rows to columns and adding extra rows as required
    By teco in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-09-2016, 04:18 PM
  2. Replies: 4
    Last Post: 01-27-2015, 10:48 PM
  3. [SOLVED] Macro required to paste rows onto a single row until value changes in a column: HELP!!
    By khoary in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-30-2014, 08:37 AM
  4. Delete Rows Containing 00:00 - Macro Required
    By sambashir in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-25-2013, 06:28 AM
  5. [SOLVED] Macro help with combining data across 2 rows (and deleting non-required rows)
    By InnesMcc in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 05-20-2013, 05:21 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. MATCH AMOUNT FIFO METHOD & INSERT ROWS WHERE EVER REQUIRED.
    By Eddy Stan in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-29-2006, 12:45 AM

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