Find Copy and Paste

C

carlos_ray86

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Find Copy Paste 1
Group rows based on indention of string in a column 0
At each change in data concatenate text values in contiguous ranges 2
Is it possible to use filtering in a row and in a column 2
Same text in column as one 6
Calculate running average but not count a zero. 3
count a value in a date range based on a date in another workshee. 4
Delete every other two row MACRO 3

Top