Let me throw in a little more detail here.......

The idea here is that a ton of information gets pasted into cells F2 -
F1500 on a daily basis. Now, there is a list of names in cells C2-C50
and cells D2-D50 count up how many of the entries in F2 - F1500 apply
to each of the names in C2-C50. On the Details sheet I have the daily
results of this count.

At the moment I am manually moving the count in D2 - D50 to the daily
tracker which is time consuming. I was hoping that I could put the day
of the month (as 1, or 10, what have you) in H1 and have it
automaticlly move it to the corosponding day for the matching name on
the Details sheet.

So, let me throw in an example. C2 contains "John Doe" . D2 contains
John's count of 150. On the details sheet D6 would be John's Day 1 and
D7 would be Johns Day 2. I'm looking for a function that will place the
contents of D2 into Details!D6 if H1=1 and Details!D7 if H1=2, but will
not blank out Details!D6 when H1 is changed from 1 to 2.

I am open to suggestions if anyone has any ideas of a way to go at
this........


--
nevi
------------------------------------------------------------------------
nevi's Profile: http://www.excelforum.com/member.php...o&userid=33238
View this thread: http://www.excelforum.com/showthread...hreadid=552857