Hi Royce

Start here
http://www.rondebruin.nl/copy5.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Royce" wrote in message ...
I have worksheet that has hundreds of columns and close to 1,000,000 rows.
in column a the cells are defined as our different stores. ie... 1 or A or
even a (alpha-numeric and case sensitive) There are 50 different store
letters and numbers all single digit. The rest of the columns are of little
significance. I would like to insert all my data into sheet1, run a macro
that will copy all of store 1's rows to a sheet labeled 1. have it also do 2
and 3 all the way to z having many sheets that only have like items based on
column a.

That is the necessity

My wish list is that the macro would automatically write the sheet names
based upon columnA. Also it would copy the data only (no formulas attached
to the cell).