Hi I have column w30:w80 which is linked to column b30:b80. However column B has blanks in it so I would like column W to copy the cells in B respectively and if they are blank use the value above it. I will be constantly changing column B so guessing I need a vba.
Cheers
Dave
Bookmarks