+ Reply to Thread
Results 1 to 10 of 10

VBA function help. Concat cells based on parallel value. Function Included!

  1. #1
    Registered User
    Join Date
    01-18-2013
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    6

    Exclamation VBA function help. Concat cells based on parallel value. Function Included!

    Excel Gurus,
    I am in the middle of a massive project and have no idea how to use VBA. I have this function below that will do what I need, but I don't know how to curtail it to run on my spreadsheet. Cells need to be changed to mine? Ranges? Help!

    My worksheet: All data in Cols A and B on Sheet1, 30k lines, need to consolidate! Note: data is not actually just numbers and letters, its text strings where Col A has many file names (repeating 2-250+ times each, Col B is list of data contained in said file)

    Data format I currently have:
    Please Login or Register  to view this content.
    Desired format:

    Please Login or Register  to view this content.
    This is the function I was given that should get the job done, but I don't know what I need to do to get it to run in my worksheet.

    Please Login or Register  to view this content.
    Can anyone help me? I'm in a huge bind and need to get this finished before 9am ;( What do I need to edit in the function, and how do I run it in my worksheet?
    Gurus, save me!

  2. #2
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,464

    Re: VBA function help. Concat cells based on parallel value. Function Included!

    Try this
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    01-18-2013
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: VBA function help. Concat cells based on parallel value. Function Included!

    Thanks for the response. When I paste this code into VBA macro and execute in Excel, I get the following error.

    Runtime Error '1004'
    Application Defined or Object Defined Error

  4. #4
    Registered User
    Join Date
    01-18-2013
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: VBA function help. Concat cells based on parallel value. Function Included!

    the line it highlights with the error is:

    Please Login or Register  to view this content.

  5. #5
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,464

    Re: VBA function help. Concat cells based on parallel value. Function Included!

    Can't replicate the error.

    Can you upload the file?

  6. #6
    Registered User
    Join Date
    01-18-2013
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: VBA function help. Concat cells based on parallel value. Function Included!

    Here you are
    Last edited by xsa; 01-18-2013 at 10:53 AM.

  7. #7
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,464

    Re: VBA function help. Concat cells based on parallel value. Function Included!

    Working fine for me....

  8. #8
    Registered User
    Join Date
    01-18-2013
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: VBA function help. Concat cells based on parallel value. Function Included!

    its running and outputting about the first 40 lines and thats it. Strange it runs for you but not me. could you email me the file that youve executed it on?

  9. #9
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,464

    Re: VBA function help. Concat cells based on parallel value. Function Included!

    Col C/D will have 653 rows in result.
    Last edited by jindon; 01-18-2013 at 10:22 AM. Reason: attachment removed due to OP's request.

  10. #10
    Registered User
    Join Date
    01-18-2013
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: VBA function help. Concat cells based on parallel value. Function Included!

    thanks so much, it must be something on my end, as even your file stops at the same place mine was. Ill try on a new machine.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

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