I've been beating my head against my desk for the past few days trying to figure this out. It seems so easy, yet just wont work. We are pulling in credit card information and need to extract data from it and format it for an input into our accounting system. There are 16 rows that look like this
Basically I need to only pull data out of the rows that have "Subtotal" in column A. It will then copy data from columns G, I, J and E into a different sheet.
The problem I am having that apparently with the numbers right after it, none of the scripts I have tried works. They either copy nothing, or delete everything.