Is anyone able to assist with the following.

I have numerous spreadsheets in a workbook. (the amount always varies
but usually between 40 and 50)

I need to check the contents of B2 against D2, B3 against D3 and s
down to B57 against D57. (for each of the sheets in the workbook). Not
Column B & D are “text”, and case does not matter, only content.

I then require a report (on another sheet called “variance report”
that lists only those cells that differ:

When there is a difference, the report needs to show:

Sheet Name
Column A Value (Date)
Column B Value
Column D Value

I can post a small sample if needed.

Hoping someone is able to assist me with this assignment

Thanks in advance

Regards
Koal

--
koal
-----------------------------------------------------------------------
koala's Profile: http://www.excelforum.com/member.php...fo&userid=1295
View this thread: http://www.excelforum.com/showthread.php?threadid=26679