Copy portions of excel worksheet to a new workbook

[MisterC]

Howdy,
I have a workbook that has data something like:

LOCATION CODE AMOUNT
20 33 107.50
20 12 99.75
20 14 80.00
25 30 48.50
25 12 99.75
40 07 33.50
etc...

What I need to do is break the data apart when the "LOCATION" code changes and copy all of each location's data into its own new workbook. Does anyone have any suggestions?
Thanks!

 

[Niphyr]

Try using Macro's, start recording one, select the data you want to move, copy it, move it or whatever you want to do with it, press stop, go into the code editor and grab the code you need. For most things like that it works fine by me.

-Niphyr

------------------------------

http://niphyr.topcities.com

------------------------------