How is the cell B1 being populated?

You could have a macro that if file/data being imported into B1 <0 then
insert a cell at B1 and move all the data down. If the cell in B1 is
part of a report have a data sheet, that way the report could pull from
this data sheet as well.

If you are querying a datbase for the result/data in B1 maybe you need
a smarter query that pulls a series of data into the above proposed
data sheet.

Stopher