Looking for a way to create a dynamic macro that will expand the function of said macro across a varying number of rows.
For example, today I may have 100 rows of data to run the macro on, but tomorrow it may be 1000 rows. How can I edit this macro so that it accounts for the total number of rows each and every time?
Bookmarks