Thanks,
I would like to divide this out into sheets. I do have a headder row (row
1). Data starts in row 2. Example of first few rows...

OTCBIL UPC NDC CIN DESC
460628 09629578355 437205034178 1783554 LDR IBUPROFEN
460628 04116705703 041167005703 1241249 ASPERCREME
460628 04116700885 041167008805 1141878 ICY HOT TUBE
460628 30009364801 000009364804 1496066 DRAMAMINE
460628 09629510912 437205000805 2804151 LDR PAIN RELVR
460628 30067034365 000067021965 2793180 MAALOX QCK




"Ron de Bruin" wrote:

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?