populating empty cell with value from above
 

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

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

populating empty cell with value from above
 

sorry but the layout has altered in my last post: there are 3 columns,
1:Date 2:Customer 3:product

column 1 & 2 are empty when customer places more than one product.

Thanks
Rob


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

populating empty cell with value from above
 

Select entire range then F5SpecialBlanksOK

Type an = sign in active blank cell then point to cell above and hit CTRL +
ENTER.

CopyPaste Special(in place)ValuesOKEsc.


Gord Dibben Excel MVP

On Wed, 23 Nov 2005 06:46:37 -0600, shepshedlad
wrote:


sorry but the layout has altered in my last post: there are 3 columns,
1:Date 2:Customer 3:product

column 1 & 2 are empty when customer places more than one product.

Thanks
Rob

populating empty cell with value from above
 

Interesting

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Select entire range then F5SpecialBlanksOK

Type an = sign in active blank cell then point to cell above and hit
CTRL +
ENTER.

CopyPaste Special(in place)ValuesOKEsc.


Gord Dibben Excel MVP

On Wed, 23 Nov 2005 06:46:37 -0600, shepshedlad
wrote:


sorry but the layout has altered in my last post: there are 3 columns,
1:Date 2:Customer 3:product

column 1 & 2 are empty when customer places more than one product.

Thanks
Rob