Stupid Excel Question

Sub la Goon · 03-24-2007, 06:54 PM

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!

Alex · 03-24-2007, 11:57 PM

Yes, pivot table is best. But if a solid answer hasn't come by Monday and I remember I'll post detailed instructions (I don't have Excel at home).

Kevy Baby · 03-25-2007, 08:20 PM

Quote:

Originally Posted by Sub la Goon

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!

Never heard of a pivot table, but I'll look into it.

Thankfully, I don't need to do this for another couple of weeks.

03-24-2007, 06:54 PM	#1
Sub la Goon Ride me! Join Date: Jul 2006 Location: The line forms here... Posts: 326	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.
	Submit to Quotes

03-24-2007, 11:57 PM	#2
Alex . Join Date: Feb 2005 Posts: 13,354	Yes, pivot table is best. But if a solid answer hasn't come by Monday and I remember I'll post detailed instructions (I don't have Excel at home).
	Submit to Quotes