Need to extract data from a cell in a macro enabled sheet

Katie - Jun 8, 2016 at 03:21 PM
 Blocked Profile - Jun 8, 2016 at 04:54 PM
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?

1 response

Blocked Profile
Jun 8, 2016 at 04:54 PM
What you are talking about is WAY beyond the scope of this forum. Disk operations is very complex, with alot of caveats.

Look into just saving the current book. Start with that, then start tweeking.