Data Validation Data Validation from the Excel menu limits you to selecting a range on the active sheetTo get around thisassign a name to the data you want to include in the validation

Figure 7.2

When a name is shared by a local and a global reference,the local reference's sheet displays only the local name.

Figure 7.3

When a name is shared by a local reference and a global reference, the other sheets display only the global name.

Figure 7.3

When a name is shared by a local reference and a global reference, the other sheets display only the global name.

0 0

Post a comment