need a Macro fill Down...,

[rajuctech]

Hi Guys,

i need a macro fill the below mentioned blank format in excel,kindly assist me............. all the columns (A,B,C,D,E,F)

A B C D E F
<table border="0" cellpadding="0" cellspacing="0" width="489"><col style="width: 59pt;" width="78"> <col style="width: 53pt;" width="70"> <col style="width: 38pt;" width="50"> <col style="width: 74pt;" width="98" span="2"> <col style="width: 71pt;" width="95"> <tbody><tr style="height: 12.75pt;" height="17"> <td class="xl65" style="height: 12.75pt; width: 59pt;" width="78" height="17">WK No</td> <td class="xl65" style="border-left: medium none; width: 53pt;" width="70">Product</td> <td class="xl65" style="border-left: medium none; width: 38pt;" width="50">Region</td> <td class="xl65" style="border-left: medium none; width: 74pt;" width="98">New Region</td> <td class="xl65" style="border-left: medium none; width: 74pt;" width="98">Owner</td> <td class="xl65" style="border-left: medium none; width: 71pt;" width="95"> Incident Type</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl63" style="height: 12.75pt; border-top: medium none;" height="17">Wk 29</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">Glue Guns</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">East</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">Africa</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">Albert Thomas</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">Incident</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl63" style="height: 12.75pt; border-top: medium none;" height="17">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">Request</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl63" style="height: 12.75pt; border-top: medium none;" height="17">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">Raghu</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">Incident</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl63" style="height: 12.75pt; border-top: medium none;" height="17">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">Request</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl63" style="height: 12.75pt; border-top: medium none;" height="17">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">Ram</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">Incident</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl63" style="height: 12.75pt; border-top: medium none;" height="17">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">Australia</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">Albert Thomas</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">Request</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl63" style="height: 12.75pt; border-top: medium none;" height="17">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">Brazil</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">Albert Thomas</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">Incident</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl63" style="height: 12.75pt; border-top: medium none;" height="17">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">Request</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl63" style="height: 12.75pt; border-top: medium none;" height="17">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">Others</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">Incident</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl63" style="height: 12.75pt; border-top: medium none;" height="17">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">Request</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl63" style="height: 12.75pt; border-top: medium none;" height="17">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">Raghu</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">Incident</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl63" style="height: 12.75pt; border-top: medium none;" height="17">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">Request</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl63" style="height: 12.75pt; border-top: medium none;" height="17">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">China</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">Albert Thomas</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">Incident</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl63" style="height: 12.75pt; border-top: medium none;" height="17">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">Request</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl63" style="height: 12.75pt; border-top: medium none;" height="17">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">Others</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">Incident</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl63" style="height: 12.75pt; border-top: medium none;" height="17">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">Request</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl63" style="height: 12.75pt; border-top: medium none;" height="17">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">Raghu</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">Incident</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl63" style="height: 12.75pt; border-top: medium none;" height="17">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">Request</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl63" style="height: 12.75pt; border-top: medium none;" height="17">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">Latin America</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">Raghu</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">Request</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl63" style="height: 12.75pt; border-top: medium none;" height="17">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">North America</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">Albert Thomas</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">Incident</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl63" style="height: 12.75pt; border-top: medium none;" height="17">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">Request</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl63" style="height: 12.75pt; border-top: medium none;" height="17">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">Others</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">Incident</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl63" style="height: 12.75pt; border-top: medium none;" height="17">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">Request</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl63" style="height: 12.75pt; border-top: medium none;" height="17">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">Raghu</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">Incident</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl63" style="height: 12.75pt; border-top: medium none;" height="17">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">Request</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl63" style="height: 12.75pt; border-top: medium none;" height="17">Wk 30</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">Glue Guns</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">East</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">Africa</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">Albert Thomas</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">Incident</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl63" style="height: 12.75pt; border-top: medium none;" height="17">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">Request</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl63" style="height: 12.75pt; border-top: medium none;" height="17">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">Raghu</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">Incident</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl63" style="height: 12.75pt; border-top: medium none;" height="17">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">Request</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl63" style="height: 12.75pt; border-top: medium none;" height="17">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">Ram</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">Incident</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl63" style="height: 12.75pt; border-top: medium none;" height="17">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">Australia</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">Albert Thomas</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">Incident</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl63" style="height: 12.75pt; border-top: medium none;" height="17">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">Raghu</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">Incident</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl63" style="height: 12.75pt; border-top: medium none;" height="17">Wk 31</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">Glue Guns</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">East</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">Africa</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">Albert Thomas</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">Incident</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl63" style="height: 12.75pt; border-top: medium none;" height="17">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">Request</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl63" style="height: 12.75pt; border-top: medium none;" height="17">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">Raghu</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">Incident</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl63" style="height: 12.75pt; border-top: medium none;" height="17">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">Request</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl63" style="height: 12.75pt; border-top: medium none;" height="17">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">Ram</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">Incident</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl63" style="height: 12.75pt; border-top: medium none;" height="17">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">Australia</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">Albert Thomas</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">Request</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl63" style="height: 12.75pt; border-top: medium none;" height="17">Grand Total</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">



</td> </tr> </tbody></table>

 

[Datsmart]

I think this is what you are asking to do:

Sub FillMeUp()
    'Insert formulae in all blank cells
    Range("A1").CurrentRegion.SpecialCells(xlCellTypeBlanks).FormulaR1C1 = "=R[-1]C"
    'Change formulae to values
    Range("A1").CurrentRegion.Value = Range("A1").CurrentRegion.Value
End Sub

 

[rajuctech]

Hi Johan,

it not in use....,