Hi, I have a little problem, so maybe one of you skilled members can help me out.
I would like to make a piece of VBA code that will copy the data from B3:C11 (fist sheet) and put it into the individual columns (second sheet). The columns are named ID, name, e-mail, phone, value, adress.
The second sheet should therefore act as some kind of database, where new entries are put below the last one. Also, it would be great if the program checked at first whether the ID is already written in the sheet2(database) and if so, it would write an error message.
Does anyone know how to achieve this the least difficult way? I am not very skilled with VBA.
Thanks. Any help will be appreciated.
P.S.: I have included the sampleAttachment 336217
Bookmarks