Housekeeping payroll that pulls rows of information to different sheets

Hi everybody,

I'm sorry if this question has been answered, but after a long search I've been unable to find a solution to my dilemma. Which is..

I have a spreadsheet with four columns pertaining to the housekeepers payroll. The columns are (in this order): 'Units' 'Departure Dates' 'Team' 'Rates'.

I'm trying to pull information from this sheet onto other sheets within the workbook based off of the cleaning team named in column 3 (Team). So, if for example, team AM had 14 cleans that week then they would have 14 rows associated with them. I would like all 14 of those rows to be pulled onto their payroll sheet. As it is now I have to copy and paste the cleans associated with each team on to the corresponding payroll sheet for that person. Could someone please help me figure out how to do this? If so, does anyone know how I could have those cells automatically insert themselves into the corresponding spreadsheet without altering the layout of the payroll sheet? Each sheet has a template established that I would like the information to insert itself within, regardless of how many rows of information need to be pulled.

Thank you for reading!

Thanks for the help so far. Attached are examples of the main spreadsheet containing information for all cleaning teams, as well as one sheet that depicts where I would like all information pertaining to that team to go.

forum payroll example..xlsx

Humm. Maybe that is another element that should have been explained in my initial post. The sheet 'assignments' pulls information from our online database, where cleans are assigned to cleaning teams using abbreviations. Example: AM is Ana and Maria. So I would need for anything on the 'assignments' sheet to pull rows with AM in the third column over to both Ana and Maria's payroll sheets. From there the pay associated with the cleans are added up and divided in half- which I know how to do. It's just a matter of getting them to automatically go to Ana and Maria's sheets. I've modified the example so that it is hopefully clearer now. The third sheet, 'Example of what I'm trying for' shows what I would like the program to automatically return after the data is pasted into 'assignments'. I hope that helps clarify things- sorry for the confusion.

forum payroll example 2.xlsx

Well I've no doubt gotten in way over my head. I pasted that code in and followed the steps provided. When I run the macro I get "Runtime error '1004'' No cells were found. I've tried interpreting the code to see what adjustments might need to be made but I'm not having any luck.

Yeah I did that. I also made sure that the name of the spreadsheet 'assignments' corresponds correctly with the way it is spelled out in your code.

Sorry for the delay- thanks for taking a look!

PAYROLL MASTER (created 1.27.13).xlsm

Wow. Okay, well I've appreciated your help so far but no need to be condescending. When I was testing it there was data entered into the columns on the 'cleaning assignments' sheet. I deleted it all when I sent it to you. You asked me to send you a mockup. Maybe I should have realized that the mockup needed to include every sheet in the workbook and not just those relevant to the question being asked. Like I said in my earlier post- I clearly got myself in over my head and had I known that it would involve code that I would need someone else to do for me, I wouldn't have asked for it. Thanks again for the help though.