Copy a cell down

[LDale]

I need a way to fill in the blanks in the column. Need to copy the information in a cell down the blanks cell until it comes to a cell with information then copy that information down the next filled cell. Continue this until all cells in the column are filled.

 

[T. Valko]

I need a way to fill in the blanks in the column. Need to copy the information in a cell down the blanks cell until it comes to a cell with information then copy that information down the next filled cell. Continue this until all cells in the column are filled.

Is this what you want...

Let's assume this is your data:

Book1
	A
1	10
2
3
4	5
5	4
6
7
8
9
10	1
Sheet1

And you want to end up with this:

Book1
	A
1	10
2	10
3	10
4	5
5	4
6	4
7	4
8	4
9	4
10	1
Sheet1

It's simple to fill in the blanks...

Select the range in question. In this example it would be A1:A10.
Hit function key F5
Click Special
Select Blanks>OK
Type an = equal sign
Press the UP directional arrow key
Hold down the CTRL key then hit Enter

 

[hiker95]

LDale,


Try this on a copy of your data first:


Select the column of data, press F5, click Special, tick Blanks, click OK.
Press =
Press Up arrow
Press CTRL + Enter

 

[LDale]

Thank you! I really appreciate the help.