I had seen an excel sheet performing automatic print on a label. I would like to create one but no idea how to start using macro or VBA.

1. 8.5" x 11" sheet of with ten 4" x 2" size labels
2. Sheet1-A1:A300 - 10 values at a time are automatically copied to Sheet2 from A1:B10 (cells are formatted already to print on labels)
3. The printing will stop only if all values in Sheet1, A1:A300 are all printed out.

Thank you in advance.