macro help = extract content of specific columns accross a row

G

garyusenet

have a spreadsheet which consists of about 5125 rows and 2840
columns. I am using Excel 2007 in order to get access to the extra
columns. Now I need help creating a macro to automate a very tedius and

manual task. The first column in the spreadsheet is empty.

What I Need
===========
For every row I would like to extract the contents of certain columns
accross the row and copy to the first column of the row.


into the first column i would like to copy the contents of the
following columns accross the row. 6C = sixth column, 9C = 9th column
etc...


6C + " " + 7C + " " + 9C + " " + 35C + " " + 37C +
<carriage return>
+ 12C + " " + 14C + " " + 18C + " " + 70C + " " + 74C +
<carriage return>
etc...


I need the macro to be smart enough to continue adding carriage returns

and multiplies of the original columns, until it reaches the end of the

row.


I need to do this for every row.


Any advice please or code would be greatly appreciated.
 

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

macro help - extra contents of specific columns accross a row 2
Delete Columns Macro 11
Automatically Combine Cell Contents and Delete Rows 0
copy contents of multiple cells into a new cell - Help Needed Please 1
macro for deleting specific columns & rows. Help. Please. No Clue. 5
help needed extracting data accross the row into the first cell of the row 2
Macro for removing specific rows and columns, freezing panes..? 3
Help needed with macro: Writing contents of two cells to two new columns 0

Top