+ Reply to Thread
Results 1 to 18 of 18

Move To Next Available Cell Matching Part Number Checking Duplicates

  1. #1
    Banned User!
    Join Date
    12-17-2020
    Location
    Texas
    MS-Off Ver
    2010
    Posts
    229

    Move To Next Available Cell Matching Part Number Checking Duplicates

    Hello,

    This may be complicated but hopefully can be done with VBA. I would like the BULLETIN & KIT sheet to have data added from the Move to B & K sheet matching the PMA Part Number. This needs to check if the BULLETIN & KIT is already there so there won't be any duplicates. It should fill in the next available cell on the row matching the PMA Part Number.

    I appreciate it very much for your help.

    Thanks

  2. #2
    Banned User!
    Join Date
    12-17-2020
    Location
    Texas
    MS-Off Ver
    2010
    Posts
    229

    Re: Move To Next Available Cell Matching Part Number Checking Duplicates

    Maybe this request isn't a possibility?

  3. #3
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010
    Posts
    7,095

    Re: Move To Next Available Cell Matching Part Number Checking Duplicates

    Could you explain, step by step, in more detail what you want to do referring to specific cells, rows, columns and sheets using a few examples from your data? Do you want to search in the "Move to B & K Sheet" sheet for the value entered in B4 of the "BULLETIN & KIT" sheet and find the corresponding PMA Part Number?
    You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
    Practice makes perfect. I'm very far from perfect so I'm still practising.

  4. #4
    Banned User!
    Join Date
    12-17-2020
    Location
    Texas
    MS-Off Ver
    2010
    Posts
    229

    Re: Move To Next Available Cell Matching Part Number Checking Duplicates

    This will be a move of data from the 'Move to B & K Sheet' to the 'BULLETIN & KIT' sheet.

    Once it is moved I will delete the 'Move to B & K Sheet'.

    The data matches the PMA Part Number. The data is comprised of BULLETIN & KIT numbers for instance: 2061 & AK1003.

    There needs to be a check to see if that BULLETIN & KIT numbers exist for the PMA Part Number so there aren't any duplicates.

    I hope I explained well enough.

    Thank you
    Last edited by BobBrown60; 03-15-2021 at 11:50 AM.

  5. #5
    Banned User!
    Join Date
    12-17-2020
    Location
    Texas
    MS-Off Ver
    2010
    Posts
    229

    Re: Move To Next Available Cell Matching Part Number Checking Duplicates

    Maybe one more detail.

    On the BULLETIN & KIT sheet if you look at cell J4 it is empty. If there are any kits from the Move sheet it will go there and the next if necessary will be put in cell K4 and the next in L4 and so on.

  6. #6
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010
    Posts
    7,095

    Re: Move To Next Available Cell Matching Part Number Checking Duplicates

    I'm sorry but I still don't follow. You will have to explain in much more detail, step by step referring to specific cells. If we start with J4 which is empty, what cells do I use to find the kits from the Move sheet to place in J4, K4, L4, etc.?

  7. #7
    Banned User!
    Join Date
    12-17-2020
    Location
    Texas
    MS-Off Ver
    2010
    Posts
    229

    Re: Move To Next Available Cell Matching Part Number Checking Duplicates

    Match the PMA Part Number on the Move sheet to 10M207 and you see there aren't any to fill. Whereas PMA Part Number 10M75 will have 2097 & YK1037 and 2110 & YK1048 filled in cells J5 and K5.

  8. #8
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010
    Posts
    7,095

    Re: Move To Next Available Cell Matching Part Number Checking Duplicates

    Let me see if I understood correctly.
    You want to loop through all the PMA Part Numbers in column G of the BULLETIN & KIT sheet. Then you want to check if the Bulletin & Kits in columns I to X for each part number exist in Move to B & K Sheet. If they exist in Move to B & K Sheet then you don't want to copy them. You want to copy only the Bulletin & Kits that don't exist in the BULLETIN & KIT sheet for each part number. Is this correct?

  9. #9
    Banned User!
    Join Date
    12-17-2020
    Location
    Texas
    MS-Off Ver
    2010
    Posts
    229

    Re: Move To Next Available Cell Matching Part Number Checking Duplicates

    Yes that is it. I am so sorry for my poor explanations.

  10. #10
    Banned User!
    Join Date
    12-17-2020
    Location
    Texas
    MS-Off Ver
    2010
    Posts
    229

    Re: Move To Next Available Cell Matching Part Number Checking Duplicates

    I guess I should close this thread and figure out something else. Sorry for the trouble.

  11. #11
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010
    Posts
    7,095

    Re: Move To Next Available Cell Matching Part Number Checking Duplicates

    With a little more time I may have something for you. Can there be any duplicate BULLETIN & KIT numbers in any row in the Move to B & K Sheet?

  12. #12
    Banned User!
    Join Date
    12-17-2020
    Location
    Texas
    MS-Off Ver
    2010
    Posts
    229

    Re: Move To Next Available Cell Matching Part Number Checking Duplicates

    Yes I am finding some duplicates and removing. I will attach the clean workbook soon.

  13. #13
    Banned User!
    Join Date
    12-17-2020
    Location
    Texas
    MS-Off Ver
    2010
    Posts
    229

    Re: Move To Next Available Cell Matching Part Number Checking Duplicates

    There are some duplicate PMA Part Numbers that I am sorting out sorry

  14. #14
    Valued Forum Contributor
    Join Date
    07-14-2017
    Location
    Poland
    MS-Off Ver
    Office 2010
    Posts
    506

    Re: Move To Next Available Cell Matching Part Number Checking Duplicates

    I think this does what you want.
    Check out my solution.
    Attached Files Attached Files
    Best Regards,
    Maras.

  15. #15
    Banned User!
    Join Date
    12-17-2020
    Location
    Texas
    MS-Off Ver
    2010
    Posts
    229

    Re: Move To Next Available Cell Matching Part Number Checking Duplicates

    Thank you maras_mak I ran the code from the new shape I put on the BULLETIN & KIT sheet called 'Click to Get Additional Kits'. It did put the appropriate new kits on the sheet with highlighted yellow cells.

    If I click the shape again it goes to error. The sheet 'Move to B & K Sheet' should be clearing the kits after running the code.

    Can you please take a look to see if these can be corrected?

    I really appreciate it
    Last edited by BobBrown60; 03-16-2021 at 11:58 AM.

  16. #16
    Valued Forum Contributor
    Join Date
    07-14-2017
    Location
    Poland
    MS-Off Ver
    Office 2010
    Posts
    506

    Re: Move To Next Available Cell Matching Part Number Checking Duplicates

    Now there should be no problems.
    After executing the procedure, all records are deleted and therefore you have to enter new data into 'Table10' to use the shape 'Get Kids'.
    Attached Files Attached Files

  17. #17
    Banned User!
    Join Date
    12-17-2020
    Location
    Texas
    MS-Off Ver
    2010
    Posts
    229

    Re: Move To Next Available Cell Matching Part Number Checking Duplicates

    Great that is fantastic I really appreciate the help.
    Last edited by BobBrown60; 03-16-2021 at 04:40 PM.

  18. #18
    Valued Forum Contributor
    Join Date
    07-14-2017
    Location
    Poland
    MS-Off Ver
    Office 2010
    Posts
    506

    Re: Move To Next Available Cell Matching Part Number Checking Duplicates

    Glad I could contribute...Tx for rep.

+ 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. Checking duplicates in the same cell across many sheets
    By roax in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 09-25-2017, 10:11 PM
  2. Formula to move part of a value to a new cell - part 2
    By forestavekids in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 04-28-2016, 12:34 PM
  3. [SOLVED] Remove duplicates of substitute part number
    By costi_linho12 in forum Excel General
    Replies: 11
    Last Post: 02-07-2015, 01:09 PM
  4. matching row number value with part of file name
    By HeHeHaHa in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-17-2014, 04:07 PM
  5. [SOLVED] Checking if cell contains part of a string in another cell.
    By AMWalton89 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-20-2014, 11:04 AM
  6. Checking if cell contains part of a string in another cell.
    By AMWalton89 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-20-2014, 08:03 AM
  7. Advanced lookup matching part of a number
    By MayfairBlue in forum Excel Formulas & Functions
    Replies: 24
    Last Post: 08-16-2012, 08:30 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