I'm trying to create a macro that will look for a value from a Column and if
it finds that value copy a $ amount in second column on the same row to a
third column.

I am trying to seperate Credits and Debits in the same column to 2 different
columns.

Column 1 has a value of C or D. Column 2 has the $ amount.

I want to take all of the $ amounts in Column 2 that have a C in Column 1
and copy it to a third column.