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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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