Populating table in excel based on selection in drop down

[gshadz37]

Hi,
In Excel 2002, I need to populate data in a table based on which month a user chooses in a drop down menu. This will all be contained in one workbook, with the data that's being populated being provided by the worksheets behind this summary one I'm trying to create.

I hope this makes sense. Any help is greatly appreciated.

 

[SkipVought]

Hi,

I'm confused. Usually a SUMMARY is made from the DETAIL table.

Are you not entering data into the DETAIL table?

Skip,

_[red][/red]

 

[gshadz37]

Yes, I am. Sorry for not being clearer. I'm entering data in the detail tables for each month. I want a table that will pull totals of the data I'm entering - if I chose June then Jun's data will populate the summar table.

 

[SkipVought]

Have you checked out the PivotTable wizard? A report like this can be done in about 15 seconds or less.

Skip,

_[red][/red]

 

[SkipVought]

Or...

Use the AutoFilter to select a date range.

Skip,

_[red][/red]