This is my current project:
I’ve a list of invoice number in a sheet call “input”. Had build the robot to pick invoice number and search in a web and then scrape some data there. After that the scraped data should paste in “output” sheet in column B. In column A - should specify the respective invoice number (which was looped).
Issue that I’m facing:
- How to specify the respective invoice number (which was looped) in column A as shown in below screenshot. (blue highlight - looped invoice number, red highlight - scrapped data)
- What should I do to paste the scraped data into the last row (in this case, next scrapped data for next invoice number should paste at row 18)
- How do I compeletly clear content of old data in “output” sheet
Hope you guys could help me out.