Hi Amy

Give me this information and I will guide you

In files or in sheets ?

Do you have headers in the first row of your range ?

In which row start your data ?
Is this also your header row ?

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


"Amy S." wrote in message ...
This looks like exactly what I'm looking for, but I don't understand the
programming language. Can you tell me in excel-for-dummies terms?
Thanks!

"Ron de Bruin" wrote:

Yes you can do this

See
http://www.rondebruin.nl/copy5.htm


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


"Amy S." <Amy wrote in message ...
I am running a report each month (with an inconsistant number of rows) that
needs to be cut and pasted into either seperate worksheets, or sepearte
files. Can I write a macro that will be able to break out data based on
customer number and automatically place it into new worksheets? I could
filter and then do the cut/past motions through the macro but this is too
many actions and it is too labor intensive. There has to be a better way --
ideas?