VBA to look for blank cells in range and copy with value above

[jj72uk]

Im currently using a web query to get some external data for some sales people.

In this case these sales people usually cover 2 brands.

The way the SAS code is driven when displayed on our intranet means that the sales agents ID will only display for one of the brands and the correlating second brand will always be below, but the ID will be missing.

Is there a VBA macro that can be written that will look in a range of cells in a coloum, look to see if its blank and then copy the value from the cell right above it into it?

I've attached a sheet to show what I mean.