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!
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!