| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using Excel data for report headings
I have created a list in a spreadsheet with projects listed in rows and
various details relating to the project in the other columns. One of these details is " Current Project Stage". My challenge is to create a summary table in another sheet that shows my 5 Project stages in columns and then corresponding project names listed in rows. This way I have a nice visual report of what is in stage 1, what is in stage 2, etc... The trick is getting the project names listed. Through Pivot, I could only get sum, count, etc. per stage. Any help would be great! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| data entry in excel by linking to other word doc. or excel sheets | Excel Worksheet Functions | |||
| Retrieve data from separate Excel session | Charts and Charting in Excel | |||
| Inserting a new line when external data changes | Excel Discussion (Misc queries) | |||
| Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Linear Mode
