Try this
http://www.rondebruin.nl/copy2.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl



"y_not" wrote in message ...

I have a workbook containing 20 sheets. Each sheet is identical (used up
to 80 rows, columns A to W) and is used to record peoples working hours
each day of the week in different departments.
Could someone please tell me how to consolidate all the data on the 20
sheets into a single sheet so that this will allow me to see how many
hours were worked per day by each person.
I don't know if these are complications - each sheet uses 80 rows but
some of these will be blank rows; the same applies to the columns. In
some cases people will have worked in different departments during the
week so thier names will apppear more than once.

I hope that this all makes sense and thank you for taking the time to
read it

Tony


--
y_not
------------------------------------------------------------------------
y_not's Profile: http://www.excelforum.com/member.php...o&userid=19947
View this thread: http://www.excelforum.com/showthread...hreadid=345771