Matrix and base formation of shape where 1 column and many rows and vice versa
check updated version of link file :
https://www.dropbox.com/s/juga9lffxfqni54/moving%20to%20center.xlsm?dl=0
https://drive.google.com/file/d/0B03s-v1XHNIydzdBem5WTG1jWUE/view?usp=sharing