Dear Akhilesh Karna,
Thank you very much for your help.
On Thu, May 7, 2009 at 9:56 AM, Akhilesh Karna wrote:
> You can use the following code (slightly changed from original).
>
> Sub RedemptionsUSD()
>
> Dim ModelCash As Worksheet
> Dim CashFlow As Worksheet
> Set ModelCash = Wor
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 Int
You can use SUMIF function.
2009/5/6 Samir Agayev
> 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 Column D i
