One more question) Extracting the matching columns to the other sheet

[leeb91]

I have two sheets. First one has 4 columns and more than 100 rows for each column

ColumnA......ColumnB......ColumnC......ColumnD

Claim_ID.........................................Claim_Status

...123............... A................B ............ Closed

The other sheet only has one row as below

ColumnA.......ColumnB.......ColumnC......ColumnD

Claim_ID.........State........Claim_Status....Date

I have to copy from the first sheet the data that's under the same column headings as sheet2
For example, the result should be

ColumnA.......ColumnB.......ColumnC.......ColumnD

Claim_ID.........State........Claim_Status.....Date

..123..................................Closed

Is this possible? In the first sheet, there are more than 100 rows that need to be copied.

 

[Simon4s]

I have two sheets. First one has 4 columns and more than 100 rows for each column

ColumnA......ColumnB......ColumnC......ColumnD

Claim_ID.........................................Claim_Status

...123............... A................B ............ Closed

The other sheet only has one row as below

ColumnA.......ColumnB.......ColumnC......ColumnD

Claim_ID.........State........Claim_Status....Date

I have to copy from the first sheet the data that's under the same column headings as sheet2
For example, the result should be

ColumnA.......ColumnB.......ColumnC.......ColumnD

Claim_ID.........State........Claim_Status.....Date

..123..................................Closed

Is this possible? In the first sheet, there are more than 100 rows that need to be copied.

Are the column headings the same in both sheets?

Do a vlookup

In the sheet with one row:
IN a2: =vlookup(A$1,sheet2!$A$1:$D$100,1,false)
IN B2: =vlookup(B$1,sheet2!$A$1:$D$100,2,false)
IN C2: =vlookup(C$1,sheet2!$A$1:$D$100,3,false)
IN D2: =vlookup(D$1,sheet2!$A$1:$D$100,4,false)

 

[leeb91]

Hi, the first sheet had had unnecessary column headings in which I removed for convenience. I have thought about that approach but this is a recurring need with more than 30~50 columns and 70,000 lines so I thought I would have to find a way to automate it. The columns in sheet1 that have the same column headings as sheet2 have to be copied into sheet2 correspondingly. I shrunk the number greatly for clearer explanation.
Thanks for the input.