Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
colin
 
Posts: n/a
Default Dates period from master worksheet to another worksheet

On the master schedule we are showing dates ie 01.04.06,15.04.06, 01,05,
30.05, etc., etc., we are trying to pull the date into another worksheet ie
april, may, june etc.,to only show that one date period
  #2   Report Post  
Posted to microsoft.public.excel.misc
CLR
 
Posts: n/a
Default Dates period from master worksheet to another worksheet

Use Data Filter AutoFilter then click on the arrow at the top of your
date column and choose CUSTOM, and set the GreaterThan and LesserThan dates
to emcompass our desired time period.......that will give you the date, then
copy it to another sheet if you wish.........

Vaya con Dios,
Chuck, CABGx3



"colin" wrote:

On the master schedule we are showing dates ie 01.04.06,15.04.06, 01,05,
30.05, etc., etc., we are trying to pull the date into another worksheet ie
april, may, june etc.,to only show that one date period

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Master Worksheet reflecting sub-worksheets [email protected] New Users to Excel 10 February 25th 06 02:49 AM
Is it possible to add dates in an excel worksheet to Outlook Cale. Matt Excel Discussion (Misc queries) 0 January 5th 05 09:13 PM
how do I show dates in a column in an excel worksheet? papacradd Excel Discussion (Misc queries) 1 December 8th 04 02:33 PM
How do I set up a Workbook with a master compiled worksheet and o. Double D Racing Excel Worksheet Functions 1 November 19th 04 06:03 AM
Seach Column and return multiple dates to another worksheet? Mcasteel Excel Worksheet Functions 0 November 10th 04 07:41 PM


All times are GMT +1. The time now is 04:29 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"