I am trying to create the same cell name on multiple worksheets within a
workbook and having difficulties. I know this can be done by creating the
cell names on a single worksheet and then copying that worksheet but this is
a long way around if you just want to add one duplicate name. If I have an
existing cell name on Sheet1, how can I duplicate that cell name on Sheet2?
I'm using the Indirect function to get data from multiple worksheets that
have the same names. Thx.