Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert rows without copying borders and shading | Excel Programming | |||
after selecting 50 rows of a column i can't reference the cells in the rows | New Users to Excel | |||
how insert same text in empty cells in column (10000 rows) | Excel Worksheet Functions | |||
Same formula in each cell of column; insert rows w/o copying down | Excel Discussion (Misc queries) | |||
Searching a column and copying rows | Excel Worksheet Functions |