Copy data contained in several columns into a new column

**patka1** · 04-09-2011, 10:09 PM

Hello,

I am attaching a sample spreadsheet to show what I am trying to do. The first worksheet shows the cells that need to be copied and the second worksheet shows how I would like them to look in the end. All the cells that need to be copied start with the same sequence of letters, unique just to the cells that need to be moved, but they are followed with various numbers.

Is there some formula that could be used to automate the task? The spreadsheet I have is just a simplified example. The actual spreadsheet has a lot more rows and columns. Thanks for help in advance!

**MarvinP** · 04-09-2011, 10:56 PM

Hi patka and welcome to the forum,

Here is the code that does what you ask for and the attached to show it works.

Please Login or Register  to view this content.

**Charlie_Howell** · 04-10-2011, 11:30 AM

If you prefer the original cells to stay populated remove this part of the code:

Cells(RowCtr, ColCtr).ClearContents

**martindwilson** · 04-10-2011, 12:59 PM

or use in g2
=INDEX(A2:F2,MATCH("ms*",A2:F2,0))

**patka1** · 04-10-2011, 08:56 PM

Thank you all for posting replies. They are all helpful and I will use your suggestions, thank you so much!

Copy data contained in several columns into a new column

LinkBack

Thread Tools

Rate This Thread

Display

Copy data contained in several columns into a new column

Re: Copy data contained in several columns into a new column

Re: Copy data contained in several columns into a new column

Re: Copy data contained in several columns into a new column

Re: Copy data contained in several columns into a new column

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions