Excel and VBA

Hi
I need help with excel spreadsheet
there are 2 worksheets in a excel file. The first has a section with an Account number
and then a corresponding Account name.
In the second sheet in need to be able to do the following.
If the user types in the acount number in column a, then automatically populate column 2 with the
Account name from the first sheet.

thanx

:)

Craig
LVL 4
CraigLazarAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

dhwanilshahCommented:
This should help u out :
1. Create your account master sheet : for eg :
      A            B
1      1            Abc
2      2            Def
3      3            Ghi
2. Now select all these data cells and then create a name for them : select the cells , click on Insert menu, select Name submenu, click on Define, in the resulting dialogbox enter a name for these cells for eg : accountmasterdata , then click on Add.
3. create your other data sheet
4. now, select two colums, one where you want to enter the account no. and the other colum where you want to retrive and show the account name : for eg. i have selected colum B as the colum for entry of account number and colum C as the colum where I will display the account name
5. In colum C row 2, enter this formula : =LOOKUP(B2,accountmasterdata)
6. now copy the cell C2 to all the other cells in colum C
7. now enter a value in a cell in colum B and see how the contents of the cell C change according to the value entered in colum B.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
CraigLazarAuthor Commented:
Thanx mate that was perfect. If you would not mind also having a look at another question that i have posted in this lounge today for excel


thanx

Craig
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic Classic

From novice to tech pro — start learning today.