Closed

Easy VBA Macro + buttons

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 »

Macro :

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.

Skills: Excel, Visual Basic

See more: how to create a macro in excel 2007, macro excel tutorial, how to create a macro in excel 2016, how to create a macro in excel 2013, excel vba, what is macros in excel, insert button excel 2010, macros in excel for beginners, create directory file macro excel, add macro button powerpoint, delete add cart button zen cart, vba excel buttons titles, reverse look ukraine telephone number, vba web page agree button, vba add ins run macro

About the Employer:
( 65 reviews ) Strasbourg, Guadeloupe

Project ID: #16412064

44 freelancers are bidding on average €23 for this job

schoudhary1553

Hi there..... Warm Greetings We came along with your request for Easy VBA Macro + buttons and we reviewed your project description. We'd like to help you with confidence and satisfying results... We have profe More

€31 EUR in 1 day
(222 Reviews)
7.3
P0L

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.

€30 EUR in 1 day
(234 Reviews)
6.9
avinav606lx

Hi There, I am an expert in Excel VBA with over 5+ years of experience. Ping me to discuss more. Thanks Aman

€29 EUR in 1 day
(152 Reviews)
6.4
ksriniravi

Greetings! Being a full time freelancer working exclusively on Excel based projects, I work on such Excel based tasks every single day. I can add 2 buttons to tab 1 with the required functionality. I have 18 year More

€15 EUR in 1 day
(143 Reviews)
6.6
TonmoyRoy111

Dear client I can write the macro code to do the requirements you mentioned. Please contact me. Roy

€30 EUR in 1 day
(249 Reviews)
6.5
zekovicm

Hi there, As an excel expert I can get this done in few hours . Please feel free to contact me so we can discuss further details. Thank you for taking the time to read my proposal.I am looking forward to hearing fro More

€30 EUR in 1 day
(44 Reviews)
6.0
€23 EUR in 1 day
(29 Reviews)
5.4
VladimirLilenko

Hello, dear sir! I registered at the forum not so long ago, but I already have several completed projects on www.freelancer.com. I am ready to carry out your project in the minimum price and in the shortest possible t More

€15 EUR in 1 day
(40 Reviews)
5.3
SShtv

I have a large and successful practical experience of processing and analyzing data in Excel, including using the VBA. These are screenshots of some of my works. [login to view URL] More

€25 EUR in 1 day
(49 Reviews)
5.4
usmanhassan123

A proposal has not yet been provided

€30 EUR in 1 day
(24 Reviews)
5.1
AlexandrUKR

i can send first draft within 12 h and complete within 24H .

€30 EUR in 1 day
(17 Reviews)
5.0
whitehorsetechn

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

€31 EUR in 1 day
(12 Reviews)
4.9
nadimvicky

My work is to prepare design calculation in excel.I have good knowledge of excel and I am good in mathematics.

€16 EUR in 1 day
(11 Reviews)
5.0
royalcalif

I wish to know little bit more about this sentence 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 More

€30 EUR in 1 day
(49 Reviews)
5.0
periyannas

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.

€14 EUR in 1 day
(22 Reviews)
4.5
supper5guy

Hello there, after reading your project description and with a drive for excellence, with a keen attention to details and with more than 10 years experience working with Microsoft office especially excel vba, i can do More

€14 EUR in 1 day
(24 Reviews)
4.1
VinayOnTask

Hi there, I’d like to be considered for your bid. I am a software developer with a strong background developing excel, access related applications, including excel functions,active x objects, sql server as backend, dat More

€29 EUR in 1 day
(11 Reviews)
4.2
ongskjason

A proposal has not yet been provided

€30 EUR in 1 day
(6 Reviews)
3.6
soltecke

Regards, We are dedicated to the development of tools and solutions for SMEs and general users using the powerful excel tool. We also do not dedicate to statistical analysis and data science. We can develop More

€24 EUR in 10 days
(3 Reviews)
3.0
cixy1983

Hello, I understand this is a simple task of comparing data from the first sheet to the data from the second, and update the first tab accordingly if the data being compared is in the range. I am a VB6 and VBA de More

€24 EUR in 1 day
(2 Reviews)
2.8