View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Benjamin Benjamin is offline
external usenet poster
 
Posts: 102
Default Skip Rows in Fill Series and Filter to Two different sheets

I've got a fill series of unquie entries.

Col
A B C D
Status xx xx xx

I need to copy the rows to different sheets.
I've got six different status types.
Depending on the status I've got two different sheets two send them to.

How can I fill the two sheets?