hey guys i want to know if this is possirable with excel?
i want the user to insert information into the cell and coloums of excel document and insert into a database, the problem come when populating a coloum with like a dropdown selection where the user can insert any number of rows has long has it is in the right coloum.
i have found out how to use vba in excel and know how to insert i line and cells into a database, my problem is unknow rows and how to fomat a cell like a dropdown from a database.
or yes and is it possirable that each time a move to the next row that a new line to insert a record.
i know it is hard to do but its my client request.