Archive of Mr Excel Message Board

Back to Edit in Excel archive index
Back to archive home

Auto Filling Cells

Posted by Lee Hitchen on December 07, 2001 2:11 AM

I have a value in a1 which I wish to replicate until a 'new' value occurs (in this example cell a14)continuing all the way down to cell a3124 with numerous value changes along the way. Can anybody please let me know how this can be done? I suspect it will require a macro although the functionallity may already reside in Excel.

Many thanks in advance.

Lee

Re: Auto Filling Cells

Posted by Mark W. on December 07, 2001 6:28 AM

It doesn't require a Macro...

1. Select column A:A
2. Choose the Edit | Go To... | Special Blanks
menu command. (Note: In addition to selecting
all of the blank cells this command will make
the 1st blank cell (A2 in your case) the active
cell.
3. Type a reference to the cell immediately
above the active cell (e.g., =A1) and press
Control+Enter.
4. Re-select column A:A and perform a
Copy/Paste Special Values to preserve the
results.

Re: Auto Filling Cells

Posted by Lee Hitchen on December 07, 2001 7:05 AM

Many thanks Mark, works a treat!!

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.