Automation for attendance sheets

[Guest]

Hi!

For a novice at macros, I need some help.

I have a spreadsheet with employee names, their ID's and their work shifts
noted in 'D'(day) 'N' (night) or 'O' (Off). I need to create some buttons so
that the person using the sheet can quickly fire prints of the particular
day's employees working on the particular shift. For eg., for 05/10/04,
employees on Night shift. I am currently using a autofilter, for the
particular day, copying the data to another sheet, applying the formatting
required, and then taking printouts.

There must be a way to automate this in excel .

The header for the particular days shift MUST contain (1) the day, & (2) the
shift detail (Day/Night) depending on the selection.

Can someone help me on this?

Thank you in advance

Neil

 

[Dave Peterson]

Is there a reason the user couldn't just print after applying the filter to show
the records?

(Not sure what formatting you go through, though.)

If you need to mechanize your routine, you may want to try recording a macro
when you do it manually. Then post back with any questions you have when you
try to generalize it.