How copy selected cells to another worksheet

[jovie]

I want to copy selected cells based on the requirement, because I got color fill in and numbers for the cells, so I want copy the selected cells in to another worksheet according to different color. And also I want copy some selected cells into another worksheet, for the cells number is zero.
I dun know is it can be understand or not

 

[sijpie]

Yes that can be done. Put the following in Google search:
excel select cells by color

That should give you enough ideas.