X
xlsuser42
I have an excel spreadsheet, which I call the 'master' wit
approximately 200 worksheets. Each worksheet is linked to it's ow
excel file, so that when each file is updated, these updates are show
in the 'master.' Together, these make up a list of projects. In cel
C2 is the status (such as Complete, In Progress...), D2 is the trackin
number for the project (1.1, 1.1.1, 2.1, 2.1.1...) and in cell E2 is th
name of the project (just text). I need a way to group these three set
of data together, grouped by status. Therefore, I am looking for a lis
of all of the completes, with the name and number, all of the i
progresses with the name and number, etc. Also, this list needs to b
updated each time the file is opened.
I think that the solution would be similar to a filter, but the proble
is that the data is spread out over 200 worksheets.
Thanks for any help or responses
approximately 200 worksheets. Each worksheet is linked to it's ow
excel file, so that when each file is updated, these updates are show
in the 'master.' Together, these make up a list of projects. In cel
C2 is the status (such as Complete, In Progress...), D2 is the trackin
number for the project (1.1, 1.1.1, 2.1, 2.1.1...) and in cell E2 is th
name of the project (just text). I need a way to group these three set
of data together, grouped by status. Therefore, I am looking for a lis
of all of the completes, with the name and number, all of the i
progresses with the name and number, etc. Also, this list needs to b
updated each time the file is opened.
I think that the solution would be similar to a filter, but the proble
is that the data is spread out over 200 worksheets.
Thanks for any help or responses