The information below would be on worksheet named €œSheet1€�
A B C
Cust id Product code Amount

1 10006 RFUUK 2000.00
2 10010 RFUUK 2000.00
3 10030 RFUOS 3000.00


I need help to write a macro to carry out the following actions,

1. I would like to have the information for each row on a specific position
(e.g. A1, A12 and C12) on another worksheet (e.g. named €œSheet2€�) then print
that page.

2. Repeat the above cycle for the each row for the list on €œSheet1€�.

Thanks. Any help appreciated.