Hopefully an easy question

  • Thread starter Thread starter Yookaroo
  • Start date Start date
Y

Yookaroo

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?
 
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?
 
Back
Top