Hi,

I have several excel databases which I need to split up. The database
contains a list of products and thier prices, and I would like to
seperate each product into thier own excel file.
I am trying to have one commom coloum from the database in each file,
and then each of the other coloums paired with this.
For example if we call the main common coloum "1", and the product
coloums are "A", "B", "C" etc, I want seperate files, the first
containing, "1A" the second "1B" etc.

I need a way to automate this process, as doing this by hand will take
a long time. Can this be done?

---

Clarification of Question by xiii-ga on 22 Mar 2005 14:08 PST

Thanks dreamboat, looks usefull but I wouldnt know where to start
editing the code. I need to create seperate excel files not
worksheets, so I think I am gonna need a custom writen macro.

Im gonna canel the question and put it in again for a higher price cos
of the extra work involved.

I think this does exactly what you want, except that you'll have to
follow the instructions to find out how to edit the code to suit your
specific workbook.

http://www.vbaexpress.com/kb/getarticle.php?kb_id=318