Hi Mey

You can use Advanced Filter to do that. No need VBA.

1) Output sheet must have all the required headers

2) Go to sheet 2 and select any blank cell (eg H1) to the right of the header (do not select the headers)

3) Select Data Sort & Filter - Advanced

4) Select Copy To Another Location

5) Select List Range  - Database range A5:F11

6) Select Criteria Range - Database range A2:A3

7) Select Copy To - Sheet2 range A1:F1

8) Click OK

Do the same for Sheet3 but the criteria is Database range F2:F3

Hope this helps

Sunny

Hi Sunny,

Could you give me to fetch only data with status cancelled to sheet2 by macro?

thanks in advance

Give this a try.

Sunny