Here's a macro that will move the data for you.
Code:
Sub Macro1()
i = 1
Do Until i = 3
If i = 1 Then
strLetter = "B"
colLetter = "AA"
End If
If i = 2 Then
strLetter = "C"
colLetter = "AB"
End If
lnglastrow = Sheets("Sheet1").Range("Z65535").End(xlUp).Row
Set r = Range("Z2:Z" & lnglastrow)
firstRow = 2
For Each c In r
If c.Value = strLetter Then
Range(colLetter & firstRow).Value = strLetter
firstRow = firstRow + 1
End If
Next
i = i + 1
Loop
Columns("Z:Z").Replace What:="B", Replacement:=""
Columns("Z:Z").Replace What:="C", Replacement:=""
Columns("Z:Z").SpecialCells(xlCellTypeBlanks).Delete Shift:=xlUp
Range("Z1").Select
End Sub
Before Macro:
Excel tables to the web >> Excel Jeanie HTML 4
hi rconverse, thanks for the code but it doesn't seem to be working properly
only A's work but B's and C's just disappear and i want it to show like the table below
<table style="font-family: Calibri,Arial; font-size: 11pt; background-color: rgb(255, 255, 255); padding-left: 2pt; padding-right: 2pt; width: 252px; height: 180px;" border="1" cellpadding="0" cellspacing="0"> <colgroup><col style="font-weight: bold; width: 30px;"><col style="width: 64px;"><col style="width: 64px;"><col style="width: 64px;"></colgroup><tbody><tr style="background-color: rgb(202, 202, 202); text-align: center; font-weight: bold; font-size: 8pt;"><td> </td><td>Z</td><td>AA</td><td>AB</td></tr><tr style="height: 18px;"><td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">1</td><td>A</td><td>
</td><td>
</td></tr><tr style="height: 18px;"><td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">2</td><td>A</td><td>
</td><td>
</td></tr><tr style="height: 18px;"><td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">3</td><td>A</td><td>
</td><td>
</td></tr><tr style="height: 18px;"><td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">4</td><td>A</td><td>
</td><td>
</td></tr><tr style="height: 18px;"><td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">5</td><td>A</td><td>
</td><td>
</td></tr><tr style="height: 18px;"><td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">6</td><td>A</td><td>
</td><td>
</td></tr><tr style="height: 18px;"><td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">7</td><td>A</td><td>
</td><td>
</td></tr><tr style="height: 18px;"><td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">8</td><td>A</td><td>
</td><td>
</td></tr><tr><td style="vertical-align: top;">9
</td><td style="vertical-align: top;">
</td><td style="vertical-align: top;">B
</td><td style="vertical-align: top;">
</td></tr><tr><td style="vertical-align: top;">10
</td><td style="vertical-align: top;">
</td><td style="vertical-align: top;">B
</td><td style="vertical-align: top;">
</td></tr><tr><td style="vertical-align: top;">11
</td><td style="vertical-align: top;">
</td><td style="vertical-align: top;">B
</td><td style="vertical-align: top;">
</td></tr><tr><td style="vertical-align: top;">12
</td><td style="vertical-align: top;">
</td><td style="vertical-align: top;">B
</td><td style="vertical-align: top;">
</td></tr><tr><td style="vertical-align: top;">13
</td><td style="vertical-align: top;">
</td><td style="vertical-align: top;">B
</td><td style="vertical-align: top;">
</td></tr><tr><td style="vertical-align: top;">14
</td><td style="vertical-align: top;">
</td><td style="vertical-align: top;">B
</td><td style="vertical-align: top;">
</td></tr><tr><td style="vertical-align: top;">15
</td><td style="vertical-align: top;">
</td><td style="vertical-align: top;">
</td><td style="vertical-align: top;">C
</td></tr><tr><td style="vertical-align: top;">16
</td><td style="vertical-align: top;">
</td><td style="vertical-align: top;">
</td><td style="vertical-align: top;">C
</td></tr><tr><td style="vertical-align: top;">17
</td><td style="vertical-align: top;">
</td><td style="vertical-align: top;">
</td><td style="vertical-align: top;">C
</td></tr><tr><td style="vertical-align: top;">18
</td><td style="vertical-align: top;">
</td><td style="vertical-align: top;">
</td><td style="vertical-align: top;">C
</td></tr><tr><td style="vertical-align: top;">19
</td><td style="vertical-align: top;">
</td><td style="vertical-align: top;">
</td><td style="vertical-align: top;">C
</td></tr></tbody></table>