Consolidating XLS files
Posted on 2014-07-24
I have three XLS files. I have data that is subtotaled by rep, I need to take information by rep from each of the three files and cut and paste it into one file on three different tabs).
I would like each file to be saved individually that is created with a file name convention of 000_Jun2014.
I can certainly provide the four files that are required for this with previous information for someone who has the ability to help me do this process.