Compare and update table in VBA

[Shaun]

Hi All,

I have two tables:

• COA; and
• UPCOA.

The COA table is the table which the user works with to categorise various account (in cloumn G).

The UPCOA table is the imported table from a database which contains the latest information from which the COA table requires updating.

From time to time new accounts are created which need to be reflected in the COA table (see TEST1 and TEST2 on the UPCOA table).

As the user will categorise accounts in an additional column within the COA table, I don't want to loose that information.

My unsuccessful approach has been to copy the additional row from the UPCOA table and paste in the COA table. I have been unable to paste the row in the COA table.

I am also concerned that because I am starting from the top of table things will get tricky after inserting a new row in to the COA table, though I am not sure as I have been unable to get it to work.

I would also like some sort of indicator where the user can see where a new entries are and require a category to be applied against those new entries.

I hope someone is able to please point me in the right direction.

Thank you in advance.

Cheers,

Shaun

 

[NARAYANK991]

Hi Shaun ,

See if this is acceptable.

Narayan

 

[Shaun]

Hi Narayan

Thank you for your reply.

Your code does what I am trying to achieve, except I would like the code to do the checking for the new accounts, not the user identifying the new accounts. Is that possible?

Cheers

Shaun

 

[NARAYANK991]

Hi Shaun ,

If you see the table in the UPCOA tab , it is the formula in the column labelled New , which is deciding whether a record is New or Old ; it is designated as New if there is no match for the record in the table in the COA tab.

Narayan

 

[Shaun]

Hi Narayan

I completely missed that, sorry.

It will take sometime for me to work through.

Thank you.

Cheers

Shaun