Excel - How To Select On Date Col Starting With Today and Beyond

[JohnBates]

Hi Excel experts,

This is Excel 2002 - it's a simple worksheet without any pivot tables. Data comes from a file on another computer.

The sheet contains a Scheduled Shipment Date column. But the input file contains historical data - ie Scheduled Shipment Dates that are several months before todays date.

The sheet has Filter Mode for all columns - so the user must click the Scheduled Shipment Date column and select todays date to see the shipments they really want.

With all that said.... here is my simple question:

What can I do to put only rows that have Scheduled Shipment Dates that A) contains todays/current date and beyond
OR better yet B) contains dates that are no more than 1 week ago

Can I do this with a MS Query?

The Scheduled Shipment Date is in CYYMMDD format...
ex: 1030718 for July 18 2003

Thanks, John

 

[substitute]

The obvious thing to do is to get whoever creates the source file to select just the data you want. Otherwise...

If you don't mind creating a new spreadsheet you can use the filter to select rows where shipment date > (the date you want), then select just those rows into a new spreadsheet.

Filter the sheet so it shows the rows you want then select the whole table. From the menu choose Edit/Go to..., click Special, select Visible Cells Only and click OK. Copy the selection and paste it to a new spreadsheet.

 

[DaleWatson123321]

John,

What "substitute" suggests regarding filtering and then copying/pasting the data to a separate sheet is a reasonable option. However, this can easily be set up to execute "automatically" - at the click-of-a-button.

This "Advanced Filter" component of Excel is not documented by Microsoft anywhere nearly as well as it should be. Therefore, if you'd like assistance in setting up your file, I'm prepared to help.

The easiest way (for both of us) would be for you to email a copy of your file. Only include a small number of records, and replace any sensitive data with fictitious data if required.

Hope this can help.

Regards, ...Dale Watson dwatson@bsi.gov.mb.ca

 

[mhansler]

Can you paste what you modified dale? I am looking for how to pull records from an odbc sorced data via Microsoft Query, that is within the current month.

FieldNameDate

Select FieldNameDate for FieldNameDate = Current Month.

 

[SkipVought]

Hey mhansler,

Start a NEW THREAD with your question.

This thread is for JohnBates' question.

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com