Hi. I have a scenario that I would like to accomplish but need help from people who know a lot of Macro or VBA.


Sheet1:
A1:A300 (not consistent)
1 - I would like to have a macro that will copy 10 cells at a time from Sheet1 to Sheet2 (A1:B10)
2 - Then once transferred, Sheet2 is automatically printed
3 - Then once printed, copy the other 10 cells (this time it would be A11:A20 to Sheet2 (A1:B10)
4 - repeat step 1 to 3 until everything is printed out. Now as mentioned above, A1:A300 is not consistent, it could be A1:A20 or A1:A799, etc.

Summary: I would like to print all info in Sheet1 using the format in Sheet2 - that is 10 values at a time. Thank you.