How to update multiple worksheets

  • Thread starter Thread starter Zhead
  • Start date Start date
Z

Zhead

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.
 
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
 
Back
Top