Excel script modifications - 01/05/2018 11:08 EDT

Hi, I have a working excel script and I need to add a couple of features. I have attached script (called "best tool") that works with a file called "[login to view URL]" I have a spreadsheet containing purchased orders (refer to attached file "data") The script already does: - Extracts the child names whose Hi-res packages have been purchased. - In a different tab it extracts all print sizes purchased in alphabetic order - Then it places all filenames fromo each size in a comma separated way. - It highlights any repeated file from each size only. It needs to do: 1. I want to change the source file name from "[login to view URL]" to "[login to view URL]", and the "best tool" to "Order Parser" 2. Change column names as per new attached file called "[login to view URL]" 3. I want the whole process to happen pressing 1 button that creates all tabs instead of having to press 3 different buttons. 4. There will be instances where instead of "1x" like in "1x 4 x 6 Print - 10x15cm - [login to view URL]" there will be "2x" or "3x". I need to place it in column "file name" in a repeated new line.. So I know I have to print them x times? 5. Extract in a separate tab all 8x10 belonging to either a "basic package" or a "standard package" ONLY, and place them also as comma separated. (This is because we give a "social media" digital version of the images when they buy 8x10 in those packages) 6. So I would like the tabs to be in the same order: "Data", "HR packs" (for high resolution packages), "Social media" (for 8x10 from packs), "To Print" (for the rest of the orders)