I daily upload data from an excel sheet onto a website by the good old copy-paste method. the excel sheet contains order details such as
item number, item title, buyer's name, buyer's address, phone number, etc. i copy the relevant details of the customer (name, address, phone) and paste it into the relevant boxes in the browser, one by one, and save and move to the next customer. as you can imagine, it's pretty time consuming, especially during days when I have to process 100+ entries.
I was wondering if there is a script that would automatize this. Something like this: I select customer 1's details (name, address, phone cells all together selected) and the script would copy-paste the information into the appropriate boxes in the browser. If it could hit the save button as well, then all the better. Then I select customer 2's details and so on.
I am not sure if this is the ideal way of designing it, but since there is no option of saving all at once, I imagine the above is as quick as it could be.
I am a total newbie, hope you don't mind if this is a straightfwd task.