Hi all,
I'm using Excel 2011 on a Mac, I have the Developer tab available.
I have a workbook that looks like this:
<colgroup><col width="50" span="17" style="width: 50pt;"></colgroup><tbody>
</tbody>
I want it to be transformed to this format:
<tbody>
</tbody>
And so forth.
I know that the way to do this in using the developer tabs, and creating a macro, I found some things similar on this forum, but I don't really understand visual basic at all. Can anyone help?
Thanks ahead!<style><!--table {mso-displayed-decimal-separator:"\."; mso-displayed-thousand-separator:"\,";}@page {margin:1.0in .75in 1.0in .75in; mso-header-margin:.5in; mso-footer-margin:.5in;}td {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignoreadding; 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;}.xl63 {border:.5pt solid windowtext;}--></style><style><!--table {mso-displayed-decimal-separator:"\."; mso-displayed-thousand-separator:"\,";}@page {margin:1.0in .75in 1.0in .75in; mso-header-margin:.5in; mso-footer-margin:.5in;}td {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignoreadding; 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;}.xl63 {border:.5pt solid windowtext;}--></style>
I'm using Excel 2011 on a Mac, I have the Developer tab available.
I have a workbook that looks like this:
Family | Genus | Species | Blood / Heart | Teeth / Mouth | Guts / Stomach | Sexual health | Neurological | General | Eyes | Muscles/Skeleton | Skin | Wounds and cuts | Other | Throat Nose Ear | Lungs / Breathing | Urinary |
Nymphaeaceae | Nymphaea | alba | Staunch bleeding (Cavan) | A cure for corns (Argylshire), drawing a boil (Cavan) |
<colgroup><col width="50" span="17" style="width: 50pt;"></colgroup><tbody>
</tbody>
I want it to be transformed to this format:
Family | Genus | Species | Use Category | Details |
Nymphaeaceae | Nymphaea | alba | Blood / Heart | Staunch bleeding (Cavan) |
Nymphaeaceae | Nymphaea | alba | Teeth / Mouth | |
Nymphaeaceae | Nymphaea | alba | Guts / Stomach | |
Nymphaeaceae | Nymphaea | alba | Sexual Health | |
Nymphaeaceae | Nymphaea | alba | Neurological | |
Nymphaeaceae | Nymphaea | alba | General |
<tbody>
</tbody>
And so forth.
I know that the way to do this in using the developer tabs, and creating a macro, I found some things similar on this forum, but I don't really understand visual basic at all. Can anyone help?
Thanks ahead!<style><!--table {mso-displayed-decimal-separator:"\."; mso-displayed-thousand-separator:"\,";}@page {margin:1.0in .75in 1.0in .75in; mso-header-margin:.5in; mso-footer-margin:.5in;}td {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignoreadding; 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;}.xl63 {border:.5pt solid windowtext;}--></style><style><!--table {mso-displayed-decimal-separator:"\."; mso-displayed-thousand-separator:"\,";}@page {margin:1.0in .75in 1.0in .75in; mso-header-margin:.5in; mso-footer-margin:.5in;}td {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignoreadding; 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;}.xl63 {border:.5pt solid windowtext;}--></style>