i want to create a function / macro for this scenario:
if ID123456 has the status open dated 01/05/07 and the user later decided to change the status of ID123456 to closed on 03/05/07. The graph should count the number of closed then lessen the count of open because the previously open ID is already closed. please help me.
i have this excel file where i need to update automatically the contents of the chart. here is the scenario:
ID Status date
12 open 02/05/07
12 closed 05/28/07
15 closed 03/05/07
25 open 03/06/07
26 open 03/07/07
35 open 03/08/07
26 open 03/09/07
28 closed 03/10/07
26 closed 03/11/07
14 open 03/12/07
14 closed 03/13/07
Closed - 5
Open - 4
as you can see above, i have 2 types of cases, closed and open and IDs have duplicates, this is for the
reason that, a particular ID is logged first as open and when the user decided to changed its status he
will log again that ID as closed. Once the ID has been closed, its previous ID (which is open) will now be
If I log ID35 as closed then
so on and so forth
This transaction must update a graph that automatically update each time a Status is logged.
An Open Status can occur more than once per ID and should only be counted as 1....but only the Closed status can appear once per ID...and once the ID has been closed...the Closed summary will increase and the Open Summary will be decreased by 1 automatically.