let me take a look

since you have dynamic data and each time the position of the rows/cells can be different, there is no simple way to do it.  You will most likely have to write vba.

the process is: 1) step through each row.  2) if the row match the condition, copy the cell values to the location u want on the other sheet.

瞓咗1日, 瞓到呆呆地

please help and thx.....

flora, that is a programmer job. If u have to do this just for convenient, then it is not worth the effort to learn vba just for this; if this is a required job, then your boss will have to hire a programmer to do it or pay for u to go to class.

LOL......aren't you a programmer??

haha yes!  But I don't have time to do that for your boss ar!

LOL....I'm just kidding....how to apply filter to that??? since I tried before, if I filter Column A, but other columns won't update.....

it should work  you have to highlight the whole column and click data > filter and the first cell at the top shd become a drop down for the filtering