The cells  I'm copying from contain text only but i need to filter out certain
info.

"H" signifies Holiday
"HD" signifies Half Day Holiday
"S" signifies Sickness

this is the only info i need to print but the other cells in the row may contain
other designations.

So any cell from B7:AF7 may contain other info but i need to copy  only H,HD,S.

At the moment this is done with command buttons.

Hope this makes it clearer.

If you need the file i will mail it to you.