Macro in attached.
Sheet2 has consolidated data and Sheet3 copy of original Sheet2.
HTH
+-------------------------------------------------------------------+
|Filename: Copy of My work.zip |
|Download:
http://www.excelforum.com/attachment.php?postid=5129 |
+-------------------------------------------------------------------+
--
Toppers
------------------------------------------------------------------------
Toppers's Profile:
http://www.excelforum.com/member.php...o&userid=30076
View this thread:
http://www.excelforum.com/showthread...hreadid=566245