copy entire row from sheet1 into sheet2 matching ID and column header

[dileepkmr3]

<code style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono", "Bitstream Vera Sans Mono", "Courier New", monospace, sans-serif; vertical-align: baseline; box-sizing: inherit; white-space: inherit;">Sheet1
ID First Last Street City State Zip
---------------------------------------------------
51 Alfred Obrien 636 Charla Lane Richardson TX 75081
52 Donald Lemmons 4956 Center Street Umatilla OR97882
53 Corrine McCann 3149 West Street Grand Rap MI 49546
54 Monique Gavin 4078 Maryland Largo FL 34640
55 Steven Murray 965 Tree Top Lane Lansdowne PA 19050
56 Kelley Robins 1191 Earnhardt Louisville KY 40223

Sheet2
ID Zip State Last City first Street Zip
-----------------------------------------
56
51
87
52
55
53
54


need to copy the data row wise depends on ID(unique) if ID matches copy and paste the row at the same time column header should match. if you observe column headers are same but position is different in sheet2.
i got vlookup formula but#N/A is getting whenever if ID doesn't match which is overwriting the data.. so i need VBA code


</code>

 

[Fluff]

Cross posted https://www.excelforum.com/excel-pr...nto-sheet2-matching-id-and-column-header.html

Cross-Posting
While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules).
This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

 

[Fluff]

Also here http://www.vbaexpress.com/forum/sho...-if-ID-matches-and-column-header-should-match