I have looked at that spread you linked to me and I understand what you mean:
B127 is the last data entry and B128 is still empty. . No problem! On Row 128 there is no Data Entry yet so the calculation could not be done anyway, and I always duplicated the precious price in the cells below.
If the prices in B129 and B130 are filled in and B128 is empty then the calculation goes haywire in that spread too!.
I noticed that in that spread there is an Automatic Row Addition Feature installed.. . ARAF
I have not even learned how to do that! No doubt it is an simple statement. But below the last Row I have various information blocks, so if I ad rows I have to move these down first. . unless that can be done automatically too.
Register for free to join our community of investors and share your ideas. You will also get access to streaming quotes, interactive charts, trades, portfolio, live options flow and more tools.