Hi Domenic

Further to our last discussion, the cells A2 to A12 would not have the items listed in any particular order.
The items indicated as sold would be listed on the sheet, these would change. As a customer purchases an item it would be listed in the column A2 to A12
His sheet which would double as his invoice may only list 1 item or it may have 10 items he purchased.

The sheet names would also, always be different.
As far as VBA goes I haven't a clue what that might be.

best regards
gino