Copy certain cells to a different sheet based on a cell's value

Hi!

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

Please Login or Register  to view this content.

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.

Thanks!

Maybe:

Please Login or Register  to view this content.

Originally Posted by JOHN H. DAVIS

Maybe:

Please Login or Register  to view this content.

This worked great! Puts in an extra blank row at the top, but I can deal with that. Thanks!

Weird that it looks so much like what I have been using, but works.

You're welcome. Glad to help out, and thanks for the feedback. Please comply with Forum Rule No. 9.

9. Acknowledge the responses you receive, good or bad. If your problem is solved, please say so clearly, and mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved". Or click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Dropdown option or Edit button will not appear -- ask a moderator to mark it.

Modified:

Please Login or Register  to view this content.