Hello everyone,
I would greatly appreciate assistance in developing a macro to assist in my monthly reporting.
Within my yearly report, each month I create a report off of my previous month report. For example, my current report includes Jan-09 & Feb-09 data. Next week I will be adding Mar-09 data to this report in the empty rows below where Feb-09 ended. I guess you can consider this as a this a cumulative report as 12 months of data (Jan-09 - Dec-09) will eventually reside within this file.
Here is my problem, I need to distribute this report to several departments within the corporation I work for, and they are only interested in receiving the current month within the report. Thus, next week when I update this report they would only expect to receive Mar-09 data.
As a result, each month I manually delete rows containing prior month's data; next week I will manually delete rows containing Jan-09 & Feb-09 data. This may not seem like a problem, but the number of rows pertaining to each month can exceed 3,000 rows. Also, I have at least six tabs that require this exercise so as you can imagine, this task can become very tedious. Lastly, I'm usually forced to delete these rows in groups of 500 since my Excel freezes due to the formulas within each row.
Here is my goal; I would like to develop a Macro that would allow me to choose the months of data that require deletion. In this case, I would command the Macro to delete rows that have Jan-09 & Feb-09 in Column A (the reporting month will always be included in Column A as illustrated below).
Since I need this macro to run across several tabs, I would like to have the option to select the tabs that require this Macro to be executed within the file.
I'm hoping this request makes sense. Please allow me to clarify if I'm confusing you.
Best Regards,
Mark9988
I would greatly appreciate assistance in developing a macro to assist in my monthly reporting.
Within my yearly report, each month I create a report off of my previous month report. For example, my current report includes Jan-09 & Feb-09 data. Next week I will be adding Mar-09 data to this report in the empty rows below where Feb-09 ended. I guess you can consider this as a this a cumulative report as 12 months of data (Jan-09 - Dec-09) will eventually reside within this file.
Here is my problem, I need to distribute this report to several departments within the corporation I work for, and they are only interested in receiving the current month within the report. Thus, next week when I update this report they would only expect to receive Mar-09 data.
As a result, each month I manually delete rows containing prior month's data; next week I will manually delete rows containing Jan-09 & Feb-09 data. This may not seem like a problem, but the number of rows pertaining to each month can exceed 3,000 rows. Also, I have at least six tabs that require this exercise so as you can imagine, this task can become very tedious. Lastly, I'm usually forced to delete these rows in groups of 500 since my Excel freezes due to the formulas within each row.
Here is my goal; I would like to develop a Macro that would allow me to choose the months of data that require deletion. In this case, I would command the Macro to delete rows that have Jan-09 & Feb-09 in Column A (the reporting month will always be included in Column A as illustrated below).
Since I need this macro to run across several tabs, I would like to have the option to select the tabs that require this Macro to be executed within the file.
I'm hoping this request makes sense. Please allow me to clarify if I'm confusing you.
Best Regards,
Mark9988
example.xls | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | M | |||
1 | Reporting Month | Customer Name | Account Number #1 | Account Number #2 | Remaining Term | Calendar Month End Date | Rental Payment | Payment Remit Date | Payments Past Due | Status Code | Last Post Date | Next Due Date | Current Balance | ||
2 | Jan-09 | Customer - xyx | |||||||||||||
3 | Jan-09 | Customer - abc | |||||||||||||
4 | Jan-09 | Customer - dfh | |||||||||||||
5 | Jan-09 | Customer - elk | |||||||||||||
6 | Jan-09 | Customer - qor | |||||||||||||
7 | Jan-09 | Customer - vnb | |||||||||||||
8 | Jan-09 | Customer - lkj | |||||||||||||
9 | Feb-09 | Customer - poi | |||||||||||||
10 | Feb-09 | Customer - zxc | |||||||||||||
11 | Feb-09 | Customer - aer | |||||||||||||
12 | Mar-09 | Customer - mne | |||||||||||||
13 | Mar-09 | Customer - uyt | |||||||||||||
14 | Mar-09 | Customer - qwp | |||||||||||||
15 | Mar-09 | Customer - asl | |||||||||||||
Rentals |