I'm in uncharted territory. I know nothing about macros or vba. But I watched a Mr. Excel video and figured out how to create a macro to auto sequential number electronic requisitions. I also figured out how to name, save and clear via a macro. I want to edit the "name" portion of macro as it only saves and names by invoice number which will not help when I need to retrieve it. I want to add the cells containing the date and name of vendor to the saveas range. How do I do this??