View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Eduardo Eduardo is offline
external usenet poster
 
Posts: 2,276
Default How to update multiple worksheets

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.