If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Create List sourced from Multiple sheets of varying lengths
Hello,
I'm new here, and only recently began using Excel as it's intended. I'm really excited to be digging into it, and enjoy solving my dilemnas, but this one has me stumped. And I know I am overlooking something obvious! Any help is greatly appreciated. Here's how my challenge: I have a "test system workbook" that has a sheet for each tester on a project. The tester sheet includes a cell for the person's name and a cell for location, and a 4 column table that each tester fills with their test system(s) info; "ID number," "System Name," "WIKI HyperLink," and "Status" The number of systems any tester uses varies dramatically. On Sheet 1, I'm needing to compile a "master list" of the rows of IDs, System Names, WIKI Links, and Status from the tables across all sheets, while adding the correct Tester Name and location from the sheet that the systems are drawn from. The master list needs to be dynamic, so that if the Tester on Sheet 3 adds a new system to his table, the master list is updated to include the info. I can do it statically, using references to ranges across the sheets, etc. But I really need it to be dynamic, and I don't feel like it should be so difficult. Please! Help me overcome my ignorance. Thanks in advance! |
Thread Tools | |
Display Modes | |
|
|