Excel Macro

I want to create an excel macro application with few textbox and button. On click of the button the dynamic SQL code to be written. Planning to use that query to send to backend.

Please find the attached image

Step1 : By default the form shows one set of data for user creation(User 1)

Step2: If user press the + button then the User1 should be cloned and next box should show as User 2

Step3: if the user fill the data and then if he pressed Create user then the script to be genereated like the below and capture it in .sql file.

INSERT INTO table_name (column1, column2, column3, ...)

VALUES (value1, value2, value3, ...); -- user 1 details

INSERT INTO table_name (column1, column2, column3, ...)

VALUES (value1, value2, value3, ...); -- user 2 details

Skills: Excel

See more: macro excel 2003 calc, paste area macro excel, script macro excel 2003, excel, visual basic for apps, macro excel web, excel spreadsheet creation, excel spreedsheet creation, data mining macro excel, excel macro front end creation, copy next cell macro excel, copy website macro excel, macro excel string manipulation, macro excel open sort output, show print macro excel, install macro excel, convert excel 2000 macro excel 2007 macro, vba macro excel unicode, query macro excel, macro excel cells

About the Employer:
( 7 reviews ) Chennai, India

Project ID: #13700511

Awarded to:


Hi, I can create a solution like this. 1. Default layout will be used to insert one record. 2. On click of button, data will be copied to another sheet and the default layout will be emptied to insert new record More

₹4444 INR in 3 days
(9 Reviews)

6 freelancers are bidding on average ₹2050 for this job

₹2000 INR in 3 days
(8 Reviews)

samples of my vba macro jobs More

₹1500 INR in 1 day
(8 Reviews)

I am very interested in your offer. I have broad experience with Excel because I work with it every day for more than 20 years. I can usually finish a standard work in a single day, but it depends on the type of task. More

₹1500 INR in 1 day
(3 Reviews)

Good Day Sir, I appreciate your time very importantly, so I'm please to put my efforts and my time in your service. ------------------------------------------------- Important Notes ---------------------------- More

₹1750 INR in 1 day
(1 Review)
₹1550 INR in 2 days
(0 Reviews)
₹2000 INR in 3 days
(0 Reviews)