Results 1 to 6 of 6

Combining 2 columns in different spreadsheets and creating all combinations

Threaded View

  1. #1
    Registered User
    Join Date
    09-09-2013
    Location
    United States
    MS-Off Ver
    Excel 2013
    Posts
    3

    Combining 2 columns in different spreadsheets and creating all combinations

    I have a bit of a dilemma. So i have 2 spreadsheet and i created temporary sheets as the ones I am designing contain sensitive information. I've been a bit out of the loop when it comes to vba so here i am seeking help


    So i created a spreadsheet which contains a list of all presidents and i also created a 2nd spreadsheet which contains all states. As an example we have

    PRESIDENTS
    Barack Obama
    George Bush
    Bill Clinton
    George Bush
    Ronald Reagan

    Next we have states
    Alabama
    Texas
    Oklahoma
    Utah

    What the results that I am looking for is combining the sheets or creating some code by which i could produce the following results.

    AlabamaBarack Obama
    AlabamaGeorge Bush
    AlabamaBill Clinton
    AlabamaGeorge Bush
    AlabamaRonald Reagan
    TexasBarack Obama
    TexasGeorge Bush
    TexasBill Clinton
    TexasGeorge Bush
    TexsaRonald Reagan
    ETC
    ETC
    ETC

    Please help as I am stuck
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Creating formula for combining several columns
    By lmm in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-26-2013, 08:33 PM
  2. [SOLVED] combining numbers into combinations
    By David in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-06-2005, 02:05 AM
  3. combining numbers into combinations
    By David in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-06-2005, 01:05 AM
  4. combining numbers into combinations
    By David in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-05-2005, 10:05 PM
  5. [SOLVED] combining numbers into combinations
    By David in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-29-2005, 11:05 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