Count Rows Based On User Input & Trigger Print Of Pages Out Of Count Result

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

Hi Ace_XL,
Thanks for your help.

Best regards,
wliang