Copy,shift + Ctrl, arrow down MACRO

[jd64361]

Hi I created an Use relative reference macro in order to fill out the
blanks in a column that changes tittle every few hundred cells.
Sub add()
'
' add Macro
'
' Keyboard Shortcut: Ctrl+w
'
Selection.Copy
ActiveCell.Offset(1, 0).Range("A1").Select
Range(Selection, Selection.End(xlDown)).Select
ActiveCell.Range("A1:A961").Select
End Sub
the problem is that the macro is stoping in the same range than i
created instead of going down until find the new title and stop there.


columns
A
Rows Nancy This an example of what I am trying to do
can I created a macro tha selects
Nancy a paste it until find the next
title "Carol on this case" a stop
there?









Carol



Martha


Thank you!!

 

[Dave Peterson]

Debra Dalgleish has a macro to do this:
http://contextures.com/xlDataEntry02.html

 

[Pantera]

Debra Dalgleish has a macro to do this:http://contextures.com/xlDataEntry02.html











--

Dave Peterson- Hide quoted text -

- Show quoted text -

Thanks Dave