View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
shepshedlad
 
Posts: n/a
Default populating empty cell with value from above


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