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" wrote in message
...

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