Autofill with variable number of rows
I am trying to automate a monthly report where the final autofill is based
on variable number of rows that change monthly with the change in # of
clients. For example: if this month I have 25 clients, I could easily
hardcode that I want to create 25 rows of my report. But in the next month
when I have 30 clients, my code still would say 25 and therefore would
miss five clients.
If anyone has any insight that would be very helpful as I feel like there
should be a way to accomplish this that I am just completely missing on my
own.
Thanks.
No comments:
Post a Comment