Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy/Paste
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 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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy/Paste
Myrna
Many thanks Robert In message , Myrna Larson writes 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 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't Copy and Paste or Paste Special between Excel Workbooks | Excel Discussion (Misc queries) | |||
Copy, paste without file name referenced after paste | Excel Discussion (Misc queries) | |||
Copy; Paste; Paste Special are disabled | Excel Discussion (Misc queries) | |||
Excel cut/Paste Problem: Year changes after data is copy and paste | Excel Discussion (Misc queries) | |||
Macro to Copy/Paste then Paste to Next Line | Excel Programming |