autocomplete macro
 

Hello everyone

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

Thanks

Ji

--
jim2

-----------------------------------------------------------------------
jim27's Profile: http://www.excelforum.com/member.php...fo&userid=1537
View this thread: http://www.excelforum.com/showthread.php?threadid=27181

autocomplete macro
 

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