Info needed...please help!
I am trying to figure out the best way to do things in excel 2003. I am
working in a timesheet that is already designed. I would like to have the staff member be able to go into a cell and type the first couple of characters that would pull up the client name. I have tried a drop-down list but the list is over 1800 clients and I can't get is the automatically fill in names. I have tried a combobox, but I have trouble getting it to stay the size of the cell even though it looks correct on my screen when I go to print it the combo box is shorter than the cell. Is there a way to fix that and is that the way I should go? ANy help would be greatly appreciated. |
Joe,
I would set a worksheet_change event which would then compare the results of the cell typed against the list on the sheet. http://HelpExcel.com "joe smith" wrote: I am trying to figure out the best way to do things in excel 2003. I am working in a timesheet that is already designed. I would like to have the staff member be able to go into a cell and type the first couple of characters that would pull up the client name. I have tried a drop-down list but the list is over 1800 clients and I can't get is the automatically fill in names. I have tried a combobox, but I have trouble getting it to stay the size of the cell even though it looks correct on my screen when I go to print it the combo box is shorter than the cell. Is there a way to fix that and is that the way I should go? ANy help would be greatly appreciated. |
All times are GMT +1. The time now is 02:15 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com