+ Reply to Thread
Results 1 to 7 of 7

Combinations of Cell Values

  1. #1
    Forum Contributor pr4t3ek's Avatar
    Join Date
    10-13-2008
    Location
    Melbourne, Australia
    MS-Off Ver
    2003 & 2007, 2010
    Posts
    483

    Combinations of Cell Values

    Hi,

    In the attached workbook, I have one tab named Reference. In this tab I have a list of all distance packages.
    What I would like in the second tab (Data) is for a macro to populate in the two columns all the combinations of these packages.

    I hope this makes sense.

    Cheers
    Attached Files Attached Files
    Last edited by pr4t3ek; 04-09-2014 at 03:40 AM.
    --
    Regards
    PD

    ----- Don't Forget -----

    1. Use code tags. Place "[code]" before the first line of code and "[/code"]" after the last line of code. Exclude quotation marks

    2. Thank those who have helped you by Clicking the scales above each post.

    3. Please mark your post [SOLVED] if it has been answered satisfactorily.

  2. #2
    Forum Expert millz's Avatar
    Join Date
    08-14-2013
    Location
    Singapore
    MS-Off Ver
    Excel, Access 2016
    Posts
    1,694

    Re: Combinations

    Try running this on the Reference sheet. Make sure you do not have an existing sheet named "Data", it will be created.

    Please Login or Register  to view this content.
    多么想要告诉你 我好喜欢你

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,049

    Re: Combinations

    Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

    Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

    To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

    (This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  4. #4
    Forum Contributor pr4t3ek's Avatar
    Join Date
    10-13-2008
    Location
    Melbourne, Australia
    MS-Off Ver
    2003 & 2007, 2010
    Posts
    483

    Re: Combinations

    Awesome. thanks

  5. #5
    Forum Expert millz's Avatar
    Join Date
    08-14-2013
    Location
    Singapore
    MS-Off Ver
    Excel, Access 2016
    Posts
    1,694

    Re: Combinations

    Hi pr4t3ek, even though your problem is solved, please do not simply ignore moderation requests. It just reflects your attitude too much.

    I paid little attention to the title initially because it made sense to me, you required combinations of values. But on a second thought, I suggest this would fit better: Combinations of cell values

  6. #6
    Forum Contributor pr4t3ek's Avatar
    Join Date
    10-13-2008
    Location
    Melbourne, Australia
    MS-Off Ver
    2003 & 2007, 2010
    Posts
    483

    Re: Combinations

    Relax millz, I didn't see FDibbins post. Secondly, whats the value add in saying 'It just reflects your attitude too much'..... you don't know me?

    I will update the title.

    Have a fantastic day.

  7. #7
    Forum Expert millz's Avatar
    Join Date
    08-14-2013
    Location
    Singapore
    MS-Off Ver
    Excel, Access 2016
    Posts
    1,694

    Re: Combinations

    Quote Originally Posted by pr4t3ek View Post
    I didn't see FDibbins post
    Really?



    You have my apologies then. Thanks for abiding to the moderation request.

+ 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. Combinations
    By shart2k12 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-22-2013, 09:46 PM
  2. Finding possible combinations & listing the wanted combinations
    By Zoke in forum Excel Programming / VBA / Macros
    Replies: 30
    Last Post: 07-16-2012, 03:41 PM
  3. Combinations
    By douglas.osborne in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-06-2010, 06:32 PM
  4. All combinations of 1 and 2
    By Ipsl in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-25-2008, 11:56 AM
  5. [SOLVED] Combinations
    By Peo Sjoblom in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-06-2005, 06:05 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