Auto fill / lookup
Posted by Colin on January 10, 2002 3:53 PM
A simple one I'm sure, I have a form type sheet and would like to enter say an Account number in a cell, then from a data sheet in the same workbook the rest of the form is filled in, Address post code area etc, all off the relevant data is on the data sheet in rows and colums. I have used combo boxes for some of the form contact details etc, but unable to get these to work for addresses etc,
Clear as mud?
anyone help please? save me a load of copy and pasting