Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Easy Problem that I can't figure out | Excel Discussion (Misc queries) | |||
date copy paste should be very easy | Excel Discussion (Misc queries) | |||
Copy/Paste question | Excel Worksheet Functions | |||
fairly easy (i thought) copy and paste cells, increment by 17 accross | Excel Discussion (Misc queries) | |||
fairly easy (i thought) copy and paste cells, increment by 17 accross | Excel Discussion (Misc queries) |