Macro
Hi
I cannot view your reply.
"JLatham" wrote:
"nc" wrote:
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.
|