+ Reply to Thread
Results 1 to 17 of 17

repeat missed items based on match helper column

  1. 03-07-2022, 06:57 AM #1
    abdo meghari
    abdo meghari is offline
    Forum Contributor
    Join Date
    12-02-2020
    Location
    Asia
    MS-Off Ver
    2010 insider(Windows 10 64-bit)
    Posts
    803

    repeat missed items based on match helper column

    hi guys

    I would match column B across multiple sheets with helper column K into sheet FS ,if the missed item in column B matched with one of them into column K , then should repeat for all the items across multiple sheets . for instance the sheet FS one item contain INDO ,then should fill all of item INDO in last position ,also sheet DTYO there are about four items into column B contain THI , then should fill all of the items THI .as to sheet FSI there are about three items into column B contain JAP, then should fill all of the items JAP .
    but I have rare case , somtimes there is no items into column B match with column K . I mean to don't contain any items based on column K, then should fill all of the items JAP
    I put the result how should be as in last three sheets, but should be in the same sheet for each sheet separately
    also issued in this forum https://www.mrexcel.com/board/thread...olumn.1198169/
    Attached Files Attached Files
    Last edited by abdo meghari; 03-07-2022 at 07:08 AM.
    Reply With QuoteRegister To Reply
  2. 03-07-2022, 05:36 PM #2
    maniacb
    maniacb is offline
    Forum Expert
    Join Date
    05-29-2020
    Location
    NH USA
    MS-Off Ver
    365
    Posts
    2,103

    Re: repeat missed items based on match helper column

    Give this code a try

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  3. 03-08-2022, 12:48 AM #3
    abdo meghari
    abdo meghari is offline
    Forum Contributor
    Join Date
    12-02-2020
    Location
    Asia
    MS-Off Ver
    2010 insider(Windows 10 64-bit)
    Posts
    803

    Re: repeat missed items based on match helper column

    thanks, but your code merges all of data for all the sheets into second the sheet . should be for each sheet separately .
    Reply With QuoteRegister To Reply
  4. 03-08-2022, 04:08 AM #4
    abdo meghari
    abdo meghari is offline
    Forum Contributor
    Join Date
    12-02-2020
    Location
    Asia
    MS-Off Ver
    2010 insider(Windows 10 64-bit)
    Posts
    803

    Re: repeat missed items based on match helper column

    this is what I got as in attached file into second sheet.
    you can see your result based on the code .it shows just in second sheet . you can compare with my result in last three sheets( result should be in first three sheets).
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  5. 03-08-2022, 05:13 AM #5
    Sintek
    Sintek is offline
    Forum Guru Sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2019 | 2021
    Posts
    14,958

    Re: repeat missed items based on match helper column

    You have trailing spaces in Sheets("DTYO1").Range("B12")...Remove it...

    Please Login or Register  to view this content.
    Good Luck...
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the [★ Add Reputation] to left of post window...
    Also....Add a comment if you like!!!!
    And remember...Mark Thread as Solved...
    Excel Forum Rocks!!!
    Reply With QuoteRegister To Reply
  6. 03-08-2022, 05:32 AM #6
    abdo meghari
    abdo meghari is offline
    Forum Contributor
    Join Date
    12-02-2020
    Location
    Asia
    MS-Off Ver
    2010 insider(Windows 10 64-bit)
    Posts
    803

    Re: repeat missed items based on match helper column

    @sintek thanks , but it seems to work incorrectly .
    may you test it please?
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  7. 03-08-2022, 05:48 AM #7
    Sintek
    Sintek is offline
    Forum Guru Sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2019 | 2021
    Posts
    14,958

    Re: repeat missed items based on match helper column

    My bad...Always forget...Users run from different sheets...
    Add...Red snippet
    Please Login or Register  to view this content.
    Last edited by Sintek; 03-08-2022 at 05:53 AM.
    Reply With QuoteRegister To Reply
  8. 03-08-2022, 06:08 AM #8
    abdo meghari
    abdo meghari is offline
    Forum Contributor
    Join Date
    12-02-2020
    Location
    Asia
    MS-Off Ver
    2010 insider(Windows 10 64-bit)
    Posts
    803

    Re: repeat missed items based on match helper column

    fantastic ! may you make one space when filled ?
    I note create two spaces . I want to be equal for one space for all .
    Reply With QuoteRegister To Reply
  9. 03-08-2022, 06:11 AM #9
    Sintek
    Sintek is offline
    Forum Guru Sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2019 | 2021
    Posts
    14,958

    Re: repeat missed items based on match helper column

    Code makes one space...Your data has trailing spaces...I told you to remove...
    Reply With QuoteRegister To Reply
  10. 03-08-2022, 06:43 AM #10
    abdo meghari
    abdo meghari is offline
    Forum Contributor
    Join Date
    12-02-2020
    Location
    Asia
    MS-Off Ver
    2010 insider(Windows 10 64-bit)
    Posts
    803

    Re: repeat missed items based on match helper column

    I think all of the items are equel in the spaces ,but the code makes two spaces before the last item when filling .
    you can see it yourself .
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  11. 03-08-2022, 06:50 AM #11
    Sintek
    Sintek is offline
    Forum Guru Sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2019 | 2021
    Posts
    14,958

    Re: repeat missed items based on match helper column

    but the code makes two spaces before the last item when filling 
    Please Login or Register  to view this content.
    No it does not...Code makes one space...

    abno...Look at your data before running code...
    Your data has trailing spaces...Have told you multiple times now...
    See attached highlighted yellow...has space after last character...
    Same with other sheets...
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  12. 03-08-2022, 07:13 AM #12
    abdo meghari
    abdo meghari is offline
    Forum Contributor
    Join Date
    12-02-2020
    Location
    Asia
    MS-Off Ver
    2010 insider(Windows 10 64-bit)
    Posts
    803

    Re: repeat missed items based on match helper column

    See attached highlighted yellow...has space after last character...
    actually I misunderstood about the last character , I
    don't expect to be error after last character sorry!!
    just last thing about this problem, may you mod your code by delete any spaces may be after last character? if you can't I will close this thread and satisfy of this answering.
    thanks
    Reply With QuoteRegister To Reply
  13. 03-08-2022, 07:33 AM #13
    Sintek
    Sintek is offline
    Forum Guru Sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2019 | 2021
    Posts
    14,958

    Re: repeat missed items based on match helper column

    Why wanna fix incorrect data entry with code when all you have to do is make sure data has no trailing space...

    The things we do...

    Please Login or Register  to view this content.
    Last edited by Sintek; 03-08-2022 at 07:43 AM.
    Reply With QuoteRegister To Reply
  14. 03-08-2022, 07:51 AM #14
    abdo meghari
    abdo meghari is offline
    Forum Contributor
    Join Date
    12-02-2020
    Location
    Asia
    MS-Off Ver
    2010 insider(Windows 10 64-bit)
    Posts
    803

    Re: repeat missed items based on match helper column

    Why wanna fix incorrect data entry with code when all you have to do is make sure data has no trailing space...
    because I have another macro depends on all of the spaces are equal otherwise doesn't work.
    just you need fixing this line
    HTML Code: 
    as you have ever said
    .Parent.Evaluate
    thanks very much for your code and time,effort. what I can say to you.you're the best
    Last edited by abdo meghari; 03-08-2022 at 07:55 AM.
    Reply With QuoteRegister To Reply
  15. 03-08-2022, 07:54 AM #15
    Sintek
    Sintek is offline
    Forum Guru Sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2019 | 2021
    Posts
    14,958

    Re: repeat missed items based on match helper column

    what I can say to you.you're the best
    Ha ha...You've said that to others in other threads as well lol...

    Like us all...I'm just learning...
    Thanks for rep +
    Reply With QuoteRegister To Reply
  16. 03-08-2022, 09:57 AM #16
    maniacb
    maniacb is offline
    Forum Expert
    Join Date
    05-29-2020
    Location
    NH USA
    MS-Off Ver
    365
    Posts
    2,103

    Re: repeat missed items based on match helper column

    Looks like Sintek provided a great solution. Here is an update, changes highlighted in red. It also addresses the trailing space issue.

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  17. 03-08-2022, 10:07 AM #17
    abdo meghari
    abdo meghari is offline
    Forum Contributor
    Join Date
    12-02-2020
    Location
    Asia
    MS-Off Ver
    2010 insider(Windows 10 64-bit)
    Posts
    803

    Re: repeat missed items based on match helper column

    Looks like Sintek provided a great solution
    also you did it.
    the code is very fast .
    many thanks
    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. match missed items between two sheets into one column and add the missed
    By abdo meghari in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-08-2022, 02:10 AM
  2. [SOLVED] Match between two sheets and bring missed elements based on column and arrange again
    By abdo meghari in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-24-2021, 10:46 AM
  3. Index match match with helper column
    By rkrogh in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-15-2020, 03:10 AM
  4. Group/Sort Data using helper column (Index Match)
    By qwertyuiop123654 in forum Excel General
    Replies: 1
    Last Post: 03-30-2020, 11:07 PM
  5. Counting Repeat Occurances Using a Helper Column
    By Round_Sphere in forum Excel General
    Replies: 5
    Last Post: 11-16-2018, 08:03 PM
  6. [SOLVED] PivotTable Report ,How to bring rows sub items to next column and repeat the parrent items
    By ImranBhatti in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 10-05-2017, 02:41 PM
  7. Sort by helper column even if values in helper are alike
    By NoSleepForMe in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-10-2016, 04:14 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