q; dividing a sheet into xls files

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JIM.H. - 22 Apr 2008 00:46 GMT

I have an excel sheet, the data is sorted by A column and A column holds
three values, Patient, Caller, Doctor and that are other columns that keeps
different data. How can I build a macro that exports this whole sheet in to
three different files based on the values in A column. So thee files will be
Patient.xls, Caller.xls, Doctor.xls

Reply to this Message

Dave Peterson - 22 Apr 2008 01:21 GMT

You could apply data|filter|autofilter and filter by each value.

Then copy the visible cells to a new workbook.

Or you could just take the macro that Ron de Bruin wrote and use that:
http://www.rondebruin.nl/easyfilter.htm

> I have an excel sheet, the data is sorted by A column and A column holds
> three values, Patient, Caller, Doctor and that are other columns that keeps
> different data. How can I build a macro that exports this whole sheet in to
> three different files based on the values in A column. So thee files will be
> Patient.xls, Caller.xls, Doctor.xls

Signature

Dave Peterson

Reply to this Message

Ron de Bruin - 22 Apr 2008 14:01 GMT

Or use the workbook macro here
http://www.rondebruin.nl/copy5.htm#workbook

Signature

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm

> You could apply data|filter|autofilter and filter by each value.
>
[quoted text clipped - 8 lines]
>> three different files based on the values in A column. So thee files will be
>> Patient.xls, Caller.xls, Doctor.xls

Reply to this Message

Rate this thread: