I need to create a macro where each time I hit a button it copies the contents of my existing worksheet tab into a new worksheet tab. See my attached spreadsheet for the example. Specifically, from the "compare plans" worksheet tab, I need columns A through H copied as values (rather than formulas) into a new tab called whatever is in cell F14 of "compare plans". (The other tabs should remain intact, as is, and not be changed in any way.) For example, in my spreadsheet, I would the tab "compare plans" and manually adjust column D (which runs financial formulas....actually any cell in yellow can be adjusted manually to run formulas) to observe the effects of a new financial portfolio. Once I am happy with my changes, I click the macro button and columns A - H are copied into a new worksheet titled "121,500". This would save a record of that financial portfolio option.
Thanks in advance!