Macro for various topics

[mbrown009]

I am completely new to this macro business in Excel. Well to at least write them.

I have a big csv excel file that has any where between 20-50 worksheets.

There a few options I would like to do

Option 1

• Remove the first 10-11 rows in each worksheet
• Count the number of rows are 30 days past, 60 days past, 90 days and 90+ days past due that are above $0.00 for the total
• provide me a count of each

Option 2

• Remove the first 10-11 rows in each worksheet
• Combine all worksheets to one worksheet
• Count the number of rows that are 30 days past, 60 days past, 90 days past, 90+ days past due that are above $0.00 for the total

Option 3

• Remove the first 10-11 rows in each worksheet
• combine all worksheets
• count the number of rows that are specified such as:
• Up to $5.00
• $5.00
• $5-10
• $10
• $10-20
• $20-50
• $50-100
• $75
• $87
• $100-200
• $200-500
• $500-1000
• $1000-2000
• $2000-4000
• $4000-5000
• $5000-6000

More could be added or removed depending on what the need is. I have provide an example of what one of the worksheets look like as an attachment.

[davesexcel]

What specifically do you need help with?

[mbrown009]

I guess more than nothing right now is a simple tutorial of how to do this?