Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Time Criteria
I have the following worksheet and would like to have a current population count as well as extrapulate information to a worksheet with only the active population shown with all the information for each name
Name Sex DOB Date In Time In Date Out Time Out The current population would be between 12:00 AM Time In and 12:00 AM Time Ou 12:00 AM and <12:00 AM for Time Ou The first worksheet would be a history worksheet and the second would be current only Thanks for any suggestions |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Time Criteria
You should be able to do this with Data=Filter=Autofilter, then select
your criteria. However, it seems like everyone would have come in after midnight and left before midnight. I assume the date of the coming and going would be a consideration. You might need to add a column with a formula to flag your records, then set the filter value on that column. In any event, once you have filtered the data, you can select all the data and copy it. Only the visible rows will be pasted. Once you have it all set up, turn on the macro recorder and repeat the actions manually. then turn off the recorder. This will give you the basic code you need to do this. Another option is to look at using the Advanced filter which can copy the filtered data to another location. (and you wouldn't need a macro) -- Regards, Tom Ogilvy "KPM" wrote in message ... I have the following worksheet and would like to have a current population count as well as extrapulate information to a worksheet with only the active population shown with all the information for each name. Name Sex DOB Date In Time In Date Out Time Out The current population would be between 12:00 AM Time In and 12:00 AM Time Out 12:00 AM and <12:00 AM for Time Out The first worksheet would be a history worksheet and the second would be current only Thanks for any suggestions. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMIFS-time criteria/month | Excel Worksheet Functions | |||
How to do average turn around time with criteria | Excel Discussion (Misc queries) | |||
auto set time(now) if criteria=true with no later change | Excel Worksheet Functions | |||
Can I filter a table on a time criteria? | Excel Discussion (Misc queries) | |||
Summing cells based on run-time criteria | Excel Programming |