+ Reply to Thread
Results 1 to 4 of 4

Creating a table

  1. #1
    Registered User
    Join Date
    09-15-2015
    Location
    Italy
    MS-Off Ver
    2019
    Posts
    49

    Creating a table

    hello
    i have a database of codes in the left part of the sheet in descending order of number.
    i would to create a table starting in the column AD in order to have a list of drawing codes.
    in AD1 i see the group name. using this i would to look up in a matrix (from V3 to AB100) and return the drawing number located in comunf F.
    in this way i have a full list of device's pieces.
    how can i do this?

    password is 1234
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    09-15-2015
    Location
    Italy
    MS-Off Ver
    2019
    Posts
    49

    Re: Creating a table

    no one can help me? i only have to create a table starting from a list of codes. i don't know how to search on a matrix of value.

  3. #3
    Forum Expert shukla.ankur281190's Avatar
    Join Date
    05-17-2014
    Location
    Lucknow, India
    MS-Off Ver
    Office 365
    Posts
    3,935

    Re: Creating a table

    What is expected result can you put the same once with some more explanation
    If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)

  4. #4
    Registered User
    Join Date
    09-15-2015
    Location
    Italy
    MS-Off Ver
    2019
    Posts
    49

    Re: Creating a table

    Quote Originally Posted by shukla.ankur281190 View Post
    some more explanation
    here's a simplified file.
    in AD1 i wrote the name of group (each group is composed by some pieces of column F).
    a piece in F belongs to the groups i write in columns V, W... so 1 piece can belong to many groups.
    for example group 110.05 is composed by pieces DP.110.00.102, DP.110.00.107, ecc...
    i would to have these pieces from AD4 onwards
    Attached Files Attached Files

+ 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. Creating a Pivot Table using Data Table in different file?
    By JasonMcQueen in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-13-2016, 11:56 AM
  2. [SOLVED] Creating/Populating TABLE (NEW) from an OLD TABLE base on ListBox choices
    By Gilcano in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-06-2015, 08:30 PM
  3. Replies: 9
    Last Post: 02-26-2014, 04:17 PM
  4. Help creating vba function to move data from table to table on if condtion
    By damaple in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-09-2013, 05:42 AM
  5. Replies: 0
    Last Post: 08-09-2013, 12:32 PM
  6. Creating new table from selective data in original table
    By rasmussk in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-18-2009, 09:46 AM
  7. Creating a filtered table from a source table in another sheet
    By penfold in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-12-2008, 07:44 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