autofill on varying range loop vba

[chocoboi]

Hi,

Anyone knows how i can run a vba loop to autofill column A(Product) based on column b(Date)? Thanks a lot

I've tried numerous methods but they dont seem to work.

for instance,

selection.autofill destination:=range(selection,selection.end(xldown))

[TABLE="class: grid, width: 500"]
<TBODY>[TR]
[TD]Product[/TD]
[TD]Date[/TD]
[TD]Price[/TD]
[TD][/TD]
[TD]Product[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Apple[/TD]
[TD]02/02/2014[/TD]
[TD]123[/TD]
[TD][/TD]
[TD]Date[/TD]
[TD]Price[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]02/02/2014[/TD]
[TD]123[/TD]
[TD][/TD]
[TD]02/02/2014[/TD]
[TD]123[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]02/02/2014[/TD]
[TD]123[/TD]
[/TR]
[TR]
[TD]Pear[/TD]
[TD]02/02/2014[/TD]
[TD]321[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]02/02/2014[/TD]
[TD]321[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</TBODY>[/TABLE]