How to use a name defined in an excel file to another excel file

have defined a name for a data range in an excel file. Now I want to use the same name in different excel file. I tried through various sources but not sure how to do that.

Current Soln: I am copying the data from the source file and re-defining the names for the range. But this seems to be duplicate and creates unnecessary space.

Please let me know a good approach for this.

Hi
this macro takes all the range names in the active workbook and applies them to the same sheets and ranges in every open workbook. Note that the sheet names will have to be the same in the source and destination workbooks for this to work.

Please Login or Register  to view this content.