Acessing data between two dates

drag-driver · Mar 5th, 2002, 04:37 AM

Want to be able to access data from a history file between two specified dates.
ie. Have data from 2/3/02 to 28/3/02(history file).
Need to pull data between the dates 7/3/02 to 14/3/02.

Any ideas would be of great help!

Mudface · Mar 5th, 2002, 04:44 AM

There's probably many ways of doing it, but a couple of the easiest would be to either create a pivot table of your data and exclude any dates outside those you require; or use a custom autofilter to filter out data outside your interval and copy and paste to a new sheet.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 5th, 2002, 04:37 AM	#1
drag-driver Board Regular Join Date: Feb 2002 Posts: 91	Want to be able to access data from a history file between two specified dates. ie. Have data from 2/3/02 to 28/3/02(history file). Need to pull data between the dates 7/3/02 to 14/3/02. Any ideas would be of great help!

Mar 5th, 2002, 04:44 AM	#2
Mudface MrExcel MVP Join Date: Feb 2002 Location: Sunny, spring-like Hull Posts: 3,339	There's probably many ways of doing it, but a couple of the easiest would be to either create a pivot table of your data and exclude any dates outside those you require; or use a custom autofilter to filter out data outside your interval and copy and paste to a new sheet.