Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto list/filter
I'm having a little trouble finding the best way to do this. And then, of
course, actually doing it will probably be a problem as well. But here goes. I'm creating a log using columns A-J in one worksheet. What I want is to have another worksheet that will be only columns C and J AND only rows in which the cell in column C reads "Closed". Here's the thing. I'm creating a blank log. What I want is that as the data is entered into the log, it will automatically appear in the other worksheet if the condition is met. Also, column J is a dollar amount, so I want there to be a total at the end of the list formed. Obviously, not every row will say "Closed, but I don't want there to be spaces in the list formed. From what I gathered from other posts and trying to figure it out myself, the problem with a pivot table, is that I don't have any data yet, and the problem with auto filter, well, is that I don't want to have to manually sort anything, I want it to automatically populate. Is there anyone who can help me do this? Thanks, Scott |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto Filter question | Excel Worksheet Functions | |||
Auto filter through the Comman Button | Excel Worksheet Functions | |||
any formula to auto calculate 1st-12th is 12 days pls? | Excel Discussion (Misc queries) | |||
Averaging Values in Auto Filter | Excel Worksheet Functions | |||
excel links update not working in auto, calculations in auto | Excel Worksheet Functions |