Thread: copy question
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
srroduin srroduin is offline
external usenet poster
 
Posts: 34
Default copy question

I am trying to replace all blank lines with the first data found in the
column above it. This is what I have:

column c
srp
blank
blank
blank
sgs
blank
toc
blank
This is what I need:

srp
srp
srp
srp
sgs
sgs
toc
toc


any ideas????