HOW TO ASIGN SAME NAME TO TWO DIFFERENT RANGES IN SEPARAT SHEETS

  • Thread starter Satyapal Kaushal
  • Start date
S

Satyapal Kaushal

I would like to assign same name to two different ranges in in two different
sheets of same workbook. When we make a copy of sheet, EXCEL create such
names. But if we try to create from the menu, " Insert>Name>Create " name
will refer to only one sheet.
 
J

JE McGimpsey

Names can be either workbook-level or sheet-level.

When you create the sheet-level name (either in the Name box on the
formula bar or using Insert/Name/Define), prefix the name with the name
of the sheet, e.g.:

Sheet1!MyName

Sheet2!MyName


Note that if you use the name box, you'll need to delete the
workbook-level name first.
 
Top