View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ashish Mathur[_2_] Ashish Mathur[_2_] is offline
external usenet poster
 
Posts: 1,766
Default Skip Rows in Fill Series and Filter to Two different sheets

Hi,

You may want to refer to Question 7 on
http://ashishmathur.com/knowledgebaseII.aspx.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Benjamin" wrote in message
...
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?