C
cdmeyer01
Can anyone give me some help with a problem I am having in my payroll
packet at work - the explanation is quite long and involved, but here
goes. My payroll packet has different lettered sheets, one for each
letter of the alphabet. I input 2 weeks worth of time in these sheets
and I use data validation (data stored in another sheet) to input the
names and SS#'s into these sheets for each payroll. I have a "summary
sheet" at the end of the workbook that summarizes each entry from the
individual sheets (namely Direct Labor,Indirect Labor (Shop),
Holiday,Vacation,Total Hours, O.T.,Hrs.+ O.T. Can I write a macro
that
will transfer hours from the individual lettered sheets along with
name and Social Security Number? Any help on the proper macro will be
appreciated and / or just help concerning the procedure to do this in
excel will be appreciated.
Carl
packet at work - the explanation is quite long and involved, but here
goes. My payroll packet has different lettered sheets, one for each
letter of the alphabet. I input 2 weeks worth of time in these sheets
and I use data validation (data stored in another sheet) to input the
names and SS#'s into these sheets for each payroll. I have a "summary
sheet" at the end of the workbook that summarizes each entry from the
individual sheets (namely Direct Labor,Indirect Labor (Shop),
Holiday,Vacation,Total Hours, O.T.,Hrs.+ O.T. Can I write a macro
that
will transfer hours from the individual lettered sheets along with
name and Social Security Number? Any help on the proper macro will be
appreciated and / or just help concerning the procedure to do this in
excel will be appreciated.
Carl