Both sheets use column A as the sort order, there are no duplicates in these
lists, both are numbered from 1 to 7000, chips site just explains duplicates
or am I missing something?

So in my case if sheet B's column A matches sheetA's Column A then I need to
copy Columns L to AP for that row and insert it at column M into SheetA.

How can I write that as a formula?



"Bernard Liengme" wrote:

For both Sheets: What column has the SORT ORDER ?
Can duplicates exist? How should they be handled?
You may find Chip has an answer at
http://www.cpearson.com/excel/duplicat.htm
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"Yookaroo" wrote in message
...
I have two sheets that I need to merge together, both have a common first
row
called SORT ORDER with fields E-00001 up to E-07000.

I need to merge them without screwing up the order the first sheet is in,
as
its not something that can be auto sorted.

I need to bring the data from Sheet B which is in columns L to AP into a
Sheet A starting at column M using the SORT ORDER column

Thanks in advance


44