Auto Filter/Lookup & Copy

[josh09]

Hi,

Attached is my sample sheet.

I want to filter and copy range of cells automatically. to filter and copy the overtime from first sheet to second sheet. sample format provided. the filtered data will appear on the second sheet.

Thank you.

[TMS]

Filter in what way? How do you select which entries to copy across? You've provided a format but no examples of what goes in it based on the raw data.

If it's all records, can't you just copy and paste special | values into the new format?

Regards

[josh09]

sorry for that. I just want to filter only all those having overtime and copy to OTreport sheet automatically. sample re-attached.

Thank you.