Hi, Please read my message in your inbox (Private message) as I have spent more than 3 hours for your project.
Your requirement:
After connect/get access the portal, under the ''Fatura olustur'' section, user has to copy data from excel and select/paste it in the appropriate fields (Paste if the field is Text box, Select if the field is Drop down/Date picker). Total fields in Fatura Oluştur are ~36, and ~9 fields are mandatory. (Aprx) Excel file may contain numerable data.
Best Solution:
Automation is feasible. My macro will instantiate the web browser (Internet Explorer) and will navigate to the efatura URL and connect to portal. Once connected, the data in excel file will be copied and pasted in the respective fields of ''Fatura olustur'' Section. Once done, the 'Oluştur' button will be clicked in order to create the invoice (olustur).