Copy the value of the cell immediately above

[The Salad]

Hello, I hoping someone can help me or point me in the right direction.

The reports I have been given to analyse have names down one column but only the first line is populated with the name of a company for several entries making it very difficult to do any detailed analysis eg Pivot.

I'm not too hot with Macros but is there a Macro I could run which would populate the cell immediately above it with the same value until it reached a populated cell, miss that cell out and then carry on populating the cell above with the same value. And so on . . . . and stop when it reached a cell that perhaps maybe I had populated with something specific.

Have included a sample of what I mean.

[BigBas]

Based on the example you have given, try this macro:

Please Login or Register  to view this content.

[The Salad]

Many thanks.

I also Google'd the problem and found this little beauty . . .

Select all the data in the column, then go to Edit>Go To.... Ctrl+G and then click Special. Check the Blanks option and click OK. This will now have selected only the empty cell within the list. Then push the Equals (=) key, then the Up arrow and finally, holding down the Ctrl key, push Enter.

Cheers . . . . . .