+ Reply to Thread
Results 1 to 3 of 3

How to cross reference two columns of numbers

  1. #1
    Registered User
    Join Date
    11-11-2009
    Location
    Columbus, Ohio; USA
    MS-Off Ver
    Excel 2002
    Posts
    70

    Smile How to cross reference two columns of numbers

    I'd like to ask for vba code that will take a required material length of say .5 meters at 4 pieces needed and to list it out in a new table as .5, .5, .5, .5?
    One cell contains .5 and the adjacent cell contains the number 4 for quantity.

    Once it is listed out individually, I want to compare availability to another list.

    Is this a common thing done with vba. Is this something that can be done with macro recording. I just want a general suggestion of a direction to take to learn.

    Thank you

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,474

    Re: How to cross reference two columns of numbers

    To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

    If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

    Doing this will ensure you get the result you need!

  3. #3
    Registered User
    Join Date
    11-11-2009
    Location
    Columbus, Ohio; USA
    MS-Off Ver
    Excel 2002
    Posts
    70

    Re: How to cross reference two columns of numbers

    Hello. I have a number of levels I want to take this project, but this is a first step. I'd like to know if this first step could easily be done by recording macros or will some tedious vba programming be necessary or not. I'd like to describe what I want to do and include just an explanation excel file with a few values to give you a general sense of what I want to do.

    In my programming as a first step I want to check the existence of certain required lengths against a list of stock. It is expressed in the way in the attached file:

    I want encouragement on whether it is feasible to create VBA code for the user to click a "button 1" going down the quantities of each requirement, one by one, and checking the stock with the shortest pieces of stock to be utilized first, and if available, list on another table below in the excel worksheet which of the requirments were found to be available in the stock. And there is a column to the right which displays the dollar amount of the remaining material one the requirment is cut from the stock. Then assuming the stock will be used I want a "button 2" to be pressed to reduce the available stock length and quantities.

    I am including an excel file here that has example requirments and available stock. I indicated in two green circles "buttons" which will ultimately have the macros assigned to them and the zones on the screen where the results will be shown. For simplicity sake, I would want the results to on the same worksheet so as to avoid the user needing to click on another worksheet for the resuls and going back and forth, but maybe I need a second sheet to list the results to have more space to display results that might not fit in the alotted rows on the same worksheet.

    In summary, this first facet of the project is to check availability of a requirment against a list, cross checking, with a goal to use up the shortest pieces in stock first and to display the list. Dollar values of the remaining material will be displayed in a column on the right.

    Any suggestions to improve this question or to provide clearer information is appreciated. Thank you very much.
    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)

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