Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I've created a name database on an Excel sheet and I would like to access, select or utilise any of these names in another sheet of same book.

share|improve this question
    
So, what do you currently have, where are you stuck? What's the problem? –  slhck Apr 23 '12 at 14:37
    
Problem is - what program or command do I need to include in the first sheet in order to be able to call-up those names from the other sheet without having to re-write each name when needed. –  Mike Apr 23 '12 at 14:42

2 Answers 2

If i've understood correctly, i think what your referring to is something along these lines -

Say i have 'Hello' in cell A1 of Sheet1 and i want to use this in sheet2 i would write:

=Sheet1!A1

Hope i've understood what you are after and this helps! Apologies if this isn't what your after.

share|improve this answer
    
No really but thanks. I was able to get round the problem by using data validation to sellect needed names via a drop list –  Mike Apr 24 '12 at 14:04

You could also use VLOOKUP if there is some sort of ID you could reference as a key.

share|improve this answer
    
Thanks for he help. I was able to get round the problem by using data validation to sellect needed names via a drop list – –  Mike Apr 24 '12 at 14:08

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.