Thread: coping cells
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
JJMNZ76 JJMNZ76 is offline
external usenet poster
 
Posts: 3
Default coping cells

Thanks to all,

"Dave Peterson" wrote:

Debra Dalgleish has some techniques:
http://www.contextures.com/xlDataEntry02.html



JJMNZ76 wrote:

Saludos...

What would the code in vba be for the following , Kind of new vba and stil
haven't got the hang of loops.

I have a sheet the looks like the following. How can I make it so it copies
CODE1 in the blank cells till it reaches code2 , then copy code 2 in the
blank cells between code2 and 3 and so on.

a b c
Code 1 Juan 22 days
Pedro 14 hrs
Luis 15 day

Code 2 Juan 5 days
Pedro 3 hrs
Luis 2 day

Code 3 Juan 2 days

and so on.


--

Dave Peterson