| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Two questions - copying and averaging
Hello! Is it possible to have a case automatically copy to a second sheet if
a certain value is added into one of the columns? So, I want all the cases that have a 1 in column B to be automatically pasted into sheet 2. Is that possible? If not, is there some way to automatically calculate the average of all the 1s in a separate sheet without having to run a filter? Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| averaging & ??? | Excel Worksheet Functions | |||
| Help with averaging... | Excel Discussion (Misc queries) | |||
| Averaging | Excel Discussion (Misc queries) | |||
| Questions on copying from one sheet to the other and coping every other cell. | Excel Discussion (Misc queries) | |||
| 2 questions, copying data from sheet to sheet and assigning macro | Excel Worksheet Functions | |||
Threaded Mode
