So I have a macro called "GM_Macro" that populates the GM_template tab and I want it to create a separate file of that same tab and have it automatically saved on my computer
So on this file run the "GM_macro" then it populates the GM_template tab. I want that sheet saved on my laptop when I run it.
The file name I want it to be is on the CRWS tab sheet. On the first row it says brand code 83534861 then it says Pratt Display for the Material Supplier under it. There are 3 Material Suppliers we have (Pratt, West Rock, and Georgia Pacific). If it is Pratt, leave it blank, if it is West Rock indicate it as "RT". If it is Georgia Pacific, indicate it as "GP". So in this case I want the file name to just be "83534861". But if it was from West Rock, it would be 83534861 RT.