Forum Discussion
Recorded Macros Need To Be Updated With New Rows Added
| Initially I had only 500 row entries for which I recorded the macro as per the following. |
| 1. Filter Column C Revision with blanks |
| 2. 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 Sep |
| 3. After running the Macro with the cut-off date as 30th Sep, got the count as 126 |
| 4. As the number assigned for this activity is, updated "6" in the Column A for the 126 docs, which is the result |
| Now 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. |
9 Replies
- I have given the access - please check - thanks
- The file location is provided in the below link for a quick solution.
https://drive.google.com/file/d/1p9y9g688PMSbUTcGGTcw2hkL2counHcM/view?usp=drive_link You might copy the code of the macro into a reply.
Or create a stripped-down copy of the workbook demonstrating the problem (without sensitive information) and make it available through one of the websites that let you upload and share a file, such as OneDrive, Google Drive, FileDropper or DropBox. Then post a link to the uploaded and shared file here.
- Appreciate and many thanks for your guidance. As required the file is provided in the below link https://drive.google.com/file/d/1p9y9g688PMSbUTcGGTcw2hkL2counHcM/view?usp=drive_link
