Hi, Sorry for the confusion mike. Here is the layout.
I have a date/time counter that relates each cow number to today's date and
in one way or another returns "due" in its column (J). The pivot table then
makes a list of those due cows. I then had a list box form that would collect
the pivot table cow numbers and ask the user to check off within the listbox
which cows they actually did vaccinate . From there a new list on a totally
different sheet is made. I was making that array=CowList it was an offset
named list and had cow numbers in A and the vaccination date in column B.
Then What I was hoping to do was have a command button or maybe another form
that looked at the new array CowList and tried to find those cow numbers in
column B of my main sheet called "database."
I think your code is totally on the money, I just am having a hard time
understanding how to implement it. Should I attach that code to a command
button on my sheet with the CowList or should I make it a Macros...?
This is where I am simply lacking experience and I apologize.
Hoping you have some patience left-

Thank you for your time,

Mae
"Mike H." wrote:

I am confused too. I don't see how you know which cows to update vaccines
on? Your original posting said you use a pivot table to determine which cows
are due for a vaccine. So you should take that list and either use the list
to populate cowlist() or do something else to find the cows that need to have
vaccines updated. Then just use the if-then-else statement as you have below
to determine which column to populate the date in. HTH...