Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Craeting a relatively complex macro - need help - looping
I am relatively new at this but here goes...
I am trying to create a macro to tell me how many times a seat has been occupied since it was last checked. i.e. seat 1 checked on 3.13.07 column A column b seat number check date 1 3.13.07 I have a separate data report which identifies on a per day basis how many times the chair was used. i.e. date 03.01.07 03.02.07 03.03.07........ chair number 1 2 3 ...... I need to qualify how many times (not the last time) the chair was used since the last date it was checked. ANY SUGGESTIONS? I am really lost here..... |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Craeting a relatively complex macro - need help - looping
This is pretty simple. You need to add another row (or column) to your date
table to indicate that the chair has been checked (the X data below). You also need to add to the date list everytime a set is occupied. the n all you have to do is count the number of time the chair appears in the date list without an X. Then add the X to the date list indicating that it has been checked. date 03.01.07 03.02.07 03.03.07........ X X X I am trying to create a macro to tell me how many times a seat has been occupied since it was last checked. i.e. seat 1 checked on 3.13.07 column A column b seat number check date 1 3.13.07 I have a separate data report which identifies on a per day basis how many times the chair was used. i.e. date 03.01.07 03.02.07 03.03.07........ chair number 1 2 3 ...... I need to qualify how many times (not the last time) the chair was used since the last date it was checked. ANY SUGGESTIONS? I am really lost here..... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro looping? | Excel Worksheet Functions | |||
Looping Macro | Excel Discussion (Misc queries) | |||
Looping macro | Excel Worksheet Functions | |||
Looping macro | Excel Programming | |||
complex looping problem | Excel Programming |