Hi,

I have a sheet with data for about 200 stores on it. The data is
listed as such:

Store Product Amount
12 abc $1.00

As I said I have many different store numbers on the same sheet. I
want to put each stores into its own workbook. I don't want to be
cutting and pasting for a really long time if I can avoid it. Here is
my question: What do I have to do to have excel put all the data for
each store (there are most likely multiple lines for each store) into
its own workbook, save the file into a folder with the store # as the
name, and repeat for all the rest.

I could probaly get the macro to work if I knew how to get it to read
each store number and paste it onto its own sheet.

Any help would be most welcome. This is something I'm going to have to
be doing every week and don't look forward to cutting and pasting my
life away.

Thanks

Eddie.


--
punter


------------------------------------------------------------------------
punter's Profile: http://www.excelforum.com/member.php...fo&userid=2044
View this thread: http://www.excelforum.com/showthread...hreadid=546033