You need to perform a sort using 2 keys (Item number and data). You can
write you own sort macro that will keep two row together. Or you can copy
the data in a new worksheet and put the two rows on 1 line. Perform the
sort, then take the sorted rows and put them back into two rows.

I think it is always better to keep this type data in one row rather than two.


Let me know what you want to do. I write the code if you need the help. I
will also need do know in row two if you want to have all 3 data items
sorted. the standard sort function in Excel only uses 3 key fields. You
have 4 fields (Item plus three data columns in row 2).

" wrote:

I have yet to write any code purtaining on how to accomplish this so
that's why I am asking for help. I have a list of data that is like
this....
A B C
"Item # 2 "Pressure 9.33E-30" ER 678, Row1
4094.78 'K, 6.543 mm/Min, 1232 mm Row2
"Item # 3 "Pressure 9.33E-30" ER 678, Row3
4094.78 'K, 6.543 mm/Min, 1232 mm Row4
" Item # 4 "Pressure 9.33E-30" ER 678, Row5
4094.78 'K, 6.543 mm/Min, 1232 mm Row6
"Item # 3 "Pressure 9.33E-30" ER 678, Row7
4094.78 'K, 6.543 mm/Min, 1232 mm Row8

I am trying to group the items together by number but also with the
data that is underneath it. Once they are grouped together then
pasted
into a new worksheet so they will go in order. I am assuming maybe a
Find loop might mork.