Yes, I think this is what I'm looking for. In your coding below, all that
would need to be changed is the 'some value and 'some formula?

I'm sorry if this sounds like an elementary questions, but I am :)

Thanks, Laurie


"JLGWhiz" wrote:

You could probably use a For...Each...Next loop to run colum CC?CT and if a
match is found, use use the found cell row reference to populate the cell in
column "Default"

exmpl: Dim rng As Range
Set rng = ActiveSheet.Range(Cells(2, "CC/CT"), Cells(100,
"CC/CT"))
For Each c In rng
If c = 'Some value Then
ActiveSheet.Cells(c.Row, "Default") = 'Some formula
End If
Next


"Alberta Rose" wrote:

I have a spreadsheet that has different row numbers each month. I have a
column in this spreadsheet called Default that needs specific formulas put in
depending on another column's data (called CC/CT). Since the position of
these rows varies each month, I need to write a macro that goes through the
CC/CT column and assigns the proper formula in the Default column, depending
on the CC/CT. I think I need a Loop macro as well as a Find Macro but have
not had much experience in either in Excel. Can anyone give me guidance?

Thanks....Laurie