How can a cell be formatted to auto populate based on another cell information. The auto populate needs to be based on a list. The cell B1 has a drop down menu that will select an account name. B2 will have the account code. I would like for B2 to auto populate based on the info selected on B1.
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
Hi Ture
While I have your attention how do I delete the question you answered for me last week regarding showing hours greater than 24. http://www.experts-exchang
Antrat
antrat,
Because I had posted an answer, you cannot delete the question yourself. Post a request in the Community Support area, asking a customer support person to delete it for you so that you can get your points back.
Regarding THIS question - do you see both a proposed and an accepted answer here? To me, this looks strange...
/Ture
Hi Jannette
I probaly should of mentioned that the code I gave you will only work when whenever the workbook re-calculates. So if your cell that you change the value in does not cause a re-calculation nothing will happen. To overcome this problem simply refer any cell to the cell that is being changed i.e. in cell A1 type =B1. This way whenever cell B1 has a new value in it the worksheet will recalculate and cell B2 should change its Validation List accordingly.
Please let me know if the above works. If it doesn't then we will find the problem.
Antrat
This question was awarded, but never cleared due to the JSP-500 errors of that time. It was "stuck" against userID -1 versus the intended expert whom you awarded. This corrects the problem and the expert will now receive these points; points verified.
Please click on your Member Profile and select "View Question History" to navigate through any open or locked questions you may have to update and finalize them. If you are an EE Pro user, you can also choose Power Search to find all your open questions.
This is the Community Support link, if help is needed, along with the link to All Topics which reflects many TAs recently added.
http://www.experts-exchang
http://www.experts-exchang
Thank you,
Moondancer
Moderator @ Experts Exchange
Business Accounts
Answer for Membership
by: antratPosted on 1999-09-11 at 13:36:12ID: 2039432
Hi jannette
If I understand you correctly this will do the the trick
First create the named ranges you want to be used to populate your list
then hit Alt+F11 to start the Visual basic Editor
Next double click "ThisWorkBook" in the properties window.
Then paste this code in and change the range names and cell addresses to suit your needs.
Private Sub Workbook_SheetCalculate(By
Application.ScreenUpdating
'"A" can be changed to any text you want
'If you are using numbers change text to value
If Worksheets("Page").Range("
Range("B2").Select
With Selection.Validation
.Delete
.Add Type:=xlValidateList, AlertStyle:=xlValidAlertSt
xlBetween, Formula1:="=Number" 'put this named
.IgnoreBlank = True
.InCellDropdown = True
.InputTitle = ""
.ErrorTitle = ""
.InputMessage = ""
.ErrorMessage = ""
.ShowInput = True
.ShowError = True
End With
End If
If Worksheets("Page").Range("
Range("B2").Select
With Selection.Validation
.Delete
.Add Type:=xlValidateList, AlertStyle:=xlValidAlertSt
xlBetween, Formula1:="=fruit" 'put this named range
.IgnoreBlank = True
.InCellDropdown = True
.InputTitle = ""
.ErrorTitle = ""
.InputMessage = ""
.ErrorMessage = ""
.ShowInput = True
.ShowError = True
End With
End If
'Simply repeat each block if statement
'For each value that you want a change to take effect
End Sub
Please let me know if I have missunderstood you
Antrat