Hello,
I'm relativly new to the whole Excel thing. But, currently I am trying to use it as an employee log. The woorkbook I am using has multiple shhets with different information on each. I would like to auto fill some information on one page into fields on another, based on a value i provide.
Example:
I have a list of names and extensions #'s on one sheet. The second page is blank. When I type in a name on the second page I want excel to autofill the extension # into the next field.
Is any of this possible? If so how do I go about it? Also, is it possible to do this across different workbooks?
I'm relativly new to the whole Excel thing. But, currently I am trying to use it as an employee log. The woorkbook I am using has multiple shhets with different information on each. I would like to auto fill some information on one page into fields on another, based on a value i provide.
Example:
I have a list of names and extensions #'s on one sheet. The second page is blank. When I type in a name on the second page I want excel to autofill the extension # into the next field.
Is any of this possible? If so how do I go about it? Also, is it possible to do this across different workbooks?