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

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.

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

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

"J. Catz." wrote:

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.

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

On Oct 7, 4:06*am, J. Catz. wrote:
Never Mind - figured it out, and can't delete my own post. *Sorry if I wasted
anyone's time!



"J. Catz." wrote:
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.- Hide quoted text -

- 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