Macro to format future spreadsheets

I print refund checks out of a practice management program and then export the information into Excel. At this point I need to condense the information that comes over because it will now be exported into a bank rec. On my attached file I have manually added columns B, D and E. I added column B because the exported information in column A reads "Check# 12345" and I need just the number in a number format. I added column D and used a Sumproduct formula because some check amounts in column C have multiple lines to equal the total check amount and I only need to see that total check amount. Column E then goes through and marks all of those "extra" lines on a check so I can delete them. I have a macro to do all of the above (still working on the delete part); my question is how to run this on new exported spreadsheets that have more (or less) rows. For example, my attached file has 49 rows. In my Sumproduct formula, I have referenced B2:B49. How does a future macro look when I have (for example) 958 rows?? My rows will ALWAYS vary from week to week.

Thanks for any assistance!!

Hi mconway
This is a different approach. See if this code in the attached does as you require. Let me know of issues.

Please Login or Register  to view this content.