Thread: Copy rows and paste to new worksheet
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
  
Posts: 11,123
Default Copy rows and paste to new worksheet
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/



Reply With QuoteReply With Quote