Look the file attached !
In Tab 1 :
Column A is « HS Code »
Column B is « TVA »
In Tab 2 :
Column A is « (start) HS CODE »
Column B is « (until) HS CODE »
Column C is « TVA »
Column D is « DESIGNATION DES PRODUITS »
If the value (number) in Tab 1 / Column A is between the numbers in Tab 2 / Column B & C so change in Tab 1 / Column B his value thanks to the value in Tab 2 / Column D.
Create a button in Tab 1 to active the macro and another one to clean.
I will add and delete HS CODE & TVA values in Tab 2 in the future.
43 freelancers are bidding on average €23 for this job
Hello, I’m an Excel expert and I would like to help you with your project. I'm fully available and I can start right away. Please check my profile and contact me to discuss. Regards.
Hi, Nice to know your requirement. I am an excel vba, vb6 expert and have delivered ten excel vba projects in the past two months. Willing to take up your project. Thank you, Regards.
Greeting, I have understood your Easy VBA Macro + buttons task and can do it with your 100% satisfaction. Please ping me for more discussion. I have more than 5 years of experience in Excel, Visual Basic