Macro for creating + naming sheets, migrating cells : v2

M

Michelle_112

New Member
Joined
May 6, 2010
Messages
40
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:p></o:p>
</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:p></o:p>​
</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:p></o:p>​
</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:p></o:p>​
</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:p></o:p>​
</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:p></o:p>​
</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:p></o:p>​
</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:p></o:p>​
</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:p></o:p>
</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:p></o:p>​
</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:p></o:p>​
</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:p></o:p>​
</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:p></o:p>​
</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:p></o:p>​
</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:p></o:p>​
</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:p></o:p>​
</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:p></o:p>
</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:p></o:p>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:p></o:p>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:p></o:p>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:p></o:p>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:p></o:p>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:p></o:p>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:p></o:p>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:p></o:p>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:p></o:p>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:p></o:p>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:p></o:p> <o:p></o:p>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:p></o:p>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:p></o:p>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:p></o:p>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:p></o:p>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:p></o:p>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:p></o:p>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:p></o:p> <o:p></o:p>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:p></o:p>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:p></o:p>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:p></o:p>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:p></o:p>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:p></o:p> <o:p></o:p>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:p></o:p>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:p></o:p>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:p></o:p>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:p></o:p>
</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:p></o:p>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:p></o:p>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:p></o:p>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:p></o:p>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:p></o:p>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:p></o:p> </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:p></o:p>
</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:p></o:p>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:p></o:p>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:p></o:p>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:p></o:p>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:p></o:p>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:p></o:p>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:p></o:p>
</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:p></o:p>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:p></o:p>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:p></o:p>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:p></o:p>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:p></o:p>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:p></o:p>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:p></o:p>
</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:p></o:p>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:p></o:p>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:p></o:p>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:p></o:p>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:p></o:p>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:p></o:p> </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:p></o:p>
</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:p></o:p>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:p></o:p>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:p></o:p>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:p></o:p>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:p></o:p>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:p></o:p>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:p></o:p> </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:p></o:p>
</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:p></o:p>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:p></o:p>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:p></o:p>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:p></o:p>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:p></o:p>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:p></o:p>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:p></o:p>
</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:p></o:p>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:p></o:p>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:p></o:p>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:p></o:p>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:p></o:p>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:p></o:p>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:p></o:p> </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:p></o:p>
</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:p></o:p>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:p></o:p>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:p></o:p>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:p></o:p>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:p></o:p>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:p></o:p>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:p></o:p> </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:p></o:p>
</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:p></o:p>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:p></o:p>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:p></o:p>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:p></o:p>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:p></o:p>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:p></o:p>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:p></o:p>
</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:p></o:p>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:p></o:p>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:p></o:p>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:p></o:p>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:p></o:p>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:p></o:p>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:p></o:p>
</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:p></o:p>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:p></o:p>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:p></o:p>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:p></o:p>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:p></o:p>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:p></o:p>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:p></o:p>
</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:p></o:p>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:p></o:p>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:p></o:p>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:p></o:p>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:p></o:p>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:p></o:p>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:p></o:p>
</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:p></o:p>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:p></o:p>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:p></o:p>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:p></o:p>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:p></o:p>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:p></o:p>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:p></o:p>
</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:p></o:p>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:p></o:p>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:p></o:p>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:p></o:p>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:p></o:p>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:p></o:p>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:p></o:p>
</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:p></o:p>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:p></o:p>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:p></o:p>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:p></o:p>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:p></o:p>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:p></o:p>
</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:p></o:p>
</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:p></o:p>
</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:p></o:p>
</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:p></o:p>
</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:p></o:p>
</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:p>) </o:p>--> AUAEQEX003IBMR2<o:p> </o:p>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:p></o:p>​
</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:p></o:p>​
</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:p></o:p>​
</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:p></o:p>
</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:p></o:p>
</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:p></o:p>
</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:p></o:p>
</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:p></o:p>
</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:p></o:p>
</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:p></o:p>
</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:p></o:p>
</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:p></o:p>
</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:p></o:p>
</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:p></o:p>
</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:p></o:p>
</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:p></o:p>
 </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:p></o:p>
</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:p></o:p>
</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:p></o:p>
</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:p></o:p>
</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:p></o:p>
 </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:p></o:p>
</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:p></o:p>
</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:p></o:p>
</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:p></o:p>
</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:p></o:p>
</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:p></o:p>
</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:p></o:p>
</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:p></o:p>
</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:p></o:p>
</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:p></o:p>
</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:p></o:p>
</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:p></o:p>
</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:p></o:p>
</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:p></o:p>
</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:p></o:p>
</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:p></o:p>
</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:p></o:p>
</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:p></o:p>
</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:p></o:p>
 </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:p></o:p>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:p></o:p>
</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:p></o:p>
</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:p></o:p>
</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:p></o:p>
 </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:p></o:p>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:p></o:p>
</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:p></o:p>
</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:p></o:p>
</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:p></o:p>
 </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:p></o:p>
</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:p></o:p>
</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:p></o:p>
</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:p></o:p>
</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:p></o:p>
</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:p></o:p>
</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:p></o:p>
</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:p></o:p>
</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:p></o:p>
</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:p></o:p>
</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:p></o:p>
</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:p></o:p>
</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:p></o:p>
</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:p></o:p>
</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:p></o:p>​
</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:p></o:p>​
</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:p></o:p>
</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:p></o:p>
 </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:p></o:p>
</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:p></o:p>
</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:p></o:p>
</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:p></o:p>
</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:p></o:p>
 </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:p></o:p>
</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:p></o:p>
</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:p></o:p>
</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:p></o:p>
</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:p></o:p>
 </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:p></o:p>
</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:p></o:p>
</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:p></o:p>
</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:p></o:p>
</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:p></o:p>
 </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:p></o:p>
</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:p></o:p>
</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:p></o:p>
</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:p></o:p>
</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:p></o:p>
 </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:p></o:p>
</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:p></o:p>
</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:p></o:p>
</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:p></o:p>
</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:p></o:p>
 </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:p></o:p>
</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:p></o:p>
</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:p></o:p>
</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:p></o:p>
</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:p></o:p>
 </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:p></o:p>
</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:p></o:p>
</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:p></o:p>
</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:p></o:p>
</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:p></o:p>
</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:p></o:p>
</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:p></o:p>
</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:p></o:p>
</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:p></o:p>
</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:p></o:p>​
</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:p></o:p>​
</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:p></o:p>
</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:p></o:p>
</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:p></o:p>
</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:p></o:p>
</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:p></o:p>
</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:p></o:p>
</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:p></o:p>
</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:p></o:p>
</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:p></o:p>
</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:p></o:p>
</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:p></o:p>
</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:p></o:p>
</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:p></o:p>
</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:p></o:p>
</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:p></o:p>
</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:p></o:p>
</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:p></o:p>
</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:p></o:p>
</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:p></o:p>
</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:p></o:p>
</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:p></o:p>
</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:p></o:p>
</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:p></o:p>
</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:p></o:p>
</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:p></o:p>
</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:p></o:p>
</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:p></o:p>
</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:p></o:p>
</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:p></o:p>
</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:p></o:p>
</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:p></o:p>
</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:p></o:p>
</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:p></o:p>
</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:p></o:p>
</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:p></o:p>
</td></tr></tbody></table>


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

Regards,

Michelle.
 
Last edited by a moderator:

Excel Facts

Did you know Excel offers Filter by Selection?
Add the AutoFilter icon to the Quick Access Toolbar. Select a cell containing Apple, click AutoFilter, and you will get all rows with Apple
Sort by date Sort by votes
Why don't you have one sheet with data validation for the server name and VLOOKUP formulas to return the relevant information?
 
Upvote 0
Andrew Poulsom said:
Why don't you have one sheet with data validation for the server name and VLOOKUP formulas to return the relevant information?
Click to expand...
the above example of the desired output 'certificate' was done via a VLookup- from the source. (my boss had done the VLookup for one sheet - but got as far as having to manually type the 'server name'
into the new sheet + re-naming of the sheet. (so for a single sheet so far).

We're talking about 600 sheets (certificates) needed so - im looking for something to possibly automate the steps as mentioned above.
By all means- if VLookup can be leveraged in this i would be interested - but I think VLookup could get pretty messy with having 1-200 sheets in the one workbook? Im not entirely sure (Im not very experienced with VLookup)
Another thing , Im almost certain that requirements for the source data at the start will change eg. room, environment - that for example will need to select different data as matched on the certificate - once validated.
 
Last edited:
Upvote 0
600 sheets is rather a lot to have in one workbook. What are you going to do with them once they have been created?
 
Upvote 0
Hi Michelle,

As Andrew says, 600 sheets is rathert a lot for one w/book. Could you possibly split over several w/books, grouped by room?

As you will wish to change the format / data output at a later stage, perhaps a template sheet will be needed. This template sheet could define the format ofeach cell, and each cell to contain data in the output would contain a value, e.g. '#x#' where 'x' is the column of the source data.
 
Upvote 0
Hi Michelle,

Try this code which assumes the source data is in sheet 'Source'
You first need to create a template sheet named 'Template', and in the appropriate cells enter '##' followed by the source column. For instance if you want the server name (which is in column A) to be in cell C5, enter '##A' in cell C5 of the template sheet.
e.g.
Excel Workbook
ABCDE
1Server Name:##AApplication:0
2
3Location :
4SiteCCCMRS/RackMRS-10-01
5Room##CX Co-Ordinate31
6Y Co-Ordinate18
7Rack Unit (RU)33-35
8
9Server:Environment##D
10Operating System##EVersion
11HBA TypeHBA Firmware
12SDDM Version
13
14Switch DetailsFabric AFabric B
15Switch Name##BSwitch Name##F
16Connection 1Connection 1
17Port #Port #
18Cable NumberCable Number
19Connection 2Connection 2
20Port #Port #
21Cable NumberCable Number
22
23SAN768B DetailsFabric AFabric B
24Switch NameSwitch Name
25Connection 1Connection 1
26Port #Port #
27Cable NumberCable Number
28Connection 2Connection 2
29Port #Port #
30Cable NumberCable Number
Template
Excel 2003

Then run this macro:
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

lSheet = ThisWorkbook.Sheets.Count
lRowEnd = wsSource.Cells(Rows.Count, "A").End(xlUp).Row
For Each rCur In wsSource.Range("A2:A" & lRowEnd)
    sCurServerName = CStr(rCur.Value)
    Set wsServer = Nothing
    Set wsServer = ThisWorkbook.Sheets.Add(after:=Sheets(lSheet))
    lSheet = lSheet + 1
    On Error Resume Next
    wsServer.Name = sCurServerName
    wsTemplate.Cells.Copy Destination:=wsServer.Cells
    On Error GoTo 0
    For lDataItem = 1 To UBound(saDataItems, 2)
        wsServer.Range(saDataItems(1, lDataItem)).Value = wsSource.Range(saDataItems(2, lDataItem) & rCur.Row).Value
    Next lDataItem
Next rCur
End Sub
 
Upvote 0
Hi Guys,
Thanks for the replies. Just to clarify: I have around
1 - 200 names on the source workbook).
5 source (workbooks)
amounting to about 800 servers

Thanks very much Alanfor putting up that script. Im at work at the moment, I'll try this out - probably im going to work on this over the weekend too

:)
 
Upvote 0
Hi,

Slightly more robust code:
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
 
Upvote 0
hi Alan,

Thanks soo much! Its working great!! When I run it, it comes up with a 'save prompt- everytime i press 'cancel' it creates the 'new sheet' (named after the server). I have validated the output and it comes out with the exact details with ##.
Thanks for making it! This just made my day. woho :) Loving this forum. lol
Has just cut this initially huge job into smthg much smaller.
Have a nice weekend.
Cheers (y)
Michelle.
 
Upvote 0
Hi Michelle,

Glad it's working :)

I dont understand your save prompt - did you use my more robust version of the code?
 
Upvote 0
You must log in or register to reply here.

Similar threads

A
  • Question
VBA - Automatically Break the Line in HTML format.
Replies
7
Views
1K
Attrazion
A
G
  • Question
Using Excel formula to create HTML code text referencing specific cells
Replies
0
Views
852
gvsumich
G
E
  • Question
VBA for Web Scraping help
Replies
0
Views
606
epactheactor
E
C
  • Solved
Excel 2016 32bit VBA Pulling info from Website to Sheet
Replies
2
Views
1K
CrashOD
C
E
  • Question
Query in excel to Outlook mail take rows with name until next name
Replies
0
Views
356
esben
E

Forum statistics

Threads
1,215,455
Messages
6,124,938
Members
449,197
Latest member
k_bs

Share this page

We've detected that you are using an adblocker.

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

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

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

Disable uBlock

Follow these easy steps to disable uBlock

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