Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formula
I am working in two worksheets. One shee is "All" and the second sheet in
broken down by departments; however, when I get information from the departments, I want to mark off the informaton in the "All" sheet and have that information automatically copied int he department sheet. Is this possible? |
#2
|
|||
|
|||
one way is to have a column to indicate
DEPTdatafilterautofilterfilterbydeptcopy visible cells OR use a macro to do it that way or a for/each loop -- Don Guillett SalesAid Software "Pat" wrote in message ... I am working in two worksheets. One shee is "All" and the second sheet in broken down by departments; however, when I get information from the departments, I want to mark off the informaton in the "All" sheet and have that information automatically copied int he department sheet. Is this possible? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
revert formula insertion to old method | Setting up and Configuration of Excel | |||
Simple formula doesn't quite add up | Excel Discussion (Misc queries) | |||
how do I make a formula NOT change when the data range is moved? | Excel Discussion (Misc queries) | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions | |||
Excel 2003 - Formula result shows as 0:00 | Excel Worksheet Functions |