How about a PivotTable or Advanced Filter instead?

--JP

On Jan 19, 2:49*pm, anshu minocha wrote:
Foe eg: Sheet2 contains:

Project# * Phase * Sp# * Details status Manager ...
1234 * * * *1-0110 *N80 * abc * * * Test * *am
1234 * * * *1-0210 *N97 * def * * * *Incom *bd
1234 * * * *2-0210 *N45 * lmn * * * Test * *cf
1234 * * * *1-0110 *N67 * jkl * * * * Com * *er

Sheet1 contains:

Project# *Phase * SP# * Status *Manager
1234 * * * 1-0110

The above 2 values are inserted by the user:
Now: On running the macro:

the sheet 1 should be populated with all the records for phase 1-0110
Desired output:

Project# Phase *Sp# *Status Manager
1234 * * *1-0110 *N80 *Test * *am
* * * * * * * * * * * * *N65 *Com * *er

Any help would be greatly appreciated!!!
Thanks