Whats wrong with this?
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 |
Whats wrong with this?
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" wrote in message ... 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 |
All times are GMT +1. The time now is 01:59 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com