Good day,
I would like to create a macro to count the number of rows based on the user input. And based on the count result, trigger the print function to print the corresponding number of pages.
For example, I have a table below in Sheet 1 and some other information in Sheet 2. When I input "Apple" into a input box in Sheet 2, the macro will count the number of occurrences for Apple and return the result as 3. So, with this result of 3, a print function is trigger to print 3 pages of the same data in Sheet 2.
To summarize, the number of pages to be printed is based on the result of the count.
Apple Orange Mango Apple Apple Mango
Appreciate advice from anyone on this.
Thanks in advance for the help.
Best regards,
wliang
Bookmarks