VBA for Migrating Excel DataTables

[Kevin Briere]

Hi There,

Happy Friday! I am working on a project that is migrating datatables and will allow us to query more data, but many account details are changing. We have a look up table which maps old accounts to the new format, but all I think of to efficiently do this if vlookups. I was wondering if there is a quicker way via VBA.

I haven’t started trying to write anything yet.

 

[Chihiro]

If you have LookUp table, depending on the version of Excel you are using and how your table is set up. You may be able to use linked table feature. No need for coding.

https://support.office.com/en-us/ar...add-a629-8a3848820be3?ui=en-US&rs=en-US&ad=US