Copying of consecutive Rows and pasting it in a different location

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

shriil - 29 Jan 2008 17:38 GMT

Hi

I have 20 consecutive rows each having 12 values in 12 consecutive
columns in each row. Now i want to write a procedure where I shall be
copying each row and pasting it on a different row. one at a time.
After the procedure has run thru all the 20 rows, it stops.

For Ex. If I have the following Values, such as

Row 1: 4 30 45 23 34 48....... (20 columns)
Row 2: .......... (20 columns)
.......
Row 20: ................(20 columns)

The procedure shall first copy entire Row 1 and paste it in Row 50
Then copy entire Row 2 and paste it in
Row 51
Then Copy entire Row 3 and paste it in
Row 52
... and so on and so forth until Row 20 is pasted.

Pls Help

Reply to this Message

Pete_UK - 29 Jan 2008 17:45 GMT

I think your description is a bit muddled - you talk about 12 columns,
but then in your example you cite 20 columns.

Is there a particular reason why you want to copy/paste one row at a
time?

All you need to do is click on the row identifier for row 1, hold down
the <shift> key and click on the row identifier for row 20, then
release <shift> - this will have highlighted all 20 rows.

Click <copy>, then click in cell A51 and press <enter> - all 20 rows
will have been copied in one operation.

Hope this helps.

Pete

> Hi
>
[quoted text clipped - 18 lines]
>
> Pls Help

Reply to this Message

shriil - 30 Jan 2008 06:28 GMT

> I think your description is a bit muddled - you talk about 12 columns,
> but then in your example you cite 20 columns.
[quoted text clipped - 37 lines]
>
> - Show quoted text -

Sorry. I made a mistake. Each row has 12 columns and not 20 columns. I
am aware of the method you have described. What I want is how to write
a procedure in the VB Editor such that the following operation
(detailed below) can be done at one go.

Say I have data in each of 12 columns of 20 Consecutive Rows. Ex. From
Rows 23 to 42, Columns D to O
Additionally I have data in Row 7, Column D to O.

Now I have to Copy each of the 20 Rows, one at a time, and paste it in
Row 8, Column D to O. The First operation occurs when Row 23 is
selected, copied and pasted on Row 8. Based upon the data pasted in
Row 8 along with that already resident in Row 7, a calculated value is
generated in Row 8, Column P (P8). The value in Cell (P8) is copied
and pasted in Row 9 Column A,i.e., Cell (A9).

In the second operation, Row 24 is selected, copied and pasted on Row
8. Based upon the changed data in Row 8, along with that resident in
Row 7, a calculated value is again generated in Row 8 Column P (P8).
Subsequently the new value in Cell (P8) is copied and pasted in Row 9
Column B,i.e., Cell (B9).

So for each of the 20 Rows pasted at the same location of Row 8, I
shall generate 20 calculated values that would be available from (A9)
to (T9). Depending upon the highest value among these cells, the Row
that was responsible for the same (i.e. one of the Rows between Rows
23 to 42), shall be permanently copied and pasted in Row 8 location.

I hope I have been able to explain it clearly. What I understand that
I have to write the code with a few Do.. While statements, but cannot
fathom how to denote which particular Row to be copied and pasted and
how to increment by one row at a time for the "Copy & Paste"
operation.

Pls Help

Reply to this Message