form a database from multiple sheets

[udea]

Hi,



Here is another problem from me. i've been doing this for month but nothing.

I want to create a database table in sheet1, preferably with drop down button (create from name manager and validate the cell with list and the name right?).
the data is across 200 sheets.

what i'm trying to achieve is by selecting designated technician in 1st column, required date in 2nd column and specific time frame (either 12am-12pm or 12pm-12am) in 3rd column, i will get the count of results across the sheets.

My main problem is use the right formula for it to differentiate the 12hrs time frame and to count the data across the sheets, i guess i can use COUNTIF.

Pls help me..

Regards,
Udea

[udea]

Hi anyone....

Is this topic so lame that i cant get any suggestion here or it is so unreal or i can get the solution in other posts?

Honestly, i cant find it in other post and if anyone know where, pls guide me there, if it is so unreal, pls explain why, and if it is so lame, pls help me though coz i'm so stuck on it...

Thanks in advance...

Regards,
Udea