Prev: Discontinous values in a column
Next: Unhide a column among columns.
From: PAULGOR via OfficeKB.com on 24 Dec 2009 07:59
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.aspx/ms-excel/200912/1

From: PAULGOR via OfficeKB.com on 24 Dec 2009 10:38
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

 | 
Pages: 1
Prev: Discontinous values in a column
Next: Unhide a column among columns.