sorting

[bander143]

Hello to all and I am a basic neophyte when it comes to Excel (2010) but I am computer proficient. PLEASE help me with this as I use (and help) other forums and find very smart people out there:

I have 2 spread sheets

Sheet #1 I have info on columns a-i (1264 lines) column A has item numbers (6 digits)
Sheet #2 I have info in columns a-i also (14,989 lines) column A also has item numbers (6 digits)

All of the item numbers in column A sheet #1 are contained in sheet #2 but since the numbers on both sheets are not even close to consecutive as many 6 digit numbers are skipped on both, this is where my issue arises. Again the 1264 numbers in sheet #1 are ARE in column A of sheet #2.

How can I line up both column A's matching numbers on the same line number so the merged sheet will now have columns A-R with the item numbers matching. I can end up deleting all the excess information after this function is done. Also there are no formulas in either sheet just raw data. I hope this is not confusing and THANKS in advance!

Please help!!!

[NBVC]

Perhaps one way...

On the sheet with more rows (let's call it Sheet2), enter in a new column, say J2 a formula to determine if the item number matches that of the sheet with less (let's call it Sheet1), the formula would be like:

=Isnumber(Match(A2,'Sheet1'!A:A,0)) copied down

TRUE result means item found.

You can then apply Autofilter from the Data menu and filter For FALSE to see which didn't match and do further work from there.....

[NBVC]

From PM

Thank you THANK YOU for replying to my post yesterday and I still cannot get this done I am hoping the new explanation below can make this easier. I you can help with this GREAT!

1) There is a spreadsheet with columns A-S (A-I is one group and J-S is second)
2) A-I has 1254 lines
3) J-S has 14,889 lines
4) Column I and J have numbers 4-6 digits. All the I numbers are contained in the J numbers but there is no consecutive order.
5) I need all the numbers in J to line up with the numbers in I (I are the main numbers concerned about sort order)
6) All columns J-S must stay together after sorting and of course A-I which should be natural.

All the excess numbers I do not care about and will delete after. If attaching the file would help I will.

If what I mentioned already won't work for you... then probably you will need VBA which is not my expertise right now.

Maybe a small sample workbook with what you have and expect would help clarify.