Wednesday, July 6, 2016

[Solved] Auto Complete Typing in an Excel Data Validation List

Auto Complete Typing in an Excel Data Validation List

Sir

I m making a excel sheet with list of customers in Sheet 2 and in Sheet one I need to make a list of date wise daily sales report.Now I have above 500 customers so I want to used Autofill or Select option.Over the Web I got 2 options: 1.Data Validation 2.Combo-boxThe Combo-box I like it but the problem is that the file size will increase as I copy it in the every cell.So I decided to go for Data Validation but the problem in that is that I have to scroll down the list which I want to avoid.I want to use the AutoFill type thing.Over the Web I found blow formula:

=OFFSET(Sheet1!$A$1,0,0,MATCH("*",Sheet1!$A$1:$A$300,-1),1)

but in this the Data (Company Names) must be in the same sheet i.e sheet 1 in my case.So can you please help me with this issue so I can have all my companies names in other sheet and let my data entry be done on other sheet.As I would be hiding the company names list so that no one can edit / delete it accidently.

Thnx Kishor

Keys to the Problem Auto Complete Typing in an Excel Data Validation List

How to Fix Auto Complete Typing in an Excel Data Validation List with SmartPCFixer?

1. Click the button to download SmartPCFixer . Install it on your computer. Open it, and it will perform a scan for your system. The junk files will be shown in the list.

2. After the scan is done, you can see the errors and problems need to be fixed. Click Fix All.

3. The Repair part is finished, the speed of your computer will be much higher than before and the errors have been fixed. You can also use other functions in this software. Like dll downloading, windows updating and print spooler error repair.