View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Kdub via OfficeKB.com Kdub via OfficeKB.com is offline
external usenet poster
 
Posts: 1
Default Create Multiple Worksheets from One

I have a worksheet that contains about 3000 rows. I would like to cut data
from this worksheet and copy all data whenever the value in column C
changes. For example, for this worksheet:

A B C
163 4/4/2005 51
168 4/2/2005 51
123 4/5/2005 62
128 4/1/2005 62
187 4/9/2005 71

I need to create three new worksheets, the first containing rows 1 and 2,
the second containing rows 3 and 4, and the third containing row 5. I'm
not sure of the best way to go about this. Any suggestions welcome.