Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-22-2009, 04:18 AM
brianh brianh is offline Searching dates to create lists Windows XP Searching dates to create lists Office 2003
Novice
Searching dates to create lists
 
Join Date: Sep 2009
Posts: 1
brianh is on a distinguished road
Default Searching dates to create lists

Hi. I have a spreadsheet that contains names in column C and dates in column G. I'm looking for a macro or formula that checks all the dates in column G and lists the corresponding names for those dates that are earlier than todays date. I would like the output to appear in a seperate area within the same spreadsheet, if possible. Is there an easy, straight forward way of performing this task?
Reply With Quote
  #2  
Old 01-14-2010, 03:08 PM
BjornS BjornS is offline Searching dates to create lists Windows Vista Searching dates to create lists Office 2003
Competent Performer
 
Join Date: Jan 2010
Location: Sweden
Posts: 116
BjornS is on a distinguished road
Default

Hi,
this is possible to solve via "MS Query", which is built-in in Excel. It is not too easy to explain. I attach a sheet that should work for you. You can add your data to this sheet!

Do not change anything in the sheet "Result". Try to change records in the sheet "Data" and you will see that the "result" sheet changes!

Kind regards
Bjorn
Attached Files
File Type: xls Tabell.xls (20.5 KB, 17 views)
Reply With Quote
  #3  
Old 01-18-2010, 01:58 PM
BjornS BjornS is offline Searching dates to create lists Windows Vista Searching dates to create lists Office 2003
Competent Performer
 
Join Date: Jan 2010
Location: Sweden
Posts: 116
BjornS is on a distinguished road
Default

Sorry,
due to different circumstances this solution doesn't work correctly.

Kind regards
Bjorn
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Searching dates to create lists MS Excel 2004 for Mac - copying dates between documents BCRenton Excel 4 11-10-2009 07:28 AM
Searching Outlook folders not working cltaylor Outlook 0 08-31-2009 10:28 AM
Searching dates to create lists Searching another persons contacts Hendo313 Outlook 1 07-10-2009 09:03 AM
Adding dates mkkram Word 0 11-27-2006 09:18 AM
Drop Down Lists Browett Excel 0 12-19-2005 04:20 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:19 PM.


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