I have a list of CDs that have maturity dates. when i select a certain date in the future, the table lists down the CD's that will be expired by then. This is done by an excel formula. that said, this list can expand or contrast according to the date selected (date is selected via a drop down list in cell L45). Once the list populates, the user should manually input (hard coding) the new interest rate in percentage (Column L) at which this CD will be renewed at. What i was trying to do here is that if a later date is selected and the interest rates were already manually input, then the user decides to select an earlier date, the list would shrink and so the interest rate that was manually input should then be removed automatically. Please see image 1 and 2 to fully understand what i am trying to do. you will notice in image 2 that the hard coded interest rate in % was removed because the code fired up after I added the End if after the Next CD as per Fluff recommendations.
The sheet is very slow after using this code. I am trying to write this code as an array to speed it up but I am not sure if i will be successful at writing it
correctly.
View attachment 64058
View attachment 64057