I complete income and expenditure spreadsheets monthly. In the expenditure sheet there is a column showing the firm or individual to whom the cheque is made out to. I have noticed that if the name is already in the list above the entry that I am filling in then when I enter the first letter it will autocomplete. Since most of my entries are to the same firms each month on separate sheets, I was wondering if there was a method of setting up a list so that entries would autocomplete when I enter the fist letter of the name.
Just trying to think how I do it - I used to have a whole set of names and addresses which automatically printed out when I just entered, for example, the person's initials, preceded by the letter X (incase their initials appeard in a normal word)
Can't remember how I got the resulting data to display in columns down rather than rows across. I hope VoG™ or someone else can remember because it's beginning to bug me!
Right click the sheet tab, select View Code. Paste in the following:
Private Sub Worksheet_Change(ByVal Target As Range) If UCase(Target.Value) = "Y" Then Target.Value = "Yes" ElseIf UCase(Target.Value) = "N" Then Target.Value = "No" ElseIf UCase(Target.Value) = "D" Then Target.Value = "Don't know" End If End Sub
Obviously you will need to substitute your desired firms for "Y", "Yes" etc.
If the names of the firms only go in one column (say E) then add the following before the first If statement:
My apologies for not replying earlier. First of all many thanks for all your suggestions. I have in fact tried them all out. All of them work but in the end I have found that in terms of time and ease of use a custom list seems to be the best outcome. Once again many thanks for your time and efforts.
This thread is now locked and can not be replied to.