I am looking for a simple Macro that when fired, copies and saves a set of range names as separate XLS sheets in a folder on the desktop. The folder name is driven by a particular cell. If the Folder already exists on the desktop, the macro will overwrite it; if it is a new name, it creates a new Folder and performs the copy. A message should show up on the original WS (where the data resides), "Data has been saved......."
That's it! Sample attached.