Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
Sharing data across worksheets within a workbook based on identifi | Excel Discussion (Misc queries) | |||
sharing rows of data across multiple worksheets within a workbook | Excel Worksheet Functions | |||
Putting data from multiple worksheets into one | Excel Discussion (Misc queries) | |||
Sort pages? | Excel Discussion (Misc queries) |