I created an invoice for my business with a macro to run so that every time I click on a certain cell it will save that sheet into a new workbook by the name in a cell and then change the invoice number at the top to the next number in the numerical sequence as well as clear out all the cells info so its blank again. I am now wanting to take info from a different cell (the persons email address) and save it in a different workbook but still have my macro run the same and clear out the info and go to the next number. I am new to this and had help writing the first one, I am having trouble figuring out how to do this without messing up what it's already doing. Any suggestions?
Need to extract data from a cell in a macro enabled sheet