Pay Reporting

Hi eMJay,

I'm sure I can help you, but i'm having a little trouble following some of the logic in 'Report'

Where does POS# come from? Designation? Position Title? looks like maybe employee name was inadvertently not turned to bogus data on 'P01' but I assume that comes from column D, and employee # is column C, correct? What is going on with the blank values, like A14, C14 and E13? designing logical formulas around inconsistent data like that gets more challenging in a hurry... Is there something else you can tell me about what it means to have a blank employee ID that would help me determine what values should populate in G:L?

Where did J15 and k12 come from? the 365.21 under "Rest.Allo" and the 487.55 in "Com. Pens" don't appear in P01... Are those logical entries?

Is "Wage Type" consistent such that we can code logic based on those #'s? Are you ok with adding a 'helper' row to tie "Rent" to "3920"? this could be as simple as typing 3920 in cell H5 and making the text grey...

The most challenging part is probably the last part of the request. Are there likely to be varying numbers of entries for each department? i.e. in future pay periods do you expect you may have more than one entry in 14440? If so, you'll need to insert / delete rows each month as needed. This can be automated with VBA, but my skills in that department are pretty limited. I can, however set up some conditional formatting so that rows on 'P01' which are not represented in 'Report' turn red, so that will flag you to add rows as needed...

also - can employees appear in multiple departments... i.e. will you ever see Joe Bloggs in both 14440 and 14441?