Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting rows of data of varying lengths | Excel Discussion (Misc queries) | |||
Economical grouping of lengths out of much longer lengths | Excel Worksheet Functions | |||
Create a summary list using same fields from multiple sheets | Excel Discussion (Misc queries) | |||
Multiple Sheets (Need to create 500 individual sheets in one workbook, pulling DATA | Excel Worksheet Functions | |||
How do i auto create multiple files from 1 with multiple sheets | Excel Worksheet Functions |