match between two sheets baesd on column and copy whole data and insert column(costing)

hi
I have two sheets (SUMMARY,DT) . what I want creating the whole data in sheet output with the same headers and borders with formatnumber(#,##.##)
based on matching the column B into two sheets and the formula in last column shouldn't show when insert the column . with considering data are about 2500 rows for each sheet and the macro should replace data every time run .
thanks in advance

May we assume the same codes exist on the same row in column B of each sheet, or is this a simple example that doesn't reflect the real layouts?

.but ALL codes exist in both sheets?

The question is not about bringing the columns together. We're trying to understand that as well as there being codes common to both sheets, whether there are different codes on the two sheets.

This is clearly a much simplified example and probably doesn't represent your actual data. We often find that when we give an answer to what is a trivial non representative example when the solution is used with the real world data it doesn't work because of factors like string length and other stuff which is important but hasn't been mentioned.

Therefore upload your real workbook (or at least a cut down copy), and manually add the results you expect to see. Clearly identify which is original data and which are the results and in a note clearly explain how you have arrived at your results.

Remember that when you ask a question in a forum those of us who might be able to help know absolutely nothing about your system and work process or the terminology you use. Unless you have uploaded a workbook we know nothing about how it is laid out and little about what you want done with it or how the results should be presented.

Whilst these things are second nature to you since you live with the workbook all the working day we start with zero knowledge so you need to take us by the hand and explain in quite precise detail your aims and goals as well as stuff like how your data might look different in other situations.
Don't assume we are able to "figure it out". We're usually quite good but not prescient.

Put yourself in our position and think about whether what you've posted makes sense and is unambiguous to someone who's never seen it before.
You are asking us for help so help us to be able to help you by providing all the information we need, even if that information seems obvious or intuitive to you.

Originally Posted by leap out

@Richard Buttrey

surely not .
the same codes have to existed into two sheets .

So does that mean the two sheets have exactly the same number of rows?

Macro code

Please Login or Register  to view this content.

Removed by JT.

Have you considered using Power Query to combine the two sets of data?

Originally Posted by leap out

@kvsrinivasamurthy may you tell me how your code works? It just shows error #N/A in N1,O1

Code does not refer to N1 and O1 at all. How you are getting error. Pl see the enclosed file after run of macro.
Pl upload your file showing error.