Copying store numbers and pasting them into a seperate workbook

P

punter

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
 
Top