Look and save

[Guest]

Hi:

I have a big excel file (many records and col) and is sorted by store no. I
would like a code that checks the store no. and save every records within the
same store into the same location under the store name:

St date
3 1/1/04
3 2/3/03
4 1/1/02
4 2/2/04

save 3.xls, 4.xls, etc

Thanks in advance,

Dan

 

[Frank Kabel]

Hi
not completely what you're looking for but creating separate
worksheets:
http://www.rondebruin.nl/copy5.htm#existing

 

[Guest]

Hi Frank:

I am looking for a code that checks the unique store no. take taht group of
records particular to a store and save them as an excel file into a certatin
location; move next for another unique store no and do the same...till eof

Thanks,

Dan