can a macro pick up data from one file,process it in a certain way and then put the output back to an excel file.
i need help with how to do it
thanks