Automate copy / paste
 

Good day ,
I am asking for help with the following matter please.

I need to copy a single row on an XL database worksheet, and paste to another
workbook/worksheet.
In the 2nd workbook/worksheet ,I would like the 1st pasting to be entered in
a certain row , and each following pasting to be 1 row higher than the
previous paste.

Can this be done automatically?

I am almost new to FORUMS and my XL database experience is not exactly great.

THX
Paul

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200912/1

Automate copy / paste
 

PAULGOR wrote:
Good day ,
I am asking for help with the following matter please.

I need to copy a single row on an XL database worksheet, and paste to another
workbook/worksheet.
In the 2nd workbook/worksheet ,I would like the 1st pasting to be entered in
a certain row , and each following pasting to be 1 row higher than the
previous paste.

Can this be done automatically?

I am almost new to FORUMS and my XL database experience is not exactly great.

THX
Paul

.HI Paul again, here is some more info to assist.

I need to copy from a workbook named A1.XLS , and cells to copy are in row D7:
L7 ,
This row will always be the row to be copied .ie remains a
static row.

I need to paste to a workbook named A2.XLS , and paste into row D1:L1
initially, an after
that into row D2:L2 , then D3:L3 , then D4:L4 then forever more where the
row number
increases by one

Hope this will help , and everyone "ENJOY YOUR FESTIVE
SEASON"

My Regards

Paul

--
Message posted via http://www.officekb.com