Re: Copy/Paste
From: Myrna Larson (anonymous_at_discussions.microsoft.com)
Date: 10/31/04
- Next message: JLWCFM: "Does anyone have a template for using Excel as a simple Construct."
- Previous message: Steven Deng: "Are there ways to clear the intermediate windows automatically?"
- In reply to: Robert: "Copy/Paste"
- Messages sorted by: [ date ] [ thread ]
Date: Sat, 30 Oct 2004 20:07:47 -0500
Turn on the macro recorder and insert the rows. Then modify the code to
determine the criteria for the number of rows to insert. BTW, this sort of
thing is best done by processing the rows from the bottom up. If you do it
from the top down, after inserting, say, 3 rows at row 5, what was row 6 is
now row 9, which causes havoc with For/Next loops.
On Sat, 30 Oct 2004 13:50:54 +0100, Robert <robert@rlh1.com> wrote:
>I have 1500 rows of data in columns A:S
>There is always data in columns A:K, the incidence of entries in L:S
>varies.
>When, for example, there is an entry in column L, row 5, I want to
>insert a row immediately after row 5, copy A5:J5 to A6:J6 and copy the
>entry in L5 to K6.
>When there are entries in columns L,M,N etc, I want to insert the
>corresponding number of rows and repeat the above copy/paste routine
>accordingly.
>Grateful for any advice.
- Next message: JLWCFM: "Does anyone have a template for using Excel as a simple Construct."
- Previous message: Steven Deng: "Are there ways to clear the intermediate windows automatically?"
- In reply to: Robert: "Copy/Paste"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
