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 a Find
loop might work but I am not that good with VBA yet. Help!