Some advice

[Diving_Dan]

Hi all, I'm after some suggestions.

I am currently putting a worksheet together at work that will show various bits of data. Some data is pulled onto the main sheet from a hidden sheet when I put their employee ID into a cell. If their telephone number is stored on the hidden sheet it will display it when requested on the main sheet or display "NO TEL HELD" if it isn't recorded.

Is there a way of updating the tel number on the hidden sheet from the main sheet? Would I be able to create a form to pop up that could search for the telephone number using the employee id and if one isn't stored update it using the form? Or is there a simpler way to do it?

Thanks in advance

 

[Rijnsent]

Hi Dan,
I would go for a button with a macro to "save new phone number", using a field that shows up when the "NO TEL HELD" message pops up. The macro would basically copy the filled value and paste the value into the hidden sheet in the right cell. I don't know how familiar you are with VBA, but it looks like quite simple, start with recording the macro. Please do post here if you get stuck modifying your code.
Cheers,
Koen