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

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

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

Sound like VLOOKUP should do what you want
Debra has a good explanation @
http://www.contextures.com/xlFunctions02.html
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"Yookaroo" wrote in message
...
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

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