how to solve this?

Kannan82 Well, you re trying to name a cell or a range of cells, but the name already exists. Choose a different name or, if you must use that name, change the cell/range reference for the existing name. You can do that in the Name Manager on the Formulas ribbon.