Macro for my work.....

  • Thread starter Thread starter cdmeyer01
  • Start date Start date
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.
 
Consider putting all the stuff in one sheet. There is much lost by separating the data by
the alphabet, and much is lost. Take a look at "Data across multiple sheets" at
www.smokeylake.com/excel/excel_truths.htm.

--
Earl Kiosterud
www.smokeylake.com

Note: Top-posting has been the norm here.
Some folks prefer bottom-posting.
But if you bottom-post to a reply that's
already top-posted, the thread gets messy.
When in Rome...
 
Back
Top