ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Dates period from master worksheet to another worksheet (https://www.excelbanter.com/excel-discussion-misc-queries/80979-dates-period-master-worksheet-another-worksheet.html)

colin

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

CLR

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



All times are GMT +1. The time now is 05:41 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com