+ Reply to Thread
Results 1 to 4 of 4

Need a macro that pastes based on matching numbers

  1. 07-04-2023, 10:58 AM #1
    skhande2
    skhande2 is offline
    Registered User
    Join Date
    11-01-2020
    Location
    London, uk
    MS-Off Ver
    365
    Posts
    87

    Need a macro that pastes based on matching numbers

    I need a macro that fills column A of sheet 'BOM' with the first set of data found after 'Operation Costs of Item : ' in sheet 'ticpr2420m000 Data Dump'. But there are multiple 'Operation Costs of Item : ', so it picks the one whose number to its cell to the left matches the number in column C of the row from 'BOM'.

    I've attached 2 sheets (before and after for preview)

    demo.xlsx
    demo after.xlsx

    Thanks!
    Last edited by skhande2; 07-04-2023 at 02:50 PM.
    Reply With QuoteRegister To Reply
  2. 07-04-2023, 11:12 AM #2
    Marc L
    Marc L is offline
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    9,831

    Exclamation Re: Need a macro that pastes based on matching numbers


    Follow at least and definitively the top page yellow banner 'HOW TO ATTACH YOUR SAMPLE WORKBOOK' …
    Reply With QuoteRegister To Reply
  3. 07-04-2023, 02:50 PM #3
    skhande2
    skhande2 is offline
    Registered User
    Join Date
    11-01-2020
    Location
    London, uk
    MS-Off Ver
    365
    Posts
    87

    Re: Need a macro that pastes based on matching numbers

    Ok, the links should work now
    Reply With QuoteRegister To Reply
  4. 07-05-2023, 02:44 PM #4
    skhande2
    skhande2 is offline
    Registered User
    Join Date
    11-01-2020
    Location
    London, uk
    MS-Off Ver
    365
    Posts
    87

    Re: Need a macro that pastes based on matching numbers

    Bummies bummies my tummy needs some chummies?
    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] Matching Correct Box Item Numbers Based on Lookup
    By UseForce in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 06-23-2022, 01:57 PM
  2. Macro that copies and pastes a row based on a certain condition on SAME sheet.
    By jmm1335 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-24-2021, 02:06 AM
  3. [SOLVED] Macro that merges matching data from two sheets and pastes to a new sheet (in line)
    By njmiller31 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-16-2013, 11:06 AM
  4. A macro that copy and pastes to line below but pastes in a Values and numbers format
    By streyb in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-03-2012, 07:06 PM
  5. A macro that copy and pastes to line below but pastes in a Values and numbers format
    By streyb in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-05-2012, 03:20 PM
  6. [SOLVED] Automating a macro that copies and pastes data and pastes 2 rows under the previous one.
    By thebank in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-30-2012, 05:02 PM
  7. I have a script in where it copies a sheet's data, and pastes it, but over pastes...
    By Cyberpawz in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-24-2012, 02:20 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