Fill down

[JSoto]

Fill Down

I have a series of text that I need to copy down up to the netx. I need a macro, function or formula to be able to do this without doing it manually.

Here is an example:

Before
005
blank
blank
006
blank
blank
007
blank

After
005
005
005
006
006
006
007
007

Can you please help? I can change the values on the blank cells to anything I want.

Thanks!!

[swatsp0p]

Quick way:

Insert a helper column next to your column of data. Assuming your data begins in A14, in B14 place this formula and copy down the desired range:

=IF(A14="",B13,A14)

5
'
'
6
'
'
7
'
'
8
'
'
9
'
'
becomes:
5
5
5
6
6
6
7
7
7
8
8
8
9
9
9


you can then copy this range in column B, paste special/values and delete col A

HTH

Bruce

[JSoto]

Thanks Bruce!!

[swatsp0p]

You're welcome. Glad to help!

Cheers!

Bruce