Function

F

fb0gris1091

Hi, I would like to create a function that can be used by many sheets /
users.

On a master sheet, I have 3 columns, Number, Key1, Key Description. This
master sheet is maintained by one user.

The function would be =GetKeyNumber(Key1_Lookup_value), it would show the
corresponding number. The issue is I do not want the user to know about the
master sheet.

Thank you for your advice in advance.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Visio: copy text of a master shape to User-define Cells (Variable) 0
Sub projects added as read only in Master file which are saved on sharepoint 1
External cell reference between two excel worksheets both in One Drive 0
Resctricting editing rights, but allowing those who cant edit, to still copy the slides 0
Macro VBA coding, Copying content from one workbook to a new one 0
VBA for Dependents shortcut menu 0
WORD VBA Search and switch to advanced ... 1
Excel does not accept text format! 0

Top