You're welcome !
Glad to hear it sorted itself out <g
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"A Romeo Jr" wrote in message
...
I just figured out the problem. If you look at the formula I pasted below,
I
reference cell E4 in the sheet titled "Summary" right after MATCH. Since
the
formula is in the "Summary" sheet, the formula only needs to go
"MATCH(E4," .
. . but since I was clicking back and forth between worksheets, it added
the
sheet name as well. Unfortunately this was the cause of the problem when I
was using AutoFilter. After adjusting to your formula below, my worksheet
now
works! Thank you, Max, for your help! Greatly appreciated!