On Jul 27, 1:56*pm, Munchkin
wrote:
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?

Hi Munchkin, why not use Excel's Auto Filter?