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
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