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

--
Message posted from http://www.ExcelForum.com

Try this example

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

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Hammer_757 " wrote in message ...
I import external data and then use a macro to reformat the data for
analysis. The next step is that I break the data out to new
worksheets.

I select the data for the new worksheets based on a column named
"Code". All the rows with the same "code" get copied to one worksheet
and I repeat that until I'm done.

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


---
Message posted from http://www.ExcelForum.com/

Thanks Ron, that look like a good starting poin

--
Message posted from http://www.ExcelForum.com