We really need you to be more descriptive in your request. As such:

1. What do you mean by "field"? Do you mean a named range, a single cell,
or a group of cells?

2. If a cell contains 50, then specifically what do you want to do? Do you
want to copy a part of a row to another sheet or... what?

3. Does the data that must be copied from all sheets follow any pattern?

Please post code or specific locations of the data to work one, and we can
help you come up with something.

Matthew Pfluger

"robin thobiyas" wrote:



I have 5 sheet in a workbook, and all the sheet contains a field which
contains different name for example:

sheet1 contains 9 fields and sheet2 may contain 11 fields but both may
contain a field called marks which is different position on the 2
sheets. And in marks field if there is a mark of 50 is there in that
then i have to select some more detail of that raw to another sheet.

Finally i need to take some data from all the sheets raws where the
mark is 50.

could you please help me to create the macro for this.

Thanks,
Robin.