Thread: Stupid Excel Question
View Single Post
Old 03-24-2007, 06:54 PM   #1
Sub la Goon
Ride me!
 
Sub la Goon's Avatar
 
Join Date: Jul 2006
Location: The line forms here...
Posts: 326
Sub la Goon is the most, man, the mostSub la Goon is the most, man, the mostSub la Goon is the most, man, the mostSub la Goon is the most, man, the mostSub la Goon is the most, man, the mostSub la Goon is the most, man, the mostSub la Goon is the most, man, the mostSub la Goon is the most, man, the mostSub la Goon is the most, man, the mostSub la Goon is the most, man, the mostSub la Goon is the most, man, the most
Two words: Pivot Table.

After you do one, you can save your pivot table program on a spreadsheet and copy that sheet into the next workbook with your data. Then right click the table, choose Pivot Table Wizard, and select your data range from the data sheet.

They can be tricky to start with but lots of fun!
__________________
You roll the dice, you move your mice.
Sub la Goon is offline   Submit to Quotes Reply With Quote