Hi , can please anybody help me with the macro. I explained every
thing in an excel sheet which you can see in the link below. As I
thought its better to put my question on a sheet to explain clearly.

http://www.savefile.com/files/1511153