Macro for creating + naming sheets, migrating cells : v2

[Michelle_112]

Hi All,

Got a bit of a challenge here: I've decided to re-word my original post as it was too complicated. So here goes version 2

I've got a spreadsheet full of servers names and specifications for each server (around 1 - 200 names on the source sheet). Sample attached.. Altogether I have about 5 source sheets that I need to do this for..amounting to about 600 servers..
This job im trying to get into a macro is quite manual + labour intensive job which later on may need to have potential changes to the choice of original source data -which manually would make it really time consuming.

Background
If you look at example I have below. Each server has specific data
eg. Room, Environment, Operating system (O/S)

All data for a single row, corresponds to a particular server.

Eg. First one there is a server name "AU2012CPE350" its switch name is XYZD001, its in Room A and 'Environment' is PROD. (as in Row one)

This particular source sheet has up to about 50 columns of different info.

My objective is to do the following:

Step 1) Get specific data ie. data per server , migrated to a 'new worksheet' within the same workbook.

Step 2) Have the worksheet renamed to the 'server name eg. AU2012CPE350" - if the data being migrated is for that server.

Step 3) In relation to the 'format' of the destination data in the new sheet..
Want to be able to capture each source data in a specific destination cell - to form a sort of a 'certificate'.
Overall the purpose is to have a single point of information for server issues.

Step4) To start from 'Step 1 thru to Step 3" again for the next Row / server name eg. that would be AU2012CPE352 -->and to continue creating sheets, migrating data, till the end of the list.

Eg. Source sheet - Examples of source data I've only included a couple- ie. room, environment, O/S.

<link rel="File-List" href="file:///C:%5CDOCUME%7E1%5CADMINI%7E1%5CLOCALS%7E1%5CTemp%5Cmsohtml1%5C01%5Cclip_filelist.xml"><!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:PunctuationKerning/> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent> <w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText> <w:Compatibility> <w:BreakWrappedTables/> <w:SnapToGridInCell/> <w:WrapTextWithPunct/> <w:UseAsianBreakRules/> <w:DontGrowAutofit/> </w:Compatibility> <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel> </w:WordDocument> </xml><![endif]--><!--[if gte mso 9]><xml> <w:LatentStyles DefLockedState="false" LatentStyleCount="156"> </w:LatentStyles> </xml><![endif]--><style> <!-- /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-parent:""; margin:0cm; margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:9.0pt; font-family:"Times New Roman"; mso-fareast-font-family:"Times New Roman"; letter-spacing:-1.0pt; mso-bidi-font-weight:bold;} @page Section1 {size:612.0pt 792.0pt; margin:72.0pt 90.0pt 72.0pt 90.0pt; mso-header-margin:36.0pt; mso-footer-margin:36.0pt; mso-paper-source:0;} div.Section1 {page:Section1;} --> </style><!--[if gte mso 10]> <style> /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin:0cm; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman"; mso-ansi-language:#0400; mso-fareast-language:#0400; mso-bidi-language:#0400;} </style> <![endif]--> <table class="MsoNormalTable" style="width: 523.85pt; margin-left: 5.15pt; border-collapse: collapse;" width="698" border="0" cellpadding="0" cellspacing="0"> <tbody><tr style="height: 12.75pt;"> <td style="border: 1pt solid windowtext; padding: 0cm 5.4pt; width: 167pt; height: 12.75pt;" width="223" nowrap="nowrap"> A<o></o>
</td> <td style="border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; border-width: 1pt 1pt 1pt medium; padding: 0cm 5.4pt; background: rgb(204, 255, 255) none repeat scroll 0% 0%; width: 56.8pt; -moz-background-clip: border; -moz-background-origin: padding; -moz-background-inline-policy: continuous; height: 12.75pt;" width="76" nowrap="nowrap">

B<o></o>​

</td> <td style="border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; border-width: 1pt 1pt 1pt medium; padding: 0cm 5.4pt; background: rgb(204, 255, 255) none repeat scroll 0% 0%; width: 48pt; -moz-background-clip: border; -moz-background-origin: padding; -moz-background-inline-policy: continuous; height: 12.75pt;" width="64" nowrap="nowrap">

C<o></o>​

</td> <td style="border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; border-width: 1pt 1pt 1pt medium; padding: 0cm 5.4pt; background: rgb(204, 255, 255) none repeat scroll 0% 0%; width: 52.2pt; -moz-background-clip: border; -moz-background-origin: padding; -moz-background-inline-policy: continuous; height: 12.75pt;" width="70" nowrap="nowrap">

D<o></o>​

</td> <td style="border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; border-width: 1pt 1pt 1pt medium; padding: 0cm 5.4pt; background: rgb(204, 255, 255) none repeat scroll 0% 0%; width: 52.2pt; -moz-background-clip: border; -moz-background-origin: padding; -moz-background-inline-policy: continuous; height: 12.75pt;" width="70" nowrap="nowrap">

E<o></o>​

</td> <td style="border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; border-width: 1pt 1pt 1pt medium; padding: 0cm 5.4pt; background: rgb(255, 255, 153) none repeat scroll 0% 0%; width: 48pt; -moz-background-clip: border; -moz-background-origin: padding; -moz-background-inline-policy: continuous; height: 12.75pt;" width="64" nowrap="nowrap">

F<o></o>​

</td> <td style="border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; border-width: 1pt 1pt 1pt medium; padding: 0cm 5.4pt; background: rgb(255, 255, 153) none repeat scroll 0% 0%; width: 48pt; -moz-background-clip: border; -moz-background-origin: padding; -moz-background-inline-policy: continuous; height: 12.75pt;" width="64" nowrap="nowrap">

G<o></o>​

</td> <td style="border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; border-width: 1pt 1pt 1pt medium; padding: 0cm 5.4pt; background: rgb(255, 255, 153) none repeat scroll 0% 0%; width: 51.65pt; -moz-background-clip: border; -moz-background-origin: padding; -moz-background-inline-policy: continuous; height: 12.75pt;" width="69" nowrap="nowrap">

H<o></o>​

</td> </tr> <tr style="height: 68.25pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0cm 5.4pt; background: rgb(255, 128, 128) none repeat scroll 0% 0%; width: 167pt; -moz-background-clip: border; -moz-background-origin: padding; -moz-background-inline-policy: continuous; height: 68.25pt;" width="223"> Server Name<o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; background: rgb(204, 255, 255) none repeat scroll 0% 0%; width: 56.8pt; -moz-background-clip: border; -moz-background-origin: padding; -moz-background-inline-policy: continuous; height: 68.25pt;" width="76">

Fabric A switch name
<o></o>​

</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; background: rgb(204, 255, 255) none repeat scroll 0% 0%; width: 48pt; -moz-background-clip: border; -moz-background-origin: padding; -moz-background-inline-policy: continuous; height: 68.25pt;" width="64">

Room <o></o>​

</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; background: rgb(204, 255, 255) none repeat scroll 0% 0%; width: 52.2pt; -moz-background-clip: border; -moz-background-origin: padding; -moz-background-inline-policy: continuous; height: 68.25pt;" width="70">

Environment
<o></o>​

</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; background: rgb(204, 255, 255) none repeat scroll 0% 0%; width: 52.2pt; -moz-background-clip: border; -moz-background-origin: padding; -moz-background-inline-policy: continuous; height: 68.25pt;" width="70">

O/S<o></o>​

</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; background: rgb(255, 255, 153) none repeat scroll 0% 0%; width: 48pt; -moz-background-clip: border; -moz-background-origin: padding; -moz-background-inline-policy: continuous; height: 68.25pt;" width="64">

Fabric B
Switch Name<o></o>​

</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; background: rgb(255, 255, 153) none repeat scroll 0% 0%; width: 48pt; -moz-background-clip: border; -moz-background-origin: padding; -moz-background-inline-policy: continuous; height: 68.25pt;" width="64">

Room
<o></o>​

</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; background: rgb(255, 255, 153) none repeat scroll 0% 0%; width: 51.65pt; -moz-background-clip: border; -moz-background-origin: padding; -moz-background-inline-policy: continuous; height: 68.25pt;" width="69">

Environment..<o></o>​

</td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0cm 5.4pt; width: 167pt; height: 12.75pt;" valign="bottom" width="223" nowrap="nowrap"> AU2012CPE350<o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 56.8pt; height: 12.75pt;" valign="bottom" width="76" nowrap="nowrap"><o></o>XYZD001
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 48pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap"> <o></o>A
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 52.2pt; height: 12.75pt;" valign="bottom" width="70" nowrap="nowrap"> <o></o>PROD
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 52.2pt; height: 12.75pt;" valign="bottom" width="70" nowrap="nowrap"> <o></o>WINDOWS
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 48pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap"> <o></o>ABCD001 </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 48pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap"> <o></o>A
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 51.65pt; height: 12.75pt;" valign="bottom" width="69" align="center" nowrap="nowrap"> <o></o>TEST
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0cm 5.4pt; width: 167pt; height: 12.75pt;" valign="bottom" width="223" nowrap="nowrap"> AU2012CPE352
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 56.8pt; height: 12.75pt;" valign="bottom" width="76" nowrap="nowrap"> <o></o>XYZD001 </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 48pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap"> <o></o>A
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 52.2pt; height: 12.75pt;" valign="bottom" width="70" nowrap="nowrap"> <o></o>PROD </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 52.2pt; height: 12.75pt;" valign="bottom" width="70" nowrap="nowrap"> <o></o> <o></o>WINDOWS </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 48pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap"> <o></o>ABCD001 </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 48pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap"> <o></o>A
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 51.65pt; height: 12.75pt;" valign="bottom" width="69" align="center" nowrap="nowrap"> <o></o>TEST </td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0cm 5.4pt; width: 167pt; height: 12.75pt;" valign="bottom" width="223" nowrap="nowrap"> AU2012CPE353
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 56.8pt; height: 12.75pt;" valign="bottom" width="76" nowrap="nowrap"> <o></o>XYZD001 </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 48pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap"> <o></o>A
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 52.2pt; height: 12.75pt;" valign="bottom" width="70" nowrap="nowrap"> <o></o>PROD </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 52.2pt; height: 12.75pt;" valign="bottom" width="70" nowrap="nowrap"> <o></o> <o></o>WINDOWS </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 48pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap"> <o></o>ABCD001 </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 48pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap"> A
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 51.65pt; height: 12.75pt;" valign="bottom" width="69" align="center" nowrap="nowrap"> TEST </td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0cm 5.4pt; width: 167pt; height: 12.75pt;" valign="bottom" width="223" nowrap="nowrap"> AU2012CPE354
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 56.8pt; height: 12.75pt;" valign="bottom" width="76" nowrap="nowrap"> <o></o>XYZD001 </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 48pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap"> <o></o>B
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 52.2pt; height: 12.75pt;" valign="bottom" width="70" nowrap="nowrap"> <o></o>PROD </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 52.2pt; height: 12.75pt;" valign="bottom" width="70" nowrap="nowrap"> <o></o> <o></o>WINDOWS </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 48pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap"> <o></o>ABCD001 </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 48pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap"> <o></o>CPU rm
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 51.65pt; height: 12.75pt;" valign="bottom" width="69" align="center" nowrap="nowrap"> <o></o>DEV
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0cm 5.4pt; width: 167pt; height: 12.75pt;" valign="bottom" width="223" nowrap="nowrap"> AU2012CPE357<o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 56.8pt; height: 12.75pt;" valign="bottom" width="76" nowrap="nowrap"> <o></o>XYZD001 </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 48pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap"> B
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 52.2pt; height: 12.75pt;" valign="bottom" width="70" nowrap="nowrap"> <o></o>DEV
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 52.2pt; height: 12.75pt;" valign="bottom" width="70" nowrap="nowrap"> <o></o>LINUX
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 48pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap"> <o></o>ABCD001 </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 48pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap"> <o></o>B
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 51.65pt; height: 12.75pt;" valign="bottom" width="69" align="center" nowrap="nowrap"> TEST
<o></o> </td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0cm 5.4pt; width: 167pt; height: 12.75pt;" valign="bottom" width="223" nowrap="nowrap"> AU2012CPE358<o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 56.8pt; height: 12.75pt;" valign="bottom" width="76" nowrap="nowrap"> <o></o>XYZD001 </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 48pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap"> <o></o>B
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 52.2pt; height: 12.75pt;" valign="bottom" width="70" nowrap="nowrap"> <o></o>DEV </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 52.2pt; height: 12.75pt;" valign="bottom" width="70" nowrap="nowrap"> <o></o>LINUX </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 48pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap"> <o></o>ABCD002 </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 48pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap"> <o></o>B
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 51.65pt; height: 12.75pt;" valign="bottom" width="69" align="center" nowrap="nowrap"> DEV
</td></tr><tr style="height: 12.75pt;"><td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0cm 5.4pt; width: 167pt; height: 12.75pt;" valign="bottom" width="223" nowrap="nowrap">U2012CTE330<o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 56.8pt; height: 12.75pt;" valign="bottom" width="76" nowrap="nowrap"> <o></o>XYZD001 </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 48pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap"> <o></o>XYZ
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 52.2pt; height: 12.75pt;" valign="bottom" width="70" nowrap="nowrap"> <o></o>DEV </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 52.2pt; height: 12.75pt;" valign="bottom" width="70" nowrap="nowrap"> <o></o>LINUX </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 48pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap"> <o></o>ABCD002 </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 48pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap"> B
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 51.65pt; height: 12.75pt;" valign="bottom" width="69" align="center" nowrap="nowrap"> <o></o>TEST </td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0cm 5.4pt; width: 167pt; height: 12.75pt;" valign="bottom" width="223" nowrap="nowrap"> AU2012CTE331<o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 56.8pt; height: 12.75pt;" valign="bottom" width="76" nowrap="nowrap"> <o></o>XYZD002 </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 48pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap"> <o></o>XYZ
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 52.2pt; height: 12.75pt;" valign="bottom" width="70" nowrap="nowrap"> <o></o>DEV </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 52.2pt; height: 12.75pt;" valign="bottom" width="70" nowrap="nowrap"> <o></o>LINUX </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 48pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap"> ABCD002 </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 48pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap"> <o></o>C
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 51.65pt; height: 12.75pt;" valign="bottom" width="69" align="center" nowrap="nowrap"> DEV
<o></o> </td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0cm 5.4pt; width: 167pt; height: 12.75pt;" valign="bottom" width="223" nowrap="nowrap"> AU2012SPE046<o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 56.8pt; height: 12.75pt;" valign="bottom" width="76" nowrap="nowrap"> <o></o>XYZD002 </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 48pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap"> <o></o>XYZ
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 52.2pt; height: 12.75pt;" valign="bottom" width="70" nowrap="nowrap"> <o></o>TEST
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 52.2pt; height: 12.75pt;" valign="bottom" width="70" nowrap="nowrap"> <o></o>VMWARE
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 48pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap"> <o></o>ABCD002 </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 48pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap"> <o></o>C
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 51.65pt; height: 12.75pt;" valign="bottom" width="69" align="center" nowrap="nowrap"> DEV
<o></o> </td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0cm 5.4pt; width: 167pt; height: 12.75pt;" valign="bottom" width="223" nowrap="nowrap"> AU2012SPE135<o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 56.8pt; height: 12.75pt;" valign="bottom" width="76" nowrap="nowrap"> <o></o>XYZD002 </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 48pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap"> <o></o>XYZ
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 52.2pt; height: 12.75pt;" valign="bottom" width="70" nowrap="nowrap"> <o></o>TEST </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 52.2pt; height: 12.75pt;" valign="bottom" width="70" nowrap="nowrap"> <o></o>VMWARE </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 48pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap"> <o></o>ABCD002 </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 48pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap"> <o></o>C
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 51.65pt; height: 12.75pt;" valign="bottom" width="69" align="center" nowrap="nowrap"> DEV </td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0cm 5.4pt; width: 167pt; height: 12.75pt;" valign="bottom" width="223" nowrap="nowrap"> AU2012SPE186<o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 56.8pt; height: 12.75pt;" valign="bottom" width="76" nowrap="nowrap"> <o></o>XYZD002 </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 48pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap"> <o></o>A
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 52.2pt; height: 12.75pt;" valign="bottom" width="70" nowrap="nowrap"> <o></o>TEST </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 52.2pt; height: 12.75pt;" valign="bottom" width="70" nowrap="nowrap"> <o></o>VMWARE </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 48pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap"> <o></o>ABCD002 </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 48pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap"> <o></o>C
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 51.65pt; height: 12.75pt;" valign="bottom" width="69" align="center" nowrap="nowrap"> PROD
<o></o> </td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0cm 5.4pt; width: 167pt; height: 12.75pt;" valign="bottom" width="223" nowrap="nowrap"> AU2012SPE187<o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 56.8pt; height: 12.75pt;" valign="bottom" width="76" nowrap="nowrap"> <o></o>XYZD002 </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 48pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap"> <o></o>A
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 52.2pt; height: 12.75pt;" valign="bottom" width="70" nowrap="nowrap"> <o></o>TEST </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 52.2pt; height: 12.75pt;" valign="bottom" width="70" nowrap="nowrap"> <o></o>VMWARE </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 48pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap"> <o></o>ABCD002 </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 48pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap"> <o></o>CPU rm
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 51.65pt; height: 12.75pt;" valign="bottom" width="69" align="center" nowrap="nowrap"> PROD
<o></o> </td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0cm 5.4pt; width: 167pt; height: 12.75pt;" valign="bottom" width="223" nowrap="nowrap"> AU2012SPE190<o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 56.8pt; height: 12.75pt;" valign="bottom" width="76" nowrap="nowrap"> <o></o>XYZD002 </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 48pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap"> <o></o>A
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 52.2pt; height: 12.75pt;" valign="bottom" width="70" nowrap="nowrap"> <o></o>TEST </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 52.2pt; height: 12.75pt;" valign="bottom" width="70" nowrap="nowrap"> <o></o>VMWARE </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 48pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap"> <o></o>ABCD003 </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 48pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap"> <o></o>CPU rm
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 51.65pt; height: 12.75pt;" valign="bottom" width="69" align="center" nowrap="nowrap"> DEV </td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0cm 5.4pt; width: 167pt; height: 12.75pt;" valign="bottom" width="223" nowrap="nowrap"> AU2012SPE191<o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 56.8pt; height: 12.75pt;" valign="bottom" width="76" nowrap="nowrap"> <o></o>XYZD002 </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 48pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap"> <o></o>B
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 52.2pt; height: 12.75pt;" valign="bottom" width="70" nowrap="nowrap"> <o></o>TEST </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 52.2pt; height: 12.75pt;" valign="bottom" width="70" nowrap="nowrap"> <o></o>UNIX
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 48pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap"> <o></o>ABCD003 </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 48pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap"> <o></o>CPU rm
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 51.65pt; height: 12.75pt;" valign="bottom" width="69" align="center" nowrap="nowrap"> DEV </td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0cm 5.4pt; width: 167pt; height: 12.75pt;" valign="bottom" width="223" nowrap="nowrap"> AU2012SPE192<o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 56.8pt; height: 12.75pt;" valign="bottom" width="76" nowrap="nowrap"> <o></o>XYZD002 </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 48pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap"> <o></o>B
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 52.2pt; height: 12.75pt;" valign="bottom" width="70" nowrap="nowrap"> <o></o>TEST </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 52.2pt; height: 12.75pt;" valign="bottom" width="70" nowrap="nowrap"> <o></o>UNIX </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 48pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap"> <o></o>ABCD003 </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 48pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap"> <o></o>D
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 51.65pt; height: 12.75pt;" valign="bottom" width="69" align="center" nowrap="nowrap"> DEV </td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0cm 5.4pt; width: 167pt; height: 12.75pt;" valign="bottom" width="223" nowrap="nowrap"> AU2012SPE205<o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 56.8pt; height: 12.75pt;" valign="bottom" width="76" nowrap="nowrap"> <o></o>XYZD002 </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 48pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap"> <o></o>C
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 52.2pt; height: 12.75pt;" valign="bottom" width="70" nowrap="nowrap"> <o></o>DEV
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 52.2pt; height: 12.75pt;" valign="bottom" width="70" nowrap="nowrap"> <o></o>UNIX </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 48pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap"> <o></o>ABCD003 </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 48pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap"> <o></o>D
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 51.65pt; height: 12.75pt;" valign="bottom" width="69" align="center" nowrap="nowrap"> DEV </td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0cm 5.4pt; width: 167pt; height: 12.75pt;" valign="bottom" width="223" nowrap="nowrap"> AU2012SPE277<o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 56.8pt; height: 12.75pt;" valign="bottom" width="76" nowrap="nowrap"> <o></o>XYZD002 </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 48pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap"> <o></o>C
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 52.2pt; height: 12.75pt;" valign="bottom" width="70" nowrap="nowrap"> <o></o>DEV </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 52.2pt; height: 12.75pt;" valign="bottom" width="70" nowrap="nowrap"> <o></o>UNIX </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 48pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap"> <o></o>ABCD003 </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 48pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap"> <o></o>D
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 51.65pt; height: 12.75pt;" valign="bottom" width="69" align="center" nowrap="nowrap"> DEV </td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0cm 5.4pt; width: 167pt; height: 12.75pt;" valign="bottom" width="223" nowrap="nowrap"> AU2012SPE359<o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 56.8pt; height: 12.75pt;" valign="bottom" width="76" nowrap="nowrap"> <o></o>XYZD002 </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 48pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap"> <o></o>D
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 52.2pt; height: 12.75pt;" valign="bottom" width="70" nowrap="nowrap"> <o></o>DEV </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 52.2pt; height: 12.75pt;" valign="bottom" width="70" nowrap="nowrap"> <o></o>UNIX </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 48pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap"> <o></o>ABCD003 </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 48pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap"> <o></o>D
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 51.65pt; height: 12.75pt;" valign="bottom" width="69" align="center" nowrap="nowrap">DEV </td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0cm 5.4pt; width: 167pt; height: 12.75pt;" valign="bottom" width="223" nowrap="nowrap"> AUAEQEX002IBMR2<o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 56.8pt; height: 12.75pt;" valign="bottom" width="76" nowrap="nowrap"> <o></o>XYZD002 </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 48pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap"> D
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 52.2pt; height: 12.75pt;" valign="bottom" width="70" nowrap="nowrap"> <o></o>DEV </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 52.2pt; height: 12.75pt;" valign="bottom" width="70" nowrap="nowrap"> <o></o>UNIX </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 48pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap"> <o></o>ABCD003 </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 48pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap"> <o></o>D
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 51.65pt; height: 12.75pt;" valign="bottom" width="69" align="center" nowrap="nowrap">DEV </td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0cm 5.4pt; width: 167pt; height: 12.75pt;" valign="bottom" width="223" nowrap="nowrap"> AUAEQEX003IBMR2<o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 56.8pt; height: 12.75pt;" valign="bottom" width="76" nowrap="nowrap"> <o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 48pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap">
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 52.2pt; height: 12.75pt;" valign="bottom" width="70" nowrap="nowrap"> <o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 52.2pt; height: 12.75pt;" valign="bottom" width="70" nowrap="nowrap"> <o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 48pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap"> <o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 48pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap"> <o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 51.65pt; height: 12.75pt;" valign="bottom" width="69" nowrap="nowrap">
</td></tr></tbody></table>


So, some how Im wondering if its possible to get a macro to count ..down the list of server name ie. from A1 ( AU2012CPE350<o>) </o>--> AUAEQEX003IBMR2<o> </o>but talking about possibly up to 200 server names per workbook

To do steps 1, 2 and 3 as above.

Desired end product of this macro would look like below. (this is kinda like certificate for each server that contains all the vital data. eg. Site, Room, Operating system (O/S), Environment. etc. (could be up to 20 different specifics for the 1 server) - notice destination fields in specific cells

Eg. Certificate sheet (end product wanted)


<link rel="File-List" href="file:///C:%5CDOCUME%7E1%5CADMINI%7E1%5CLOCALS%7E1%5CTemp%5Cmsohtml1%5C01%5Cclip_filelist.xml"><!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:PunctuationKerning/> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent> <w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText> <w:Compatibility> <w:BreakWrappedTables/> <w:SnapToGridInCell/> <w:WrapTextWithPunct/> <w:UseAsianBreakRules/> <w:DontGrowAutofit/> </w:Compatibility> <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel> </w:WordDocument> </xml><![endif]--><!--[if gte mso 9]><xml> <w:LatentStyles DefLockedState="false" LatentStyleCount="156"> </w:LatentStyles> </xml><![endif]--><style> <!-- /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-parent:""; margin:0cm; margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:9.0pt; font-family:"Times New Roman"; mso-fareast-font-family:"Times New Roman"; letter-spacing:-1.0pt; mso-bidi-font-weight:bold;} @page Section1 {size:612.0pt 792.0pt; margin:72.0pt 90.0pt 72.0pt 90.0pt; mso-header-margin:36.0pt; mso-footer-margin:36.0pt; mso-paper-source:0;} div.Section1 {page:Section1;} --> </style><!--[if gte mso 10]> <style> /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin:0cm; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman"; mso-ansi-language:#0400; mso-fareast-language:#0400; mso-bidi-language:#0400;} </style> <![endif]--> <table class="MsoNormalTable" style="width: 565pt; margin-left: 5.15pt; border-collapse: collapse;" width="753" border="0" cellpadding="0" cellspacing="0"> <tbody><tr style="height: 15.75pt;"> <td style="border: 1pt solid windowtext; padding: 0cm 5.4pt; background: aqua none repeat scroll 0% 0%; width: 113pt; -moz-background-clip: border; -moz-background-origin: padding; -moz-background-inline-policy: continuous; height: 15.75pt;" valign="bottom" width="151" nowrap="nowrap">

Server Name:<o></o>​

</td> <td style="border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; border-width: 1pt 1pt 1pt medium; padding: 0cm 5.4pt; background: aqua none repeat scroll 0% 0%; width: 113pt; -moz-background-clip: border; -moz-background-origin: padding; -moz-background-inline-policy: continuous; height: 15.75pt;" valign="bottom" width="151" nowrap="nowrap"> AU2012CPE350 </td> <td style="border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; border-width: 1pt 1pt 1pt medium; padding: 0cm 5.4pt; background: aqua none repeat scroll 0% 0%; width: 113pt; -moz-background-clip: border; -moz-background-origin: padding; -moz-background-inline-policy: continuous; height: 15.75pt;" valign="bottom" width="151" nowrap="nowrap">

Application: <o></o>​

</td> <td style="border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; border-width: 1pt 1pt 1pt medium; padding: 0cm 5.4pt; background: aqua none repeat scroll 0% 0%; width: 113pt; -moz-background-clip: border; -moz-background-origin: padding; -moz-background-inline-policy: continuous; height: 15.75pt;" valign="bottom" width="151" nowrap="nowrap">

0<o></o>​

</td> <td style="border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; border-width: 1pt 1pt 1pt medium; padding: 0cm 5.4pt; background: aqua none repeat scroll 0% 0%; width: 113pt; -moz-background-clip: border; -moz-background-origin: padding; -moz-background-inline-policy: continuous; height: 15.75pt;" valign="bottom" width="151" nowrap="nowrap"> <o></o>
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> <o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> <o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> <o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> <o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> <o></o>
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0cm 5.4pt; background: rgb(204, 255, 204) none repeat scroll 0% 0%; width: 113pt; -moz-background-clip: border; -moz-background-origin: padding; -moz-background-inline-policy: continuous; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> Location : <o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> <o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> <o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> <o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> <o></o>
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> <o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> Site<o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> CCC<o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> MRS/Rack<o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> MRS-10-01<o></o>
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> <o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> Room<o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> A
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> X Co-Ordinate<o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> 31<o></o>
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> <o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> <o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> <o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> Y Co-Ordinate<o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> 18<o></o>
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> <o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> <o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> <o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> Rack Unit (RU)<o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> 33-35<o></o>
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> <o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> <o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> <o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> <o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> <o></o>
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0cm 5.4pt; background: rgb(204, 255, 204) none repeat scroll 0% 0%; width: 113pt; -moz-background-clip: border; -moz-background-origin: padding; -moz-background-inline-policy: continuous; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> Server:<o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> Environment<o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> <o></o>PROD
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> <o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> <o></o>
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> <o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> Operating System<o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> <o></o>WINDOWs
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> Version<o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> <o></o>
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> <o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> HBA Type<o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> <o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> HBA Firmware<o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> <o></o>
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> <o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> <o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> <o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> SDDM Version<o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> <o></o>
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> <o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> <o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> <o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> <o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> <o></o>
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0cm 5.4pt; background: rgb(204, 255, 204) none repeat scroll 0% 0%; width: 113pt; -moz-background-clip: border; -moz-background-origin: padding; -moz-background-inline-policy: continuous; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> Switch Details <o></o>
</td> <td colspan="2" style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 226pt; height: 12.75pt;" valign="bottom" width="301" nowrap="nowrap">

Fabric A<o></o>​

</td> <td colspan="2" style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 226pt; height: 12.75pt;" valign="bottom" width="301" nowrap="nowrap">

Fabric B<o></o>​

</td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> <o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> Switch Name<o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> <o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> Switch Name<o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> <o></o>
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> <o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> Connection 1<o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> <o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> Connection 1<o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> <o></o>
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> <o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> Port #<o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> <o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> Port #<o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> <o></o>
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> <o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> Cable Number<o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> <o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> Cable Number<o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> <o></o>
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> <o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> Connection 2<o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> <o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> Connection 2<o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> <o></o>
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> <o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> Port #<o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> <o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> Port #<o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> <o></o>
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> <o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> Cable Number<o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> <o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> Cable Number<o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> <o></o>
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> <o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> <o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> <o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> <o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> <o></o>
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0cm 5.4pt; background: rgb(204, 255, 204) none repeat scroll 0% 0%; width: 113pt; -moz-background-clip: border; -moz-background-origin: padding; -moz-background-inline-policy: continuous; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> SAN768B Details<o></o>
</td> <td colspan="2" style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 226pt; height: 12.75pt;" valign="bottom" width="301" nowrap="nowrap">

Fabric A<o></o>​

</td> <td colspan="2" style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 226pt; height: 12.75pt;" valign="bottom" width="301" nowrap="nowrap">

Fabric B<o></o>​

</td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> <o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> Switch Name<o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> <o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> Switch Name<o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> <o></o>
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> <o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> Connection 1<o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> <o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> Connection 1<o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> <o></o>
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> <o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> Port #<o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> <o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> Port #<o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> <o></o>
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> <o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> Cable Number<o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> <o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> Cable Number<o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> <o></o>
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> <o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> Connection 2<o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> <o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> Connection 2<o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> <o></o>
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> <o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> Port #<o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> <o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> Port #<o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> <o></o>
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> <o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> Cable Number<o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> <o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> Cable Number<o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 113pt; height: 12.75pt;" valign="bottom" width="151" nowrap="nowrap"> <o></o>
</td></tr></tbody></table>


Hope this all makes sense this time
Would appreciate any help .Thanks guys.

Regards,

Michelle.

 

[Michelle_112]

Hi Michelle,

Glad it's working

I dont understand your save prompt - did you use my more robust version of the code?

hehe lol Im not sure now. I'll have to double check. Pretty sure I used the last one. I need to learn how to write these types of scripts some day -great stuff. Wasn't it part of your script? hehe

 

[al_b_cnu]

It apparently was :¬/

Had to keep yopu busy somehow, even it it was pressing cancel 600 times

 

[Michelle_112]

Hi All,

Thanks for the help so far.
I've run into a few of other challenges with this.

1) Found out that there are duplicate 'server names' listed in column A' - which are for something called (HBA connections) that have the similar info as the certificate template.( but are being over-rided)
Eg. Server name: AU2012CPE350 is appearing 2-3 times in the list of 200 servers. I think somehow the script below needs to incorporate a 'count' of duplicate entries eg. create AU2012CPE350 (1), AU2012CPE350 (2) etc if possible.

2) The max # of s/sheets I've discovered is around 255. I've been advised
that possible better output that having 200 s/sheets would be to have a create vbscript html file output. Anyone have any idea about that? eg. for easier printing / sorting processes
(in this case I think parts of the below script can be used)

3) Below script is taking 'Source data' based on Column #/ letter in the template. Would it be possible to extract data based on 'Column name'?
Found out that from the 5 source workbooks - each has different amounts of columns eg. between 1-50 columns and I can't mandate make them the same (they are constantly adding extra columns) :/

Would appreciate any help.
Thanks Alan for you efforts already - this one is a doosey!

Hi,

Slightly more robust code:

Option Explicit

Sub Certificates()
Dim lRowEnd As Long, lRow As Long
Dim lDataItem As Long
Dim lSheet As Long
Dim rCur As Range
Dim sCurItem As String, sCurServerName As String
Dim saDataItems() As String
Dim wsSource As Worksheet, wsServer As Worksheet
Dim wsTemplate As Worksheet

Set wsSource = Sheets("Source")
Set wsTemplate = Sheets("Template")

lDataItem = 0
'ReDim saDataItems(1 To 2, 1 To 1)
For Each rCur In wsTemplate.UsedRange
    sCurItem = ""
    On Error Resume Next
    sCurItem = CStr(rCur.Value)
    On Error GoTo 0
    If Left$(sCurItem & "**", 2) = "##" Then
        lDataItem = lDataItem + 1
        ReDim Preserve saDataItems(1 To 2, 1 To lDataItem)
        saDataItems(1, lDataItem) = rCur.Address
        saDataItems(2, lDataItem) = Mid$(sCurItem, 3)
    End If
Next rCur

lRowEnd = wsSource.Cells(Rows.Count, "A").End(xlUp).Row
For Each rCur In wsSource.Range("A3:A" & lRowEnd)
    sCurServerName = CStr(rCur.Value)
    On Error Resume Next
    With Application
        .DisplayAlerts = False
        ThisWorkbook.Sheets(sCurServerName).Delete
        .DisplayAlerts = True
    End With
    On Error GoTo 0
    lSheet = ThisWorkbook.Sheets.Count
    Set wsServer = Nothing
    Set wsServer = ThisWorkbook.Sheets.Add(after:=Sheets(lSheet))
    On Error Resume Next
    wsServer.Name = sCurServerName
    wsTemplate.Cells.Copy Destination:=wsServer.Cells
    On Error GoTo 0
    For lDataItem = 1 To UBound(saDataItems, 2)
        On Error Resume Next
        If IsNumeric(saDataItems(2, lDataItem)) Then
            wsServer.Range(saDataItems(1, lDataItem)).Value = wsSource.Cells(rCur.Row, Val(saDataItems(2, lDataItem))).Value
        Else
            wsServer.Range(saDataItems(1, lDataItem)).Value = wsSource.Cells(rCur.Row, saDataItems(2, lDataItem)).Value
        End If
        wsServer.Range(saDataItems(1, lDataItem)).Value = wsSource.Cells(rCur.Row, saDataItems(2, lDataItem)).Value
        On Error GoTo 0
    Next lDataItem
Next rCur
End Sub

 

[al_b_cnu]

Hi Michelle,

I've amended the code as follows:
1) Sheet names will have a number suffix enclosed in brackets, e.g. "AU2012SPE192(1)". Note that if you re-run, you'll have to delete any existing sheets first.
2) You can do this by saving the Excel w/book as a web page (See File Save as Type options)
3) Code has been amended to accept a column name as well as a column letter or column number. Can you confirm that the column names are unique (your example posted doesnt)? Beware that I've used the Find method to find the column required, and have noticed that it doesnt seem to like merged cells.

Option Explicit

Sub Certificates()
Dim bSheetNameOK As Boolean
Dim lRowEnd As Long, lRow As Long
Dim lDataItem As Long
Dim lSheet As Long, lSheetNumber As Long
Dim rCur As Range, rFind As Range
Dim sCurItem As String, sCurServerName As String
Dim saDataItems() As String
Dim wsSource As Worksheet, wsServer As Worksheet
Dim wsTemplate As Worksheet

Set wsSource = Sheets("Source")
Set wsTemplate = Sheets("Template")

lDataItem = 0
'ReDim saDataItems(1 To 2, 1 To 1)
For Each rCur In wsTemplate.UsedRange
    sCurItem = ""
    On Error Resume Next
    sCurItem = CStr(rCur.Value)
    On Error GoTo 0
    If Left$(sCurItem & "**", 2) = "##" Then
        sCurItem = Mid$(sCurItem, 3)
        lDataItem = lDataItem + 1
        ReDim Preserve saDataItems(1 To 2, 1 To lDataItem)
        saDataItems(1, lDataItem) = rCur.Address
        saDataItems(2, lDataItem) = sCurItem
        Set rFind = Nothing
        On Error Resume Next
        Set rFind = wsSource.UsedRange.Find(what:=sCurItem, LookIn:=xlValues, lookat:=xlPart)
        On Error GoTo 0
        If Not (rFind Is Nothing) Then saDataItems(2, lDataItem) = rFind.Column
    End If
Next rCur

lRowEnd = wsSource.Cells(Rows.Count, "A").End(xlUp).Row
For Each rCur In wsSource.Range("A3:A" & lRowEnd)
    sCurServerName = CStr(rCur.Value)
    lSheet = ThisWorkbook.Sheets.Count
    Set wsServer = Nothing
    Set wsServer = ThisWorkbook.Sheets.Add(after:=Sheets(lSheet))
    lSheetNumber = 0
    bSheetNameOK = False
    Do
        lSheetNumber = lSheetNumber + 1
        On Error Resume Next
        wsServer.Name = sCurServerName & "(" & lSheetNumber & ")"
        bSheetNameOK = Err.Number = 0
        On Error GoTo 0
        If bSheetNameOK Then Exit Do
    Loop While lSheetNumber < 10
    wsTemplate.Cells.Copy Destination:=wsServer.Cells
    On Error GoTo 0
    For lDataItem = 1 To UBound(saDataItems, 2)
        On Error Resume Next
        If IsNumeric(saDataItems(2, lDataItem)) Then
            wsServer.Range(saDataItems(1, lDataItem)).Value = wsSource.Cells(rCur.Row, Val(saDataItems(2, lDataItem))).Value
        Else
            wsServer.Range(saDataItems(1, lDataItem)).Value = wsSource.Cells(rCur.Row, saDataItems(2, lDataItem)).Value
        End If
        wsServer.Range(saDataItems(1, lDataItem)).Value = wsSource.Cells(rCur.Row, saDataItems(2, lDataItem)).Value
        On Error GoTo 0
    Next lDataItem
Next rCur
End Sub

 

[Michelle_112]

Brilliant! Thanks again Alan, your a genius. Im feeling a bit spoiled

Just to confirm - yes all the columns are unique in each workbook (at least they mandated that) woho
I was playing around today with your original script and found by just changing "display alerts = true" to 'false', created all 1-200 sheets in one click.
So..(just to save my clicking 600 times) I just inserted part of that line inside your new one. After clicking once it just goes whhhamm and just makes all sheets in about 5-6 seconds!

I have tested the below script. ( I just changed A3 to A2 - as cell the first server was on) I've tried out the 'find eg. "##Server Name" and others and all working perfectly!
The count is working excellently also. Thanks very much for doing those additions. My boss is very impressed hehe

Sub Certificates()
Dim bSheetNameOK As Boolean
Dim lRowEnd As Long, lRow As Long
Dim lDataItem As Long
Dim lSheet As Long, lSheetNumber As Long
Dim rCur As Range, rFind As Range
Dim sCurItem As String, sCurServerName As String
Dim saDataItems() As String
Dim wsSource As Worksheet, wsServer As Worksheet
Dim wsTemplate As Worksheet

Set wsSource = Sheets("Source")
Set wsTemplate = Sheets("Template")

lDataItem = 0
'ReDim saDataItems(1 To 2, 1 To 1)
For Each rCur In wsTemplate.UsedRange
    sCurItem = ""
    On Error Resume Next
    sCurItem = CStr(rCur.Value)
    On Error GoTo 0
    If Left$(sCurItem & "**", 2) = "##" Then
        sCurItem = Mid$(sCurItem, 3)
        lDataItem = lDataItem + 1
        ReDim Preserve saDataItems(1 To 2, 1 To lDataItem)
        saDataItems(1, lDataItem) = rCur.Address
        saDataItems(2, lDataItem) = sCurItem
        Set rFind = Nothing
        On Error Resume Next
        Set rFind = wsSource.UsedRange.Find(what:=sCurItem, LookIn:=xlValues, lookat:=xlPart)
        On Error GoTo 0
        If Not (rFind Is Nothing) Then saDataItems(2, lDataItem) = rFind.Column
    End If
Next rCur

lRowEnd = wsSource.Cells(Rows.Count, "A").End(xlUp).Row
For Each rCur In wsSource.Range("[B]A2[/B]:A" & lRowEnd)
    sCurServerName = CStr(rCur.Value)
    lSheet = ThisWorkbook.Sheets.Count
    Set wsServer = Nothing
    Set wsServer = ThisWorkbook.Sheets.Add(after:=Sheets(lSheet))
    lSheetNumber = 0
    bSheetNameOK = False
    Do
        lSheetNumber = lSheetNumber + 1
        On Error Resume Next
        wsServer.Name = sCurServerName & "(" & lSheetNumber & ")"
        bSheetNameOK = Err.Number = 0
        On Error GoTo 0
        If bSheetNameOK Then Exit Do
    Loop While lSheetNumber < 10
    wsTemplate.Cells.Copy Destination:=wsServer.Cells
    On Error GoTo 0
    For lDataItem = 1 To UBound(saDataItems, 2)
        On Error Resume Next
        If IsNumeric(saDataItems(2, lDataItem)) Then
            wsServer.Range(saDataItems(1, lDataItem)).Value = wsSource.Cells(rCur.Row, Val(saDataItems(2, lDataItem))).Value
        Else
            wsServer.Range(saDataItems(1, lDataItem)).Value = wsSource.Cells(rCur.Row, saDataItems(2, lDataItem)).Value
        End If
        wsServer.Range(saDataItems(1, lDataItem)).Value = wsSource.Cells(rCur.Row, saDataItems(2, lDataItem)).Value
        
      [B]  With Application
        .DisplayAlerts = False
        ThisWorkbook.Sheets(sCurServerName).Delete
        .DisplayAlerts = False[/B]
    End With
    
    On Error GoTo 0
    Next lDataItem
Next rCur
End Sub

 

[Michelle_112]

EDIT: Oh - Im not sure why but for some reason, data for
##Server Name part on certificate is coming out with random data (rather than the server name) hmm.. I have so many copies of sheets.
(I think it has something to do with a conflicting format on my test workbooks)
Or format. Hopefully should fix itself

EDIT again: Yes- definitely has smthg to do with the workbook im using. Using same code on both test workbooks. Anyways - no worries all good

 

[al_b_cnu]

Hi Michelle,

If the server name is always in column A (for instance), you can still use the '##A' or '##1' format to indicate the required column.

Failing that, PM me & I'll give you my email address for you to send me a sample w/book with the problem.

Lets hope your boss gives you a raise!