Something like this?
If the format changes then the vba code needs to be changed as well...
I have created a 'Test Sheet' so that the 'Original Sheet' can be used to compare with the 'Test Sheet'.
Sid
Edit:
I tested it again... so don't forget to put perfume on the card....![]()




Reply With Quote