G
gf921
Dear all , i have a vba execl question here. I have a two sheets
worksheet ( HPTB and Statement ). HPTB is my trial balance which has 9
columns ( A - I ) , column c is invoice number and column H is amount ;
Statement is vendor's trail balance which has 7 columns ( A - G ) ,
column B is invoice number and column F is amount.
What I try to do is compare these two columns , if they are same
invoice numbers i want to calculate the difference ( use Statement
amount - HPTB amount), and if the difference is Nil , i want to delete
these two rows ; if the difference not Nil , I want to leave this rows
and highlight this rows in yellow color .
Another problem is sometimes HPTB's invoice number not in Statement and
sometimes invoices number in Statement but not in HPTB . In this case ,
i want to leave this whole row and highlight in red color.
can i do all of above by insert a new sheet in this worksheet under the
name of " working sheet " ?
Thanks so much if anyone can give me the vba code .
worksheet ( HPTB and Statement ). HPTB is my trial balance which has 9
columns ( A - I ) , column c is invoice number and column H is amount ;
Statement is vendor's trail balance which has 7 columns ( A - G ) ,
column B is invoice number and column F is amount.
What I try to do is compare these two columns , if they are same
invoice numbers i want to calculate the difference ( use Statement
amount - HPTB amount), and if the difference is Nil , i want to delete
these two rows ; if the difference not Nil , I want to leave this rows
and highlight this rows in yellow color .
Another problem is sometimes HPTB's invoice number not in Statement and
sometimes invoices number in Statement but not in HPTB . In this case ,
i want to leave this whole row and highlight in red color.
can i do all of above by insert a new sheet in this worksheet under the
name of " working sheet " ?
Thanks so much if anyone can give me the vba code .