+ Reply to Thread
Results 1 to 6 of 6

Trying to create a cross reference sheet within a workbook

  1. #1
    Registered User
    Join Date
    02-12-2014
    Location
    United States
    MS-Off Ver
    Excel 2013
    Posts
    10

    Trying to create a cross reference sheet within a workbook

    Hey guys will try to explain as best as possible to what I am trying to accomplish. I have a row of columns named OEM and separate rows for clients. I have indicated in the rows as to which clients have access to which OEM. In some cases a client may have access to multiple OEMs. So what I am trying to do is create a separate sheet for each OEM and then bring over the client list automatically as new clients and new OEMs are added to the workbook. Is this possible and if so how do I accomplish it. Thanks in advance for any help or ideas.
    Capture.JPG

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,570

    Re: Trying to create a cross reference sheet within a workbook

    To attach a Workbook
    (please do not post pictures of worksheets)
    • Click Advanced (next to quick post),
    • Scroll down until you see "Manage Attachments",
    • Click that then select "add files" (top right corner).
    • Click "Select Files" find your file, click "open" click "upload"
    • Once the upload is completed the file name will appear below the input boxes in this window.
    • Click "Done" at bottom right to close the Attachment Manager.
    • Click "Submit Reply"
    Ben Van Johnson

  3. #3
    Registered User
    Join Date
    02-12-2014
    Location
    United States
    MS-Off Ver
    Excel 2013
    Posts
    10

    Re: Trying to create a cross reference sheet within a workbook

    Sorry for the newb post. Here is the workbook.
    Attached Files Attached Files

  4. #4
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,570

    Re: Trying to create a cross reference sheet within a workbook

    Try:
    Please Login or Register  to view this content.
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    02-12-2014
    Location
    United States
    MS-Off Ver
    Excel 2013
    Posts
    10

    Re: Trying to create a cross reference sheet within a workbook

    Awesome thank you very much. Is there any way I can set the range for the OEM column length so that I can add more columns for different entries?

  6. #6
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,570

    Re: Trying to create a cross reference sheet within a workbook

    The line:
    Set OEMList = .Range("B1").Resize(COLUMNsize:=.Range("A1").CurrentRegion.Columns.Count - 1)
    should automatically adjust for the current number of columns each time the macro is run. They are not "hard coded".

+ 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. Need help to create parts cross reference table
    By hp801 in forum Excel General
    Replies: 1
    Last Post: 01-29-2014, 05:55 AM
  2. How do I create a cross reference database?
    By edita182 in forum Excel General
    Replies: 1
    Last Post: 09-18-2013, 02:17 PM
  3. Replies: 3
    Last Post: 03-12-2013, 05:31 PM
  4. [SOLVED] copy active sheet, create new workbook, name new workbook based on cell reference
    By jm0392 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-20-2012, 07:12 PM
  5. How to cross reference and create automatic commenting
    By VoidnessMD in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-28-2010, 06:00 PM

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