Hi Everyone,
I am trying to find a way to automatically pull data from a payroll report over to a summary and calculation sheet. The report generates like the attached image. Basically I would like to be able to find Employee A (and/or department amounts) and pull over things like total pay, social security amount, total contributions excreta. The number of rows associated with each employee may change as may the number of employees, excreta. Thus, I would like to use a lookup of some sort or something similar. However, I am not sure the best way to do this as the data in multiple rows refers to each person and the report may not have the same items each month.
Does anyone know a good way to accomplish this?
Thanks in advance!
PR example table.JPG
Bookmarks