Whats wrong with this?

[Metrazal]

If Worksheets("SJournal").Cells(t, "A") = Worksheets("Invoice").Cells(t, "B") Then Worksheets("Invoice").Cells(t, "J") = Worksheets("SJournal").Cells(t, "J")
If Worksheets("SJournal").Cells(t, "A") = Worksheets("Invoice").Cells(t, "B") Then Worksheets("Invoice").Cells(t, "K") = Worksheets("SJournal").Cells(t, "K")
If Worksheets("SJournal").Cells(t, "A") = Worksheets("Invoice").Cells(t, "B") Then Worksheets("Invoice").Cells(t, "L") = Worksheets("SJournal").Cells(t, "L")
If Worksheets("SJournal").Cells(t, "A") = Worksheets("Invoice").Cells(t, "B") Then Worksheets("Invoice").Cells(t, "M") = Worksheets("SJournal").Cells(t, "M")
Next t

Thanks,
Met

[Norman Jones]

Hi Metrazal,

> Whats wrong with this?

It would improve your prospects of receiving a useful response if you were
to indicate the specific problems which you experience with the reported
code.


---
Regards,
Norman


"Metrazal" <[email protected]> wrote in
message news:[email protected]...
>
> If Worksheets("SJournal").Cells(t, "A") = Worksheets("Invoice").Cells(t,
> "B") Then Worksheets("Invoice").Cells(t, "J") =
> Worksheets("SJournal").Cells(t, "J")
> If Worksheets("SJournal").Cells(t, "A") =
> Worksheets("Invoice").Cells(t, "B") Then Worksheets("Invoice").Cells(t,
> "K") = Worksheets("SJournal").Cells(t, "K")
> If Worksheets("SJournal").Cells(t, "A") =
> Worksheets("Invoice").Cells(t, "B") Then Worksheets("Invoice").Cells(t,
> "L") = Worksheets("SJournal").Cells(t, "L")
> If Worksheets("SJournal").Cells(t, "A") =
> Worksheets("Invoice").Cells(t, "B") Then Worksheets("Invoice").Cells(t,
> "M") = Worksheets("SJournal").Cells(t, "M")
> Next t
>
> Thanks,
> Met
>
>
> --
> Metrazal
> ------------------------------------------------------------------------
> Metrazal's Profile:
> http://www.excelforum.com/member.php...o&userid=31648
> View this thread: http://www.excelforum.com/showthread...hreadid=516199
>