title: excel named range copy from sheet to sheet
body: <p>I have an Excel question,
  I am wondering if there is an easy way to set up a clone or copy of a named range in one worksheet to another worksheet in the same workbook.
  I need this to be done automatically as the data comes in through a third party software tool.
  I am not an advanced excel user and was hoping there would be a simple way to do this without macros, vba code etc.
  Any thoughts?
  Thanks!</p>