It is somewhat working... I think i didn't explain myself correrctly.
I noticed that the Name gets tranfered over... but i have to tell it in what
cell.. I was hoping it would automatically recognize the appropriate
column."january"etc.

Is there a way that the computer can recognize that "1-4-07" is the month of
january and recognize the january column in sheet2 and have it automatically
transfer there..

Also, I am entering hundreds of names daily...If i would have to paste the
formula for every individual cell for the whole months it would take too
much time...Is there a way i can paste the formula over multiple cells.. ex
for the whole month.

"Teethless mama" wrote:

dates -- is a defined name from the dates range
names -- is a defined name from the names range

When you excecute the formula make sure hold down CTRL and SHIFT key
together and hit ENTER

"Jman" wrote:



"Teethless mama" wrote:

In sheet 2:
A1: holds January
B1: holds February
C1: holds March
and so on...

A2:
=IF(ISERR(SMALL(IF(TEXT(dates,"mmmm")=Sheet2!A$1,R OW(INDIRECT("1:"&ROWS(names)))),ROWS($1:1))),"",IN DEX(names,SMALL(IF(TEXT(dates,"mmmm")=Sheet2!A$1,R OW(INDIRECT("1:"&ROWS(names)))),ROWS($1:1))))

ctrl+shift+enter, not just enter
Copy across and down as far as needed

It doesn't seem to be working,, i am sure i am probably doing something
wrong.


"Jman" wrote:

I want to work with two sheets.

I have a sheet"1" column (a1) "names",
column (b2) "dates"

Example
a1
John Mcarther ....1-15-07
David Chrysler.....1-06-07
Chris Bobby .......2-15-07
Dan John.............3-15-07

b1
1-15-07
1-06-07
2-15-07
3-15-07

What i want to do in Sheet 2 have. Column A1 Named (january) and B2
(february) and B3 (March) and so on thru the whole year.

When i enter the name and date in sheet one.. I want that data to
automatically be transfered in the appropriate "month column" in sheet 2.

example

a1
(January)
John Mcarther
David Chrysler

b1
(Februrary)
Chris Bobby


C1
(March)
Dan John.