Irregular transfer "non-consecutive" Sheets

Here you can,

Transfer data from a Worksheet to a Worksheet. To make this easier, this Destination Worksheet will now be called the "Database". The transfer is made to a Sheet whose destination columns do not follow each other. e.g., transfer to cells that are in columns A, D, E, etc.

Transfer or transfer values from your Worksheet without repetition,

Simply delete or delete after a confirmation,

Edit and save your new values,

Search in a column, Cell, TextBox or anywhere,

Reset your fields in the Worksheet after Transfer or as soon as you open your application,

Simply insert the requested value in the box, click on the "Get code" button and Hop, the code appears in the square at the very bottom of the page… copy it and paste it into your UserForm…That's it 🙂


Nom Feuille de calcul:


Nom Cellule de recherche:


Nom Base de données:


Nom Colonne de recherche dans la Base de données: