Columns match based on headline

**jmaocubo** · 08-04-2009, 06:06 AM

Hi

I have a workbook and in sheet1 I will copy an export from another program. The rows 1 and 2 are the headline.
The problem is that the order of the headline is random, so I create the sheet2 with the correct headline. I need that excel match column based on the title (in the headline) in sheet1 and copy to the column in the sheet2 with the same name. It must analyze the two sheets because at any moment the headline master may change based on the type of project.
My English is not so good

sorry.

I hope you guys can help me…. Thank you

**jmaocubo** · 08-04-2009, 04:19 PM

anyone???????

**StephenR** · 08-04-2009, 04:45 PM

Not entirely sure what you are asking. Can you attach a workbook with a sample of your data and the results you want?

**jmaocubo** · 08-05-2009, 05:08 AM

thanks for the reply...

here is the example

**StephenR** · 08-05-2009, 06:42 AM

Why not a formula in Sheet2 A3 and copied across and down as far as necessary? The ranges will need adjusting. I guess you could do this with code.

=INDEX(sheet1!$A$3:$L$15,ROWS(A$3:A3),MATCH(A$2,sheet1!$A$2:$K$2,0))

**jmaocubo** · 08-05-2009, 07:37 AM

Originally Posted by StephenR

Why not a formula in Sheet2 A3 and copied across and down as far as necessary? The ranges will need adjusting. I guess you could do this with code.

=INDEX(sheet1!$A$3:$L$15,ROWS(A$3:A3),MATCH(A$2,sheet1!$A$2:$K$2,0))

Hi StephenR

Thanks for the help...
I was wonder if it's possible to do in VBA?
The range it's one of the most important issues here.
Can it be done in VBA?

Thanks again

**StephenR** · 08-05-2009, 07:47 AM

Try this:

Please Login or Register  to view this content.

**jmaocubo** · 08-05-2009, 09:32 AM

Originally Posted by StephenR

Try this:

Please Login or Register  to view this content.

That what i need

But there is a problem i know what it is but i don't know how to fix it!!!

It´s a Redundancy error (see attach)

and... many thanks

Miguel

**StephenR** · 08-05-2009, 09:48 AM

You need to make sure the sheet are referenced in the formula string by their actual names (i.e. what's on the sheet tabs).

Please Login or Register  to view this content.

**jmaocubo** · 08-05-2009, 10:11 AM

the pressure wasssss big for this work that i didn't saw

StephenR you save my week... thanks, many thanks...

Columns match based on headline

LinkBack

Thread Tools

Rate This Thread

Display

Columns match based on headline

Re: Columns match based on headline

Re: Columns match based on headline

Re: Columns match based on headline

Re: Columns match based on headline

Re: Columns match based on headline

Re: Columns match based on headline

Re: Columns match based on headline

Re: Columns match based on headline

Re: Columns match based on headline

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions