Macro to follow this simple procedure

Hi All,

I usually do the steps below manually. Wondering if someone can help me with a macro for that:

1) Select cells from B3 to the last populated cell in the column B
2) Unmerge cells
3) Select blank cells (usually I do that going to the HOME tab, then FIND & SELECT, then GO TO SPECIAL, then BLANKS)
4) In the first blank cell (usually B4), write to be equal to the cell above (so I would insert in B4, "=B3")
5) Control enter, so it can copy across all blank cells
6) Copy and past values

Example sheet attached.

Thanks very much.

Rick

You could record the steps...

Please Login or Register  to view this content.

Originally Posted by jindon

You could record the steps...

Please Login or Register  to view this content.

Hi jindon,

When I do it manually, when I copy and paste, numbers that are in text format keep in text format, but with the macro all text numbers turn into number format.

There is a way to keep numbers as text, when pasting value?

Thanks

Try change

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Note: Please do not full quote of someone else's post unless it is really needed. It is just wasting the space...

As always thanks jindon for your help.

Have a good day!

Rick