VBA code to insert row and record on it when condition is met

djuksi13

New Member
Joined
Jun 20, 2017
Messages
13
Hi,

I'm quite new in all of this and I came in front of the wall.

I have one .xls with a macro that by entering the data and refreshing retrieves the required data from the database. Macro is doing the refresh. We can write more data (example: multiple contract numbers) and by clicking on the refresh we get all the data in the table.

There appeared to be a need to include barcode on those lists but to add a new line in the table and by entering a number of contract within the table program write down the barcode of that data in a new line. There is a requirement that after the last item of a contract is written, a new row with barcode is added and then new contract number items starts.

Is it possible to create such a request with VBA code?

Thank you in advanced!
 

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.

Forum statistics

Threads
1,223,904
Messages
6,175,295
Members
452,631
Latest member
a_potato

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top