Thanks Dave! You are a savior! This is it!

"Dave Peterson" wrote:

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

Mike wrote:

I have seen the following where I want to copy down specially ONLY INTO THE
BLANK SPACES, but don't remember how to do this. Any ideas is greatly
appreciated. The example below best demonstrates the need.

ORIGINAL (example of the cells, separated by spaces)
A C Y I U
D E R P
X
T B

When I do the special copy down, I want it to look like the following:
A C Y I U
A D E R I P
A X E R I P
T X B R I P
T X B R I P

Essentially, what I saw a long time ago, was a 3-4 step process where my
friend:
1. Selected all the cells
2. Somehow did something to deselect the populated cells and only have the
blank cells
3. Fill down from the line above

Any help is appreciated! I know this can be done without macros.

Thanks!

--

Dave Peterson