Have you thought about Data/Validation using a list based on cells A3,A4, etc?


On Sat, 23 Oct 2004 12:36:14 -0500, jim27
wrote:


Hello everyone

Does anyone know the code for a macro that will autocomplete for the
contents in cell A1 using data in cell a3,a4 etc? There is no adjacent
data in columns B.

Thanks

Jim