Every morning I have to manually copy and paste information from cells because VLOOKUP doesn't carry over formatting. I am very beginner to VBA.... Basically I have cells that contain information laid out like such:
<tbody>
</tbody>
Any help is appreciated putting together VBA Code or functions to copy the formatting and values due to the strikethroughs through some text. I just need a way to get VLOOKUP to carry over the formatting of the strikethroughs and even print them on a new sheet.
Product Name | DOCKET |
ABC | <del>1234</del>TEST |
BCD | 2345 TEST |
<tbody>
</tbody>
Any help is appreciated putting together VBA Code or functions to copy the formatting and values due to the strikethroughs through some text. I just need a way to get VLOOKUP to carry over the formatting of the strikethroughs and even print them on a new sheet.