Macro to fill in cell?

G

Guest

Hi - can anybody tell me how to write a macro for excel to fill in blanks, in
a column with the data from the cell above, til it gets to a non-blank cell,
then repeats?

I want it to copy the cell directly above, then fill in the blanks below
with that number, and continue til it gets to another number, then repeats
with next number etc.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA set thick borders around non empty cells in range 0
Macro to Copy and Paste Cell Contents 2
Append name in the same cell with ' ' 3
Fill in Blanks 6
Code to do a simple clean of one column by copying and pasting(finding and replacing) phrases in adj 4
List sorting and macros 3
Macro for copying cells above empty cells 4
macro for copying cells above empty ones 2

Top