Return value in a column based on conditions matching with different column

**sanits591** · 12-14-2009, 04:27 AM

Hi, I am new to this forum, and would appreciate for providing me a help in correcting my code to save time in ruuning this code for the file, as it takes time more than 30 minutes for the entire coulmns from 5 to 100 (in the vba code) to get filled up for the installments pattern.

Attached file gives the entire view on this.

Anticipatory thanks.

**davesexcel** · 12-15-2009, 01:22 AM

What is your code supposed to do?
Part of it doesn't make sense like

Please Login or Register  to view this content.

**sanits591** · 12-15-2009, 01:28 AM

Thanks Dave to have a look on this. This particular code first check for any previous entry, (could be due to different installment amount by changing other parameters), and then fills up the columns with he next code which is below to this code.