Filling in blank cells with combination of text and increasing number

[joe_schmo95]

Hello,

I'm trying to use a macro to fill in any empty cells within a column (up until the last active row) with a specific word followed by a number that increases by 1 for each empty space that gets filled. So the first space would read "WAVE 1", then the second would read "WAVE 2", and so on. Inserting the text isn't the problem, it's the increasing integer that's giving me issues. I've attached a file with two sheets - one with the starting data and the second with the intended result. Any help would be appreciated, thank you!

[sintek]

One way...

Please Login or Register  to view this content.

[joe_schmo95]

That worked perfectly! Thank you so much for the help!!

[sintek]

Pleasure ... thanx for rep +