insert rows and copying cells in column b,c, and d into new rows

G

gbpg

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)
 
G

gbpg

joel said:
Can you post the before and aft data?


--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread: http://www.thecodecage.com/forumz/showthread.php?t=165481

Microsoft Office Help

.
I am not sure what you mean by before and after? What I have now is four columns that have the subject in the first row and column A and then text in columns b,c, and d in rows 1 to 5. I want all of the information in the same column. To do this I need to cut the information (text) in columns b,c,d into rows in column A. I am doing this so I can convert to a text file and import into Access 97 which does not import .xls files.
Click to expand...
 
J

joel

Where do you want to copy the data (in the middle or end of data) an
how many times do you want to repeat the process
 
G

gbpg

gbpg said:
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)
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Move data from first 7 rows from one column A into multiple Columnsthen the next 7 rows 2
Comparing numbers 1
Inserting and copying Rows based on a variable 2
copying to new workbook 0
insert new row every day. 2
Strip out certain rows that have merged cells 2
VBA CreateNames (ignores last 5 rows?) 6
InputBox for column letter problem 2

Top