Copying store numbers and pasting them into a seperate workbook

Hi,

I have a list of about 200 store numbers in a subtotal format. The data looks something like this:

Store Product Price
12 abc 1.00
12 def 2.00
12 Total 3.00

I need to email this information to each of the stores. I only want each store to see their data. Copying and pasting at each new store seems like it would take forever. How do I get excel to copy only one store at a time and save it into a folder?

Thanks for reading and thanks for all your help in the past.

Eddie

Bump............

If you remove the subtotal you can use code from this page to copy your data in the new workbooks
http://www.rondebruin.nl/copy5.htm#workbook

--
Regards Ron de Bruin
http://www.rondebruin.nl


"punter" <[email protected]> wrote in message
news:[email protected]...
>
> Hi,
>
> I have a list of about 200 store numbers in a subtotal format. The
> data looks something like this:
>
> Store Product Price
> 12 abc 1.00
> 12 def 2.00
> 12 Total 3.00
>
> I need to email this information to each of the stores. I only want
> each store to see their data. Copying and pasting at each new store
> seems like it would take forever. How do I get excel to copy only one
> store at a time and save it into a folder?
>
> Thanks for reading and thanks for all your help in the past.
>
> Eddie
>
>
> --
> punter
>
>
> ------------------------------------------------------------------------
> punter's Profile: http://www.excelforum.com/member.php...fo&userid=2044
> View this thread: http://www.excelforum.com/showthread...hreadid=545895
>