Creating Monthly Reports from Excel data

dep825

New Member
Joined
Mar 13, 2003
Messages
16
I have 3,500 rows (and growing) 25 columns of Excel data...basically a flat file database...I need to get monthly reports filtered, sorted, subtotaled, and totaled various ways. These reports are the same each month...but of course the month is different each month so it pulls only the data for that month.

Right now, I use filter, then copy/paste, then sort, then sort again & again and subtotal again & again to get the various reports I need. Very tedious.

Is there any report writer that would alow me to create the report formats, give the reports a name, then each month, enter the month as a variable and have the report pull all the data, sorted, subtotaled and totaled into each report......I guess I could create a macro for each report but there are MANY steps to create each report each month. I would there might be a more simple approach. Thanks
 

Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)

eliW

Well-known Member
Joined
Mar 2, 2002
Messages
1,931
Hi dep,

All you need can be done with pivot tables!

If you want -send a sample of your data and i'll try to show you how.

Eli
 

dep825

New Member
Joined
Mar 13, 2003
Messages
16
Thanks...I'll make an effort to dig into pivot tables again...could never get it to work nor understand it...but will try again..thanks
 

Watch MrExcel Video

Forum statistics

Threads
1,133,658
Messages
5,660,156
Members
418,555
Latest member
Ike Andoit

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top