Creating Unique Worksheets Based on Column of Data

[JML0328]

I want to create a customized billing system for customers.

The data entry sheet would list each customer along a column with billing information in the other columns (type of charge, charge amount, etc). The data sheet would contain one or more lines of data per customer (depends on the number of charges the customer has).

I would like to create a macro that would create individual worksheets based on the number of unique customers there are in the data entry and move all the associated data in the columns to the respective customer's worksheet.

Is this possible?

 

[VoG]

If I understand correctly, try Excel Explosion http://www.datapigtechnologies.com/freeware.htm

 

[JML0328]

Thanks. I just now had the time to get around to trying it out.

It works great and does EXACTLY what I need it to do. This will be a big help to our organization.

Thanks again!