Hello All,

I'm trying to automate a repetitive action. Here is ideally what I'd like to be able to do:

Paste all invoice #'s in column A of an Excel sheet. In this example, let's name it "Invoices"

Execute Macro to:
1. Take A1 invoice # from "Invoices" sheet
2. Open Google Chrome
3. Go to company internal website
4. Select specific source from a drop down menu on the website
5. Paste the invoice # into the field on the website
6. Hit submit
7. Take screenshot once page loads
8. Create new sheet in same Workbook. Let's name it "Screenshots"
9. Paste the invoice number in A1 of screenshots sheet
10. Paste screenshot in A2 of screenshots sheet
11. Repeat for all invoices listed in Invoices sheet but continue to paste the invoice # and screenshot to a set number of cells down (so the screenshots don't cover the invoice #

Any help/advice on this would be great. Would I be able to just record a macro and perform those steps and make edits or what would be your recommendations?