Hi Everyone,

I have spent the last few hours trying to search the internet/figure this out but for some reason keep running into problems.

I have a workbook that has years for a stock in Column A and information for that year in Column B. B1 is a header and the rest of B has a vlookup formula pulling data for the relevant year. If the stock did not exist in a year, the cells in B will be blank until the first year of the stock. I want to hide this group of rows and no other rows in the sheet. (There are blank rows below this data for formatting purposes) The solution needs to be VBA. Any guidance is greatly appreciated!

Cheers,
Lisa

AAPL High
1976
1977
1978
1979
1980
1981 0.6
1982 0.6