Initially I had only 500 row entries for which I recorded the macro as per the following.1.  Filter Column C Revision with blanks2.  Filter Column E INITIAL PLAN SUBMITTAL DATE, the cut-off date is every week that is every week Friday Ex 4th Sep, 11th Sep, 18th Sep, 25th Sep3.  After running the Macro with the cut-off date as 30th Sep, got the count as 1264.  As the number assigned for this activity is, updated “6” in the Column A for the 126 docs, which is the resultNow with the latest report, the number of rows have increased to 2809.However, when I run the Macro again, it takes into account only 500 rows.How to get the count for the total 2809 rows.

​Initially I had only 500 row entries for which I recorded the macro as per the following.1.  Filter Column C Revision with blanks2.  Filter Column E INITIAL PLAN SUBMITTAL DATE, the cut-off date is every week that is every week Friday Ex 4th Sep, 11th Sep, 18th Sep, 25th Sep3.  After running the Macro with the cut-off date as 30th Sep, got the count as 1264.  As the number assigned for this activity is, updated “6” in the Column A for the 126 docs, which is the resultNow with the latest report, the number of rows have increased to 2809.However, when I run the Macro again, it takes into account only 500 rows.How to get the count for the total 2809 rows.  Read More

​