Problem trying to generate a report with a formula billosullivan[ at ]gmail.com 30.09.2006 16:45:27 Hi all, I'm trying to generate a report and am having trouble with the formula. Any help would be greatly appreciated. Here is what I need to be able to do. I have 6 worksheets in the same workbook, worksheets 1 - 5 are identically laid out and the sixth is the one I want to generate a report on. Column A is for peoples names, Columns B-H are labelled Monday - Sunday on top. If the person in A2 is working on Monday then I would type "Yes" into B2 and so on for the rest of the week and for the rest of the rows also. It is the case that not everyone will work everyday, therefore I want the report page to be a kind of roster report detailing who is working on what days. The report page is laid out as follows. Weekdays in A1-G1. What I want to do is have worksheets 1-5 checked and for instance bring back everyone's name who is working on Monday to worksheet 6 A2-XX (XX being whatever the last individuals name working that day is) I would ideally like the names to be sequential as there are 40 people that could potentially be working but only 15-20 may work on the Monday (I don't want the report to be spread over 41 rows if possible) I hope I have explained this well enough. Any help you might be able to give at all would really be appreciated! I've started pulling my hair out trying it at this stage : -) Thanks again! Bill