Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I update all worksheets at startup? | Excel Worksheet Functions | |||
How do i update multiple data ranges across multiple worksheets? | Excel Discussion (Misc queries) | |||
Update multiple worksheets | Excel Discussion (Misc queries) | |||
Update another worksheets | Excel Worksheet Functions | |||
How to update multiple links in multiple spreadsheets followin mo. | Excel Worksheet Functions |