I'm having a very hard time with this one. Probably because I'm new, but any help would be appreciated.

I am attempting to copy a range of cells. I need the range to start at A2 and go down and copy all used rows until the next cell in column A with text. I then need this to paste to another sheet. I need this to repeat with each set of data on the sheet and stop when it sees the word "Total" in Column A.

I've attached the sheet so you can see what I mean. Column A is the supervisor, and column B is the employee. I need to copy the rows for each supervisor and the employees that report to them and paste it to another sheet.

Please let me know if you have any idea how to select the cells using VBA.

upload for help.xlsm