q; dividing a sheet into xls files

[JIM.H.]

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

 

[Dave Peterson]

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

 

[Ron de Bruin]

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