Hello,

I want to create a button macro to perform a routine coping, here is my
worksheet:

Worksheet P
A B C D
1
2
3
Worksheet Q
A B C D
1 1
2 2
3 3
4 4
5 5
6 6
..
..
Worksheet P 's range (A1..D3) to be copied is already fixed because this is
a patron ( containing formula)
Worksheet Q is the p.o line, could go down for thousand of line, but the
clerck is alaredy asked to have filled column A for (line nomber)

My question is how can we create a macro, to copy A1.D3 ( in another
workbook) to Purchase Order workbook for sheet P.O Sheet to line
B1...D.(variable)(could go down to many lines)

A1....down could be used to Cursor End. down, but I do not need to copy to
column A in worksheet Q, It should start from Column B in worksheet Q.

I appreciate for any idea provided.

--
H. Frank Situmorang