Help - Creating stadium Need data re-arranging

tigerax

New Member
Joined
Apr 18, 2011
Messages
9
<TABLE style="WIDTH: 221pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=293><COLGROUP><COL style="WIDTH: 41pt; mso-width-source: userset; mso-width-alt: 1974" span=2 width=54><COL style="WIDTH: 47pt; mso-width-source: userset; mso-width-alt: 2267" width=62><COL style="WIDTH: 44pt; mso-width-source: userset; mso-width-alt: 2157" width=59><COL style="WIDTH: 48pt" width=64><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; WIDTH: 41pt; HEIGHT: 15pt; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed" height=20 width=54>STND09</TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; WIDTH: 41pt; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed" width=54>AREA09</TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; WIDTH: 47pt; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed" width=62>ROWN09</TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; WIDTH: 44pt; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed" width=59>SNUM09</TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed" class=xl63 width=64>DATA</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed" height=20>NS</TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed">N1</TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed">A</TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed">0001</TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed" class=xl63>P1</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed" height=20>NS</TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed">N1</TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed">A</TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed">0002</TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed" class=xl63>P2</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed" height=20>NS</TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed">N1</TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed">A</TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed">0003</TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed" class=xl63>P3</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed" height=20>NS</TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed">N1</TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed">A</TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed">0004</TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed" class=xl63>P4</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed" height=20>NS</TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed">N1</TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed">B</TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed">0001</TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed" class=xl63>P1</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed" height=20>NS</TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed">N1</TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed">B</TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed">0002</TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed" class=xl63>P2</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed" height=20>NS</TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed">N1</TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed">B</TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed">0003</TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed" class=xl63>P3</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed" height=20>NS</TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed">N1</TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed">B</TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed">0004</TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed" class=xl63>P4
</TD></TR></TBODY></TABLE>
<TABLE style="WIDTH: 221pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=293><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed" height=20>NS</TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed">N2</TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed">A</TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed">0001</TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed" class=xl63>P1</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed" height=20>NS</TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed">N2</TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed">A</TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed">0002</TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed" class=xl63>P2</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed" height=20>NS</TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed">N2</TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed">A</TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed">0003</TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed" class=xl63>P3</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed" height=20>NS</TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed">N2</TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed">A</TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed">0004</TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed" class=xl63>P4</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed" height=20>NS</TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed">N2</TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed">B</TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed">0001</TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed" class=xl63>P1</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed" height=20>NS</TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed">N2</TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed">B</TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed">0002</TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed" class=xl63>P2</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed" height=20>NS</TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed">N2</TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed">B</TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed">0003</TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed" class=xl63>P3</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed" height=20>NS</TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed">N2</TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed">B</TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed">0004</TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed" class=xl63>P4
</TD></TR></TBODY></TABLE>


Hi,

I'm having trouble doing this. I'm creating a stadium in excel and above is 8 seats as an example. The stadium will be visual. I need to convert the data above so it looks more like this.. based upon the area in column B.

So if I select N1 then the data will take out the data from my first sheet and place it in sheet 2.


<TABLE style="WIDTH: 221pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=293><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed" height=20>NS</TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed">N1</TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed">A</TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed"></TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed" class=xl63>P1 P2 P3 P4</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed" height=20>NS</TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed">N1</TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed">B</TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed"></TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed" class=xl63>P1 P2 P3 P4</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed" height=20>

</TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed"></TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed"></TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed"></TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed" class=xl63></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed" height=20></TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed"></TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed"></TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed"></TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed" class=xl63></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed" height=20></TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed"></TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed"></TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed"></TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed" class=xl63></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed" height=20></TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed"></TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed"></TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed"></TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed" class=xl63></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed" height=20></TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed"></TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed"></TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed"></TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed" class=xl63></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed" height=20></TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed"></TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed"></TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed"></TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed" class=xl63>
</TD></TR></TBODY></TABLE>
Any help would be appreciated.
 

Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes
Are you trying to create a layout that mimics on a worksheet the physical arrangement of seats in an actual, real-world stadium? If so, is it a stadium that has the layout on the web for us to look at?

If not, what are you attempting?
 
Upvote 0
Hi... the stadium data I have provided is example but once I can arrange my data correctly it will be used on real stadiums.. i.e football stadium.

I probably didnt explain correctly before. but the column labelled DATA which has different results in.. eg P1 represents a single seat. (P1 means reserved for press)

So NS = Stand name. N1 is an area in that stand. A is the Row, then there is the sequence number in the row and the DATA column is the actual seat.

So I will have lots of data which I will want to look at stand by stand.

<TABLE style="WIDTH: 221pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=293><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #ebe9ed; HEIGHT: 15pt; BORDER-RIGHT-COLOR: #ebe9ed; BORDER-LEFT-COLOR: #ebe9ed" height=20>NS</TD><TD style="BORDER-BOTTOM-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #ebe9ed; BORDER-RIGHT-COLOR: #ebe9ed; BORDER-LEFT-COLOR: #ebe9ed">N1</TD><TD style="BORDER-BOTTOM-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #ebe9ed; BORDER-RIGHT-COLOR: #ebe9ed; BORDER-LEFT-COLOR: #ebe9ed">A</TD><TD style="BORDER-BOTTOM-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #ebe9ed; BORDER-RIGHT-COLOR: #ebe9ed; BORDER-LEFT-COLOR: #ebe9ed"></TD><TD style="BORDER-BOTTOM-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #ebe9ed; BORDER-RIGHT-COLOR: #ebe9ed; BORDER-LEFT-COLOR: #ebe9ed" class=xl63>P1 P2 P3 P4</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #ebe9ed; HEIGHT: 15pt; BORDER-RIGHT-COLOR: #ebe9ed; BORDER-LEFT-COLOR: #ebe9ed" height=20>NS</TD><TD style="BORDER-BOTTOM-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #ebe9ed; BORDER-RIGHT-COLOR: #ebe9ed; BORDER-LEFT-COLOR: #ebe9ed">N1</TD><TD style="BORDER-BOTTOM-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #ebe9ed; BORDER-RIGHT-COLOR: #ebe9ed; BORDER-LEFT-COLOR: #ebe9ed">B</TD><TD style="BORDER-BOTTOM-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #ebe9ed; BORDER-RIGHT-COLOR: #ebe9ed; BORDER-LEFT-COLOR: #ebe9ed"></TD><TD style="BORDER-BOTTOM-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #ebe9ed; BORDER-RIGHT-COLOR: #ebe9ed; BORDER-LEFT-COLOR: #ebe9ed" class=xl63>P1 P2 P3 P4</TD></TR></TBODY></TABLE>
<TABLE style="WIDTH: 221pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=293><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #ebe9ed; HEIGHT: 15pt; BORDER-RIGHT-COLOR: #ebe9ed; BORDER-LEFT-COLOR: #ebe9ed" height=20>NS</TD><TD style="BORDER-BOTTOM-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #ebe9ed; BORDER-RIGHT-COLOR: #ebe9ed; BORDER-LEFT-COLOR: #ebe9ed">N1</TD><TD style="BORDER-BOTTOM-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #ebe9ed; BORDER-RIGHT-COLOR: #ebe9ed; BORDER-LEFT-COLOR: #ebe9ed">A</TD><TD style="BORDER-BOTTOM-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #ebe9ed; BORDER-RIGHT-COLOR: #ebe9ed; BORDER-LEFT-COLOR: #ebe9ed"></TD><TD style="BORDER-BOTTOM-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #ebe9ed; BORDER-RIGHT-COLOR: #ebe9ed; BORDER-LEFT-COLOR: #ebe9ed" class=xl63>P1 P2 P3 P4</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #ebe9ed; HEIGHT: 15pt; BORDER-RIGHT-COLOR: #ebe9ed; BORDER-LEFT-COLOR: #ebe9ed" height=20>NS</TD><TD style="BORDER-BOTTOM-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #ebe9ed; BORDER-RIGHT-COLOR: #ebe9ed; BORDER-LEFT-COLOR: #ebe9ed">N1</TD><TD style="BORDER-BOTTOM-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #ebe9ed; BORDER-RIGHT-COLOR: #ebe9ed; BORDER-LEFT-COLOR: #ebe9ed">B</TD><TD style="BORDER-BOTTOM-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #ebe9ed; BORDER-RIGHT-COLOR: #ebe9ed; BORDER-LEFT-COLOR: #ebe9ed"></TD><TD style="BORDER-BOTTOM-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #ebe9ed; BORDER-RIGHT-COLOR: #ebe9ed; BORDER-LEFT-COLOR: #ebe9ed" class=xl63>P1 P2 P3 P4</TD></TR></TBODY></TABLE>
<TABLE style="WIDTH: 221pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=293><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #ebe9ed; HEIGHT: 15pt; BORDER-RIGHT-COLOR: #ebe9ed; BORDER-LEFT-COLOR: #ebe9ed" height=20>NS</TD><TD style="BORDER-BOTTOM-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #ebe9ed; BORDER-RIGHT-COLOR: #ebe9ed; BORDER-LEFT-COLOR: #ebe9ed">N1</TD><TD style="BORDER-BOTTOM-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #ebe9ed; BORDER-RIGHT-COLOR: #ebe9ed; BORDER-LEFT-COLOR: #ebe9ed">A</TD><TD style="BORDER-BOTTOM-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #ebe9ed; BORDER-RIGHT-COLOR: #ebe9ed; BORDER-LEFT-COLOR: #ebe9ed"></TD><TD style="BORDER-BOTTOM-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #ebe9ed; BORDER-RIGHT-COLOR: #ebe9ed; BORDER-LEFT-COLOR: #ebe9ed" class=xl63>P1 P2 P3 P4</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #ebe9ed; HEIGHT: 15pt; BORDER-RIGHT-COLOR: #ebe9ed; BORDER-LEFT-COLOR: #ebe9ed" height=20>NS</TD><TD style="BORDER-BOTTOM-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #ebe9ed; BORDER-RIGHT-COLOR: #ebe9ed; BORDER-LEFT-COLOR: #ebe9ed">N1</TD><TD style="BORDER-BOTTOM-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #ebe9ed; BORDER-RIGHT-COLOR: #ebe9ed; BORDER-LEFT-COLOR: #ebe9ed">B</TD><TD style="BORDER-BOTTOM-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #ebe9ed; BORDER-RIGHT-COLOR: #ebe9ed; BORDER-LEFT-COLOR: #ebe9ed"></TD><TD style="BORDER-BOTTOM-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #ebe9ed; BORDER-RIGHT-COLOR: #ebe9ed; BORDER-LEFT-COLOR: #ebe9ed" class=xl63>P1 P2 P3 P4</TD></TR></TBODY></TABLE>

So the last bit of text with the P1 P2 P3 P4 P5 P6 P7 is one Row of Seats.

In the excel spreadsheet once all the data is there it should look like a birdseye view of a stand in a stadium. It's only the start of my project.
 
Upvote 0

Forum statistics

Threads
1,223,152
Messages
6,170,388
Members
452,323
Latest member
GoJones

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top