Excel 2007 VBA code to copy and paste row data into new tabs based on a number range

[srsneezealot]

I saw similar posts using vba to copy data into other sheets based on specific values, but I couldn't find code on a range of numbers. Example I have account numbers from 45000-79010, and I need separate tabs based on different ranges of the account numbers.

All my data is on one tab ("Data"). The account numbers are in column C, and the PD Variance is in column I. I need the data rows copied to tabs based on the ranges 45000-56099, 45000-56099, 56100-56999, 67000-67999, & 68000-79010. Then I need data rows copied to new tabs based on the same account ranges, but also based on the PD Variance. For example I need tabs 45000-56099 when the value in column I is greater than or equal to $100,000.

I was planning on using a template so I would just need the code to copy the data into each tab. So I would have a header on the first row, but the data would go into the second row of each tab. My tabs would be named based on the range, and data, so I would have 45000-56099, 45000-56099GT100K, 56100-56999, 56100-56999GT100K, etc.

If I can get the basic code to do this, I can probably manipulate it for my specific ranges, and names, etc.


Let me know if you have any questions, hopefully I was specific enough.
Thanks,
Preston