+ Reply to Thread
Results 1 to 8 of 8

Create a Table from two separate excel sheets/ tables

  1. 09-23-2015, 01:09 AM #1
    Timberjeremy
    Timberjeremy is offline
    Registered User
    Join Date
    09-17-2015
    Location
    USA
    MS-Off Ver
    Not sure
    Posts
    10

    Create a Table from two separate excel sheets/ tables

    I have no idea if this is possible but it would make my life much easier if it were.

    So lets say I have a table with a bunch of different room numbers... lets say 1-10 are the room numbers theres 10 rooms. If I have a table where there is a "1" of and "X" in the cell next to a room number it means that room is in use.

    Next I have a table of the people who rent these rooms, and which room they are in. Is there anyway I can generate a table that will show only the rooms that are in use and the persons name who is using it?
    Reply With QuoteRegister To Reply
  2. 09-23-2015, 01:43 AM #2
    JBeaucaire
    JBeaucaire is offline
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Create a Table from two separate excel sheets/ tables

    Pretty much anything you can logically imagine as related information in your head can be associated into tables and summaries and consolidations in Excel. If the data is there and there is a common thread, it can usually be done.

    TO help us help you, devise a sample workbook that demonstrates fully the entire scenario you're describing. Sounds like 3 sheets? Anyway, mockup a full set of data that demonstrates all the hurdles and variations in the data, and manually mockup the results you'd like to automate in your results sheet.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)
    Reply With QuoteRegister To Reply
  3. 09-23-2015, 02:43 AM #3
    Timberjeremy
    Timberjeremy is offline
    Registered User
    Join Date
    09-17-2015
    Location
    USA
    MS-Off Ver
    Not sure
    Posts
    10

    Re: Create a Table from two separate excel sheets/ tables

    I am looking for a table to be displayed in sheet 3 that diplays all the numbers that have an "X" next to them from sheet 1, with only the names and login date from sheet 2. I hope that makes sense
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  4. 09-23-2015, 01:50 PM #4
    Timberjeremy
    Timberjeremy is offline
    Registered User
    Join Date
    09-17-2015
    Location
    USA
    MS-Off Ver
    Not sure
    Posts
    10

    Re: Create a Table from two separate excel sheets/ tables

    Can anybody please help me out with this? I would be greatly appreciative
    Reply With QuoteRegister To Reply
  5. 09-23-2015, 03:33 PM #5
    JBeaucaire
    JBeaucaire is offline
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Create a Table from two separate excel sheets/ tables

    With the addition of a reformatted helper table on Sheet1 to put the data all in one standard table, not too difficult. As you edit the "X" entries in your original table it will update the helper section.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  6. 09-24-2015, 12:10 AM #6
    Timberjeremy
    Timberjeremy is offline
    Registered User
    Join Date
    09-17-2015
    Location
    USA
    MS-Off Ver
    Not sure
    Posts
    10

    Re: Create a Table from two separate excel sheets/ tables

    Quote Originally Posted by JBeaucaire View Post
    With the addition of a reformatted helper table on Sheet1 to put the data all in one standard table, not too difficult. As you edit the "X" entries in your original table it will update the helper section.
    Wow, I cannot thank you enough for putting this together for me!!! It seems to be working great. I am going to try to use this with the actual workbook I am using and will let you know how it goes! So far I think this is really going to help me out and save me TONS of time. Would you so kind and willing to help me out a little bit more if needed? At the moment I think I am only going to need to input one more column on sheet 2 and also have it generated on sheet 3
    Last edited by Timberjeremy; 09-24-2015 at 12:52 AM.
    Reply With QuoteRegister To Reply
  7. 09-24-2015, 09:57 AM #7
    JBeaucaire
    JBeaucaire is offline
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Create a Table from two separate excel sheets/ tables

    I think the technique demonstrated would work on any number of sheet2 columns. The Formulas in sheet3 see to that. Column A uses an INDEX/MATCH to pull in the room numbers with "x"s, then the rest of the columns use standard VLOOKUP formulas. You can add as many VLOOKUPs as you need for the columns on sheet2.

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
    Reply With QuoteRegister To Reply
  8. 09-24-2015, 02:09 PM #8
    Timberjeremy
    Timberjeremy is offline
    Registered User
    Join Date
    09-17-2015
    Location
    USA
    MS-Off Ver
    Not sure
    Posts
    10

    Re: Create a Table from two separate excel sheets/ tables

    Ok I think I have figured it out! Thanks for all the help!
    Last edited by Timberjeremy; 09-25-2015 at 12:16 AM.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Tables on separate sheets. Want to Display All Data in one Table
    By NoExcelSkills17 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-20-2015, 06:06 PM
  2. [SOLVED] Create separate tables for each category from a master table
    By AceCo55 in forum Excel General
    Replies: 9
    Last Post: 08-29-2015, 04:14 PM
  3. [SOLVED] Macro needed to Concatenate data in 2 separate tables of 2 separate sheets
    By 823 in forum Excel Programming / VBA / Macros
    Replies: 22
    Last Post: 02-08-2015, 02:02 PM
  4. [SOLVED] Create continuous non blank table based on merge of separate dynamically filled tables
    By escobf in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-15-2013, 04:15 PM
  5. Link two tables on two separate sheets
    By doubled191 in forum Excel General
    Replies: 1
    Last Post: 04-07-2013, 08:15 AM
  6. Loop through excel data to create separate tables in one word document
    By walhallamar in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-15-2012, 10:20 AM
  7. Macro - Create smaller word tables from master excel table
    By VBA_n00b in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-22-2011, 10:12 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1