Assuming first date is in row 2
last prod# is in row 15005
no blank rows between prod1 to prod#
then try

Sub t()
for i = 3 to 15005
if range("a" & i)="" then
range("a" & i)=range("a" & i-1)
range("b" & i)=range("b" & i-1)
end if
next i
end sub

"shepshedlad"
wrote in message
...

Hi,

I have a large worksheet (15000 rows) which contain orders (simplified
as follows)

DATE[/b] *CUSTOMER* [b]PRODUCT
10/10/05 Joe Bloggs Prod1

Prod2

Prod3
11/10/05 Ian Brown Prod1

Prod2

My question, how do I populate the empty cells within the Customer &
Date column so that all products have their respective customer/date
next to them?

Any help would be very greatfully received.

TIA
Rob


--
shepshedlad
------------------------------------------------------------------------
shepshedlad's Profile:
http://www.excelforum.com/member.php...o&userid=29032
View this thread: http://www.excelforum.com/showthread...hreadid=487595