Hi,

I have a spreadsheet that contains report information for many clients
Unfortunately the same spreadsheet cannot be sent to all clients and
therefore have to export a subset of rows relating to each client an
then send each file separately. I do this using AutoFilter and nam
the file I create after a column name called Client Code, a simple tex
based field if no more than 8 characters.

Is this possible using VBA, if so how.

A basic set of column names would be Client Name, Client Code, Re
Number, Details.

Any help or guidance will be very much appreciated. Please let me kno
if you require any more info.


Thanks,
Da

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com

~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements