Consolidating a Row of data from many worksheets
Good morning,
I have a large number of worksheets in one workbook. Each worksheet has the same format, with similar types of data in each cell. The cells I am interested in look like this...
C2 D2 E2
Complete 1.1 Enterprise Support
The cell structure in each worksheet is the same, and the data in C2 is limited through a data validation to only 4 options...Complete, In Progress, Major Issue, and Planning.
What I am trying to do is consolidate all of this information so I can look at the number in D2 and the name that goes with it in E2, for all of the 'completes', 'in progresses', 'major issues', and 'enterprise supports'.
I've been struggling with this for the last few days and have run through my bag of excel tricks (admittedly not too full to begin with).
Thanks in advance for any help,
Casey
|