+ Reply to Thread
Results 1 to 4 of 4

Macro to Extract first Reference where Amount is the Same

  1. 06-14-2022, 02:57 AM #1
    Howardc1001
    Howardc1001 is offline
    Forum Contributor
    Join Date
    07-12-2018
    Location
    South Africa
    MS-Off Ver
    Office 2021
    Posts
    2,722

    Macro to Extract first Reference where Amount is the Same

    I need a macro to extract the same reference in Col T where the amount is the same and the branch is different to Col V for the matching amount but where the branches are different


    For Eg U2 and U5 the amount is the same and branch is different so the Ref in T2 must be extracted to V2 & V5


    Your assistance is most appreciated
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 06-14-2022, 05:40 AM #2
    bebo021999
    bebo021999 is offline
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,463

    Re: Macro to Extract first Reference where Amount is the Same

    Alt-F11 to open VBA window
    Insert Module, paste below code then hit F5 to run
    HTML Code: 
    Attached Files Attached Files
    Quang PT
    Reply With QuoteRegister To Reply
  3. 06-14-2022, 05:54 AM #3
    kvsrinivasamurthy
    kvsrinivasamurthy is online now
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,587

    Re: Macro to Extract first Reference where Amount is the Same

    What is V3, since S3<>S5 and U3=U5?
    Pl note
    Array formula should be confirmed with Ctrl+Shift+Enter keys together.
    If answere is satisfactory press * to add reputation.
    Reply With QuoteRegister To Reply
  4. 06-14-2022, 06:00 AM #4
    bebo021999
    bebo021999 is offline
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,463

    Re: Macro to Extract first Reference where Amount is the Same

    Quote Originally Posted by kvsrinivasamurthy View Post
    What is V3, since S3<>S5 and U3=U5?
    I guess searching for 1st occurence, then match in pair.
    2 matchs 5
    then 3 has nothing to match anymore.
    Anyway, wait for OP research.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Extract date and balance amount to be received
    By sekharks in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-06-2022, 12:13 PM
  2. Macro to extract amount from email (outlook) and copy/paste into Excel
    By jw01 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-11-2022, 06:20 AM
  3. [SOLVED] Macro to extract items based on amount
    By Howardc1001 in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 08-20-2021, 09:24 AM
  4. Extract Amount
    By majidsiddique in forum Excel General
    Replies: 1
    Last Post: 02-11-2021, 08:05 AM
  5. Extract Curr. from an amount formatted
    By Limor_OP in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 11-05-2020, 09:38 AM
  6. VBA Macro to extract deposit amount from a statement data in excel.
    By vkyjoshi in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-18-2016, 09:07 AM
  7. [SOLVED] Extract amount from pivot table
    By sagar007 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-21-2013, 03:03 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1