transpose neighbor list

6
Transpose neighbors from horizontal to vertical Intructions: - Inputs in sheet "Horizontal" - Click to "Transpose" button in sheet "Marco" - Result in sheet "To Vertical" TRANSPOSE

Upload: vayudhar-mogili

Post on 15-Sep-2015

215 views

Category:

Documents


2 download

DESCRIPTION

Transpose rows to columns macro

TRANSCRIPT

MarcoTranspose neighbors from horizontal to verticalIntructions: - Inputs in sheet "Horizontal"- Click to "Transpose" button in sheet "Marco"- Result in sheet "To Vertical"

TRANSPOSE

HorizontalCellNeighbor 01Neighbor 02Neighbor 03Neighbor 04Neighbor 05Neighbor 06Neighbor 07Neighbor 08Neighbor 09Neighbor 10Neighbor 11Neighbor 12Neighbor 13Neighbor 14Neighbor 15Neighbor 16Neighbor 17Neighbor 18Neighbor 19Neighbor 20Neighbor 21Neighbor 22Neighbor 23Neighbor 24Neighbor 25Neighbor 26Neighbor 27Neighbor 28Neighbor 29Neighbor 30Neighbor 31Neighbor 32

To VerticalCellNeighbor