excel 2007 selecting data from multiple worksheets?

[cjbrown815]

Hello,(Excel 2007)
I have to create a bar chart that shows time allocation from the begining of the year. Vacation, Holiday, Training, Troubleshooting...
The workbook has a worksheet for each month. How do I select data for all vacation hours for all worksheets and summarize so I can chart it?


thanks

-CJ

SQL2005// CRXIr2// XP Pro

"Progress lies not in enhancing what is, but in advancing toward what will be"
-KHALIL GIBRAN 1883-1931

 

[xlhelp]

Look up Consolidation under Help. Hopefully all your worksheets are the same format.

A man has only two choices: He can be right or he can be happy.

 

[SkipVought]

The workbook has a worksheet for each month[/code]

You do realize that this kind of workbook structure is like tying one hand behind your back & shooting yourself in the foot.

It would be prudent to COMBINE all your monthly data into ONE TABLE on ONE SHEET.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[cjbrown815]

Thanks, the help menu isn't very specific. It say I need to set up my data in a list before I can consolidate it, OK, how do I set up my list of data from multiple worksheets?

-CJ

SQL2005// CRXIr2// XP Pro

"Progress lies not in enhancing what is, but in advancing toward what will be"
-KHALIL GIBRAN 1883-1931

 

[cjbrown815]

Skip, I didnt create a workbook. I now have to create a worksheet that will have a summary of each row total and then create a pie chart

-CJ

SQL2005// CRXIr2// XP Pro

"Progress lies not in enhancing what is, but in advancing toward what will be"
-KHALIL GIBRAN 1883-1931