D
desertSol
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!
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!