Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 58
Default insert rows and copying cells in column b,c, and d into new rows



"gbpg" wrote:

I currently have a spreadsheet that contains many rows of information
exported from another application. In column a I have the same rows repeated
through out which are five rows; starting at row 1 and ending at row 6,
repeated at row 7 and ending at row 12. In column B I have data relating to
the title in column A ,in colum C I have the title for the the data in D.

Essentially what I need to do is the following:

1) copy the data in in column b every sixth row and pasting into the fifth
row
paste the data from the the second row colum c and d into column a and b
into now blank row six (repeated every sixth row through out)
- insert 3 rows after every 6th row and then:
paste the data from the third, fourth, and fifth rows columns c and d into
column a and b of rows seven, eight, and nine (repeated through out)

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Insert rows without copying borders and shading XP Excel Programming 6 July 21st 08 09:53 AM
after selecting 50 rows of a column i can't reference the cells in the rows Bob Salzer New Users to Excel 2 July 21st 06 10:29 PM
how insert same text in empty cells in column (10000 rows) bromptongadgets Excel Worksheet Functions 1 December 11th 05 04:13 PM
Same formula in each cell of column; insert rows w/o copying down tgdavis Excel Discussion (Misc queries) 3 September 14th 05 09:32 PM
Searching a column and copying rows davidshin Excel Worksheet Functions 1 November 10th 04 08:29 PM


All times are GMT +1. The time now is 08:18 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"