How to update multiple worksheets
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. |
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. |
All times are GMT +1. The time now is 05:53 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com