Copy/Paste cell down to next value- Easy question, can't figure it

[J. Catz.]

I have a list of names with a random # empty cells in between - and there's
215 of them (see below). All I want to do is copy A until B begins, then B
until C begins, etc. When I record the macro, well, it doesn't work - it
takes the last name I landed on, and pastes it in all of the cells I already
populated . I could have sworn i've done this before, but for the life of
me, can't get it to work again. It will save me about 3 hours of my life if
I can get it to work. Help, please?

COLUMN A
A
blank cell
blank cell
B
blank cell
blank cell
blank cell
C
blank cell
D
blank cell
blank cell
blank cell
blank cell
E - through whatever would take me to a total of 215.

 

[J. Catz.]

Never Mind - figured it out, and can't delete my own post. Sorry if I wasted
anyone's time!

 

[shyhacker]

Never Mind - figured it out, and can't delete my own post.  Sorry if I wasted
anyone's time!






- Show quoted text -

Suppose Sheet 1 have a value
Serial num Telecommunication client Cliet hos
1 bsnl 99%
2 bsnl 99%
3
4
5 vodafone 98%
6 hutch 97%
7
8
9 idea 96%
10 o2 95%
11
12
13 Rtl 95%



write this macro

Sub Macro3()

Columns("A:C").Select
Selection.Copy
Sheets("Sheet2").Select
ActiveSheet.Paste
Range("B1").Select
Application.CutCopyMode = False
Selection.AutoFilter
Selection.AutoFilter Field:=2, Criteria1:="="
Rows("4:34").Select
Selection.Delete Shift:=xlUp
Selection.AutoFilter Field:=2
Rows("1:1").Select
Selection.AutoFilter
End Sub