Hi All,
Can anyone help me out with some vba which:
-Duplicates the current sheet
-User input box which asks for the new sheet's name
-Maintains formulas and sheet references, though when any formula on the current sheet call's for a reference to another sheet, that reference is replaced with value
Is there an easy way to go about doing this?
Bookmarks