View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Hammer_757 Hammer_757 is offline
external usenet poster
 
Posts: 1
Default Copy rows and paste to new worksheet

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