Need Way to Automatically Select Data

I would like to know of a way to select specific dates and corresponding
data and paste them into the next two columns.

The column A contains consecutive dates(mm,dd,yyy) covering a 30 year period
and column B contains data corresponding to each date. A way is needed to
automate selecting and copying a specific range of dates w/data for each
month of all years then pasting to columns C and D. ie: Select the date
range and corresponding data for the range 06/01 thru 8/31 for each of the
30 years. Then paste selected cells from columns A and B to columns C and D.
The 30 year time period will also vary in length from one study to the next.
TIA
Art

One way..........
Put these formulas in C1 and D1 and copy down

In cell C1 put =IF(AND(MONTH(A1)>=6,MONTH(A1)<=8),A1,"")

IN cell D1 put =IF(LEN(C1)>0,B1,"")

Vaya con Dios,
Chuck, CABGx3


"Art Stewart" <delaware@rochester.rr.com> wrote in message
news:lJSdncASo6rN8abfRVn-uA@pronetisp.net...
> I would like to know of a way to select specific dates and corresponding
> data and paste them into the next two columns.
>
> The column A contains consecutive dates(mm,dd,yyy) covering a 30 year
period
> and column B contains data corresponding to each date. A way is needed to
> automate selecting and copying a specific range of dates w/data for each
> month of all years then pasting to columns C and D. ie: Select the date
> range and corresponding data for the range 06/01 thru 8/31 for each of the
> 30 years. Then paste selected cells from columns A and B to columns C and
D.
> The 30 year time period will also vary in length from one study to the
next.
> TIA
> Art
>
>

Wow, this method works wonderfully, simply fantastic, what a time saver.
Thank you so much.

After such a great answer to my question I hate to ask another question so,
please, bear with me.

Now the question is how to include days in the formula just provided? Such
as the range from 6/7 thru 8/20 for example.

Thanks again for your kind help.
Art


"CLR" <croberts@tampabay.rr.com> wrote in message
news:uwD608CLFHA.3832@TK2MSFTNGP12.phx.gbl...
> One way..........
> Put these formulas in C1 and D1 and copy down
>
> In cell C1 put =IF(AND(MONTH(A1)>=6,MONTH(A1)<=8),A1,"")
>
> IN cell D1 put =IF(LEN(C1)>0,B1,"")
>
> Vaya con Dios,
> Chuck, CABGx3
>
>
> "Art Stewart" <delaware@rochester.rr.com> wrote in message
> news:lJSdncASo6rN8abfRVn-uA@pronetisp.net...
> > I would like to know of a way to select specific dates and corresponding
> > data and paste them into the next two columns.
> >
> > The column A contains consecutive dates(mm,dd,yyy) covering a 30 year
> period
> > and column B contains data corresponding to each date. A way is needed
to
> > automate selecting and copying a specific range of dates w/data for each
> > month of all years then pasting to columns C and D. ie: Select the date
> > range and corresponding data for the range 06/01 thru 8/31 for each of
the
> > 30 years. Then paste selected cells from columns A and B to columns C
and
> D.
> > The 30 year time period will also vary in length from one study to the
> next.
> > TIA
> > Art
> >
> >
>
>

Didn't test this, but it'll be something like this:

IF(AND(AND(MONTH(A1)>=6,DAY(A1)>=7),AND(MONTH(A1)<=8,DAY(A1)<=20)),A1,"")

Good Luck
Duke


"Art Stewart" <delaware@rochester.rr.com> wrote in message
news:n7edncq_n-YqE6HfRVn-1Q@pronetisp.net...
> Wow, this method works wonderfully, simply fantastic, what a time saver.
> Thank you so much.
>
> After such a great answer to my question I hate to ask another question
> so,
> please, bear with me.
>
> Now the question is how to include days in the formula just provided?
> Such
> as the range from 6/7 thru 8/20 for example.
>
> Thanks again for your kind help.
> Art
>
>
> "CLR" <croberts@tampabay.rr.com> wrote in message
> news:uwD608CLFHA.3832@TK2MSFTNGP12.phx.gbl...
>> One way..........
>> Put these formulas in C1 and D1 and copy down
>>
>> In cell C1 put =IF(AND(MONTH(A1)>=6,MONTH(A1)<=8),A1,"")
>>
>> IN cell D1 put =IF(LEN(C1)>0,B1,"")
>>
>> Vaya con Dios,
>> Chuck, CABGx3
>>
>>
>> "Art Stewart" <delaware@rochester.rr.com> wrote in message
>> news:lJSdncASo6rN8abfRVn-uA@pronetisp.net...
>> > I would like to know of a way to select specific dates and
>> > corresponding
>> > data and paste them into the next two columns.
>> >
>> > The column A contains consecutive dates(mm,dd,yyy) covering a 30 year
>> period
>> > and column B contains data corresponding to each date. A way is needed
> to
>> > automate selecting and copying a specific range of dates w/data for
>> > each
>> > month of all years then pasting to columns C and D. ie: Select the
>> > date
>> > range and corresponding data for the range 06/01 thru 8/31 for each of
> the
>> > 30 years. Then paste selected cells from columns A and B to columns C
> and
>> D.
>> > The 30 year time period will also vary in length from one study to the
>> next.
>> > TIA
>> > Art
>> >
>> >
>>
>>
>
>

You're very welcome Art.....thanks for your kind feedback. Sorry I was away
and didn't get right back on the other part of your question, but I see Duke
picked up on it, and although I didn't test it either, it does look like how
I would have answered...........so, hope it works for you but if for any
reason you need to, come on back and don't feel like you don't deserve,
we're all happy to help.......

Vaya con Dios,
Chuck, CABGx3


"Art Stewart" <delaware@rochester.rr.com> wrote in message
news:n7edncq_n-YqE6HfRVn-1Q@pronetisp.net...
> Wow, this method works wonderfully, simply fantastic, what a time saver.
> Thank you so much.
>
> After such a great answer to my question I hate to ask another question
so,
> please, bear with me.
>
> Now the question is how to include days in the formula just provided?
Such
> as the range from 6/7 thru 8/20 for example.
>
> Thanks again for your kind help.
> Art
>
>
> "CLR" <croberts@tampabay.rr.com> wrote in message
> news:uwD608CLFHA.3832@TK2MSFTNGP12.phx.gbl...
> > One way..........
> > Put these formulas in C1 and D1 and copy down
> >
> > In cell C1 put =IF(AND(MONTH(A1)>=6,MONTH(A1)<=8),A1,"")
> >
> > IN cell D1 put =IF(LEN(C1)>0,B1,"")
> >
> > Vaya con Dios,
> > Chuck, CABGx3
> >
> >
> > "Art Stewart" <delaware@rochester.rr.com> wrote in message
> > news:lJSdncASo6rN8abfRVn-uA@pronetisp.net...
> > > I would like to know of a way to select specific dates and
corresponding
> > > data and paste them into the next two columns.
> > >
> > > The column A contains consecutive dates(mm,dd,yyy) covering a 30 year
> > period
> > > and column B contains data corresponding to each date. A way is
needed
> to
> > > automate selecting and copying a specific range of dates w/data for
each
> > > month of all years then pasting to columns C and D. ie: Select the
date
> > > range and corresponding data for the range 06/01 thru 8/31 for each of
> the
> > > 30 years. Then paste selected cells from columns A and B to columns C
> and
> > D.
> > > The 30 year time period will also vary in length from one study to the
> > next.
> > > TIA
> > > Art
> > >
> > >
> >
> >
>
>