Multiple projects on one sheet

Carol Key

We have several large projects that require their own sheets.   However, we also have many small projects that do not justify creating separate sheets.   They are quick one or two day jobs, but they affect scheduling and P&L need to be factored into that.     Does anyone out there use one sheet for multiple small projects?   And if you do, how do you get the data from them (budget, start/end date, etc) into reports and such?   

Sean

One method we use is to have a default value in a hidden column that allows you to only report on specific rows accross multiple sheets. you can then narrow the report query paramaters using your date or resource fields.

J. Craig Williams

Carol,

 

I think Sean's answer is the way to go.

I used project codes in a column. I don't bother to hide them, usually.

 

Did you get what you needed?

 

Craig