Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-24-2011, 03:40 AM
udea udea is offline form a database from multiple sheets Windows 7 64bit form a database from multiple sheets Office 2007
Novice
form a database from multiple sheets
 
Join Date: Apr 2011
Posts: 13
udea is on a distinguished road
Default form a database from multiple sheets

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
Attached Files
File Type: xlsx Book2.xlsx (11.5 KB, 10 views)
Reply With Quote
  #2  
Old 04-25-2011, 02:34 AM
udea udea is offline form a database from multiple sheets Windows 7 64bit form a database from multiple sheets Office 2007
Novice
form a database from multiple sheets
 
Join Date: Apr 2011
Posts: 13
udea is on a distinguished road
Default

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
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
form a database from multiple sheets How do I merge data from one sheet in a workbook out into multiple sheets nolesca Excel 4 06-07-2010 08:13 AM
Print Multiple Sheets Double-Sided flambe99 Excel 1 03-12-2010 01:15 PM
Excel Database mtnguye9 Excel 1 11-26-2009 01:42 PM
Excel 2007 doesn't print color graphics on multiple sheets mwoolf Excel 1 06-19-2009 02:34 AM
Populate cells in Word from a database hotlilshan Word 3 12-09-2008 01:51 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:22 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft