Hi all,
I am facing this problem. I have an inventory of chemical ordered that should be ordered in alphabetically . The sheets has different columns also.
every about 16 rows i have to insert a row which contain the description of each single column (the one in bold in the example below):
<style> <!--table {mso-displayed-decimal-separator:"\."; mso-displayed-thousand-separator:"\,";} @page {mso-header-data:"&C&\0022Calibri\,Regular\0022&K000000Fabrizio chemical inventory updated top&R&\0022Calibri\,Regular\0022&K000000&D"; margin:.79in .2in .79in .19in; mso-header-margin:.5in; mso-footer-margin:.5in;} td {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore
adding; color:black; font-size:12.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Calibri, sans-serif; mso-font-charset:0; mso-number-format:General; text-align:general; vertical-align:bottom; border:none; mso-background-source:auto; mso-pattern:auto; mso-protection:locked visible; white-space:nowrap; mso-rotate:0;} .xl64 {font-family:Arial; mso-generic-font-family:auto; mso-font-charset:204; text-align:center;} .xl65 {font-weight:700; font-family:Arial; mso-generic-font-family:auto; mso-font-charset:204; text-align:center; vertical-align:middle; border:.5pt solid windowtext;} .xl66 {font-weight:700; font-family:Arial; mso-generic-font-family:auto; mso-font-charset:204; text-align:center; vertical-align:middle; border:.5pt solid windowtext; white-space:normal;} .xl67 {font-family:Arial; mso-generic-font-family:auto; mso-font-charset:204; text-align:center; white-space:normal;} .xl68 {font-family:Arial; mso-generic-font-family:auto; mso-font-charset:204; text-align:left; white-space:normal;} .xl69 {font-family:Arial; mso-generic-font-family:auto; mso-font-charset:204; text-align:left; vertical-align:middle; border:.5pt solid windowtext; white-space:normal;} .xl70 {font-family:Arial; mso-generic-font-family:auto; mso-font-charset:204; text-align:center; vertical-align:middle;} .xl71 {font-family:Arial; mso-generic-font-family:auto; mso-font-charset:204; text-align:center; vertical-align:middle; border:.5pt solid windowtext; white-space:normal;} .xl72 {font-weight:700; font-family:Arial; mso-generic-font-family:auto; mso-font-charset:204; mso-number-format:"\@"; text-align:center; vertical-align:middle; border:.5pt solid windowtext;} .xl73 {color:black; font-family:Arial; mso-generic-font-family:auto; mso-font-charset:204; text-align:center; vertical-align:middle; border:.5pt solid windowtext; white-space:normal;} .xl74 {color:black; font-family:"Zapf Dingbats"; mso-generic-font-family:auto; mso-font-charset:204; text-align:center; vertical-align:middle; border:.5pt solid windowtext; white-space:normal;} .xl75 {color:black; font-family:Arial; mso-generic-font-family:auto; mso-font-charset:204; text-align:center; vertical-align:middle; border:.5pt solid windowtext;} --> </style> [TABLE="width: 507"]
<tbody>[TR]
[TD="class: xl69, width: 195"]2-methyl-2butanol (amyl alcohol)[/TD]
[TD="class: xl71, width: 62"]250 mL[/TD]
[TD="class: xl71, width: 84"]75-85-4[/TD]
[TD="class: xl74, width: 52"]✔[/TD]
[TD="class: xl73, width: 39"][/TD]
[TD="class: xl73, width: 75"]Hood big cabinet[/TD]
[/TR]
[TR]
[TD="class: xl66, width: 195"]Chemical[/TD]
[TD="class: xl66, width: 62"]amount[/TD]
[TD="class: xl65"]CAS[/TD]
[TD="class: xl65"]full/new[/TD]
[TD="class: xl72"]Half[/TD]
[TD="class: xl65"]location[/TD]
[/TR]
[TR]
[TD="class: xl69, width: 195"]2-nitrobenzenesulfonyl chloride[/TD]
[TD="class: xl71, width: 62"]100 g[/TD]
[TD="class: xl71, width: 84"]1694-92-4[/TD]
[TD="class: xl74, width: 52"]✔[/TD]
[TD="class: xl75"][/TD]
[TD="class: xl73, width: 75"]N-alkylAA prj box[/TD]
[/TR]
</tbody>[/TABLE]
This because when i print a copy of this inventory, in each page there is the name of the various columns.
If i try to sort the entire sheet, everything is messed up with the description row.
Is there any way to order alphabetically the columns excluding only selected rows?
Apologize in advance if the description of the problem is not clear.
thanks
Fabrizio
I am facing this problem. I have an inventory of chemical ordered that should be ordered in alphabetically . The sheets has different columns also.
every about 16 rows i have to insert a row which contain the description of each single column (the one in bold in the example below):
<style> <!--table {mso-displayed-decimal-separator:"\."; mso-displayed-thousand-separator:"\,";} @page {mso-header-data:"&C&\0022Calibri\,Regular\0022&K000000Fabrizio chemical inventory updated top&R&\0022Calibri\,Regular\0022&K000000&D"; margin:.79in .2in .79in .19in; mso-header-margin:.5in; mso-footer-margin:.5in;} td {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore
adding; color:black; font-size:12.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Calibri, sans-serif; mso-font-charset:0; mso-number-format:General; text-align:general; vertical-align:bottom; border:none; mso-background-source:auto; mso-pattern:auto; mso-protection:locked visible; white-space:nowrap; mso-rotate:0;} .xl64 {font-family:Arial; mso-generic-font-family:auto; mso-font-charset:204; text-align:center;} .xl65 {font-weight:700; font-family:Arial; mso-generic-font-family:auto; mso-font-charset:204; text-align:center; vertical-align:middle; border:.5pt solid windowtext;} .xl66 {font-weight:700; font-family:Arial; mso-generic-font-family:auto; mso-font-charset:204; text-align:center; vertical-align:middle; border:.5pt solid windowtext; white-space:normal;} .xl67 {font-family:Arial; mso-generic-font-family:auto; mso-font-charset:204; text-align:center; white-space:normal;} .xl68 {font-family:Arial; mso-generic-font-family:auto; mso-font-charset:204; text-align:left; white-space:normal;} .xl69 {font-family:Arial; mso-generic-font-family:auto; mso-font-charset:204; text-align:left; vertical-align:middle; border:.5pt solid windowtext; white-space:normal;} .xl70 {font-family:Arial; mso-generic-font-family:auto; mso-font-charset:204; text-align:center; vertical-align:middle;} .xl71 {font-family:Arial; mso-generic-font-family:auto; mso-font-charset:204; text-align:center; vertical-align:middle; border:.5pt solid windowtext; white-space:normal;} .xl72 {font-weight:700; font-family:Arial; mso-generic-font-family:auto; mso-font-charset:204; mso-number-format:"\@"; text-align:center; vertical-align:middle; border:.5pt solid windowtext;} .xl73 {color:black; font-family:Arial; mso-generic-font-family:auto; mso-font-charset:204; text-align:center; vertical-align:middle; border:.5pt solid windowtext; white-space:normal;} .xl74 {color:black; font-family:"Zapf Dingbats"; mso-generic-font-family:auto; mso-font-charset:204; text-align:center; vertical-align:middle; border:.5pt solid windowtext; white-space:normal;} .xl75 {color:black; font-family:Arial; mso-generic-font-family:auto; mso-font-charset:204; text-align:center; vertical-align:middle; border:.5pt solid windowtext;} --> </style> [TABLE="width: 507"]<tbody>[TR]
[TD="class: xl69, width: 195"]2-methyl-2butanol (amyl alcohol)[/TD]
[TD="class: xl71, width: 62"]250 mL[/TD]
[TD="class: xl71, width: 84"]75-85-4[/TD]
[TD="class: xl74, width: 52"]✔[/TD]
[TD="class: xl73, width: 39"][/TD]
[TD="class: xl73, width: 75"]Hood big cabinet[/TD]
[/TR]
[TR]
[TD="class: xl66, width: 195"]Chemical[/TD]
[TD="class: xl66, width: 62"]amount[/TD]
[TD="class: xl65"]CAS[/TD]
[TD="class: xl65"]full/new[/TD]
[TD="class: xl72"]Half[/TD]
[TD="class: xl65"]location[/TD]
[/TR]
[TR]
[TD="class: xl69, width: 195"]2-nitrobenzenesulfonyl chloride[/TD]
[TD="class: xl71, width: 62"]100 g[/TD]
[TD="class: xl71, width: 84"]1694-92-4[/TD]
[TD="class: xl74, width: 52"]✔[/TD]
[TD="class: xl75"][/TD]
[TD="class: xl73, width: 75"]N-alkylAA prj box[/TD]
[/TR]
</tbody>[/TABLE]
This because when i print a copy of this inventory, in each page there is the name of the various columns.
If i try to sort the entire sheet, everything is messed up with the description row.
Is there any way to order alphabetically the columns excluding only selected rows?
Apologize in advance if the description of the problem is not clear.
thanks
Fabrizio
