Whats wrong with this?

  • Thread starter Thread starter Metrazal
  • Start date Start date
M

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
 
Hi Metrazal,
Whats wrong with this?
Click to expand...

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

What am I missing? 1
Problem moving data 3
Excel VBA 1
Generate Subtotal Summary from Sheet1 into Sheet2 16
Use of Cell Values Instead of Hard Coding 6
VBA group the number in the Column and Copy to the new worksheet. 0
Type mismatch error 4
Excel 2013 Merge Data 2

Back
Top