Copy rows and paste to new worksheet

[Hammer_757]

I import external data and then use a macro to reformat the data fo
analysis. The next step is that I break the data out to ne
worksheets.

I select the data for the new worksheets based on a column name
“Code”. All the rows with the same “code” get copied to one workshee
and I repeat that until I’m done.

How can I do this with a macro? The codes vary from data set to dat
set so I need it to just look for identical “code” cells and cop
those rows

 

[Ron de Bruin]

Try this example

http://www.rondebruin.nl/copy5.htm

 

[Hammer_757]

Thanks Ron, that look like a good starting poin