Sorry, my typo. i mean position column name as Played column name.
so, in your case, it might be

Const pos As String = "e" 'Change to position column name

should be

Const pos As String = "g" 'Change to Played column name

in my guess.

also, this can't deal so fast with data if many. i think using a query
is the way to go.

keizi

"esiason14"
wrote in message
...

Wow. Thanks, guys. I'll try this out later today. I appeciated the
tips/examples!

ExcelEddie...yes, please send it to me. I would like to check it out.


--
esiason14
----------------------------------------------------------------------
--
esiason14's Profile:
http://www.excelforum.com/member.php...o&userid=34587
View this thread:
http://www.excelforum.com/showthread...hreadid=543597