Hey there!
First things first: I’m not a native english speaker, so I apologize in case my wording sounds weird.
I need some help the create a macro and I’m happy to pay you if you could help me on this. Not sure how difficult it is to create a macro for this task, but I could pay 25$ - 50$.
What should the macro actually do? Filling out a google form over and over again with data from an excel sheet OR google sheet. Not sure if it’s easier to switch between 2 tabs or between a tab or excel. That’s up to you. The spreadsheet will look like this:
Cell 1: Link
Cell 2: Name
Cell 3: Text
Cell 4: Link
Cell 5: Name
Cell 6: Text
etc
The macro needs to:
- Open google form
next field - Choose a specific name in a dropdown menu
next field - Enter #NAME
next field - Choose something from a dropdown menu
next field - Enter #TEXT
next field
6.) Choose something from a dropdown menu
next field - Enter #LINK
next field - Enter specific text (i.e. #sentence1), enter #TEXT, enter specific text (i.e. #sentence2)
next field - Submit form
- start from 1, but using #Name, #link and #test from the next cells (4-6) and so on.
Honestly… I’ve been trying to set this up since hours, but it doesn’t work. Not sure if that’s because I tell the program to press “down, down, down, down, enter” in order to choose the name from 2) or if that’s because changing programs doesn’t work properly.