I have a workbook that consists of two tabs, table and data. What I am needing to do is take the accts on the "table" tab and find them on the "data" tab. When it finds one, change the content from what it shows on "table" and replace it in "data". If it can't find any acct then just leave things alone.
I know we can use lookups and such but what i would like to do is to be able to automate this process using a VBA script so that it is done without formula's.
I have attached a test workbook that I think explains things better than I have done. Any help would be greatly appreciated.