+ Reply to Thread
Results 1 to 3 of 3

How to automatically generate the Assembly product name of column H according to Part Code

  1. #1
    Registered User
    Join Date
    08-31-2020
    Location
    Japan
    MS-Off Ver
    2016
    Posts
    8

    How to automatically generate the Assembly product name of column H according to Part Code

    How to automatically generate the Assembly product name of column H according to Part material code

    Source information is in Sheet1, I want Sheet2 automatically generate the Assembly product name of column H according
    to Part material code , Finally, the Assembly product name is separated by a comma .The A5:A100 of SHEET2 is started by the
    user inputting the Part material code, and the H column is automatically generated

    Can someone please help me with that one? It would be much appreciated.Thanks in advance
    Attached Files Attached Files
    Last edited by Sakurayuki; 09-17-2020 at 08:47 AM.

  2. #2
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013
    Posts
    16,660

    Re: How to automatically generate the Assembly product name of column H according to Part

    UDF
    https://www.excelforum.com/excel-pro...ml#post5231003

    Use in cell like
    Seet2!H5:
    =JoinIf(Sheet1!$A$5:$B$25,2,A5,1,",")
    where;
    Sheet1!$A$5:$B$25 = Data range
    2 = relative column index within data range for key.
    A5 = the key to be searched
    1 = relative column index within data range for items to be joined.
    and copy down
    Please Login or Register  to view this content.
    If you want to call it from the procedure then add
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    08-31-2020
    Location
    Japan
    MS-Off Ver
    2016
    Posts
    8

    Re: How to automatically generate the Assembly product name of column H according to Part

    Good evening, teacher, Teacher you help me the answer again, you are a great teacher, thank you very much
    こんばんは、先生、あなたはまた先生です、あなたは私が答えるのを助けます、あなたは素晴らしい先生です、どうもありがとう

+ 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. Replies: 3
    Last Post: 09-19-2019, 06:28 PM
  2. [SOLVED] Generate Barcode in Single Cell using Product Code in Separate Cell
    By Paulo19 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-09-2016, 04:08 AM
  3. [SOLVED] Auto-generate part numbers list in one column
    By yohanmcdonald in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-10-2015, 07:54 PM
  4. [SOLVED] Generate a code that changes automatically every month
    By neima in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-15-2014, 11:04 AM
  5. [SOLVED] I need to automatically retrieve data relating to a product code upon entry.
    By Kylemarc in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 08-12-2013, 09:21 AM
  6. How to add up quantity automatically by scanning product code?
    By sheiling in forum Excel - New Users/Basics
    Replies: 0
    Last Post: 08-01-2013, 06:21 AM
  7. Automatically fill-in cells based on assembly structure
    By Excel white-belt in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 12-05-2012, 11:35 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