Hi,
did you think in using a filter at the end of the day so you have all your
closed or opened, then you can copy this information as follow
Highlight the area sorted, hit CTRL G, special, cells visible only, copy,
then paste it into the new sheet

if this helps please click yes, thanks

"Zhead" wrote:

I havean Original sheet that i update. i want to create an Open worksheet and
a Close worksheet. When i change the Status on the orignal to open or close i
want it to update the correct sheet.