$$Excel-Macros$$ Re: loop problem.

2009-05-06 Thread Sastry
You can use SUMIF function. 2009/5/6 Samir Agayev saga...@gmail.com Dear Group members, In attached excel file, I have a little vba code. It gets data from Column B in Sheet2 to Column D in Sheet1 if Column D in Sheet2 equals Column A in Sheet1. The only problem occurs when the Items of

$$Excel-Macros$$ Re: loop problem.

2009-05-06 Thread Akhilesh Karna
You can use the following code (slightly changed from original). Sub RedemptionsUSD() Dim ModelCash As Worksheet Dim CashFlow As Worksheet Set ModelCash = Workbooks(Model.xls).Worksheets(1) Set CashFlow = Workbooks(Model.xls).Worksheets(2) Dim j As Integer Dim c As