You can see from my comments at the end of Post #9 in this thread:
http://www.excelforum.com/excel-form...-solution.html
that there is something strange with the cells that appear to be empty in the file that the OP provided in Post #3.
I eventually solved the problem, but I was wondering if anyone can shed any light on the behaviour of the empty cells for the first material.
Pete
Bookmarks