I'm the one trying to do the if a=b the copy c to d .......I appreaciate all
the help I got............

I put the macro into the VBA of the file (someone told me how to do the VBA
programming)......... problem is and I feel really stupid here..... I'm not
sure what the variables are..... here is the suggested statement.

Private Sub Worksheet_Change(ByVal Target As Range)

If Range("A1").Value = Range("B1").Value Then Range("D1").Copy
Range("E1")

End Sub


I am no longer trying to jump from different sheets. Just different areas
of the same worksheet. Is .Value a variable or part of the formula? I
assume Range is a predesignated range I have created.

Next. Once I have it set up in VBA. How do I save and execute it? I went
all through the VBA help files and nothing says how to save or execute a
program created ....... I need this to repeat for about 900 rows of data and
in 8 columns.

I'm determined. I know this can be automated. Please help...... I'll
consider naming my first born great great grandchild after you (other first
taken already).

Marie