Macro for my work.....

[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.

 

[Earl Kiosterud]

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...