have you tried the Autofilter? that's exactly what it can do for you

"Munchkin" wrote in message
...
My spreadsheet shows 6 different department's file records. Colum J
specifies Dept A, Dept B, Dept C, etc. I'd like to create a macro button
for each Dept that would show just thier records and hide the others, but
I
don't know how. Can anyone help?