Posts45Registration dateSunday February 7, 2010StatusMemberLast seenApril 15, 2012
Feb 25, 2010 at 01:35 AM
Mar 1, 2010 at 07:33 AM
Can anyone give advice?
I got a form on sheet1 thats got a savebutton to save the input data of the form to the database on sheet2.On sheet2 row1 i got headings in Columns A1 to J1. A1=StpDate&Time(dd,mm,yyyy hh:mm) ,B1=event,C1=Stage,D1=No.,E1=Descrip,F1=Types,G1=Stype,H1=Comm,I1=StrDate&Time(dd,mm,yyyy hh:mm), J1=StpDate&Time minus StrDate&Time( [h]:mm:ss )
I want to lookup a specific month(Jan-Dec)in column A , count the amount of different Types in column G (Types=Inc,Circ,Sched,Oth1) and also add the time for the differnt types from column J where i subtract I2 from A2,I3-A3......etc
I need to get this to sheet 3 to make a pie chart
I've put filters in on the columns in Sheet 2 and can get the specific month.Is there a way that i can use the filtered data and then count and add them and use them in a pie chart.