Hello, I have a file that requires a sort and split process. To be specific I have a file that contains roughly 24,000 records divided among 43 categories. The categories are currently represented by a numerical value that must be changed to a corresponding
name. The file must be sorted then split into separate Worksheets (43) with the name of each worksheet being that of the category. Example 1,2,3,4,5, rename the numbers to Dogs, Cats, Fish, Hamsters, Mice, then a worksheet created and named Dogs.csv, Cats.csv,
Fish.csv and so on containing the specific product record. The file needs to be pulled from a zip and have the process run twice a week, if you can code for Apple Automator too I require a script to pull the primary file via FTP from my supplier, store on
my desktop, run the EXCEL task and then FTP the new files to another URL.
Now to be fully upfront, I am a Firearms Dealer and if you do not like guns I understand completely and respect your opinion.
I did have someone almost accomplish this but the process only got about 75% of the way through. So this may be a little tricky and to make things even more interesting, it has to run on the MAC version of MS Excel.
You may contact me directly if you wish at manager@theballisticscenter.com Thank you, Jim Lucore
