Hi

I am using a VLookup to find a show a match in column A from a lis
contained in another file. The lookup works fine, however, I want t
automate the task by using a Macro. I can copy and paste the looku
formula down the remaining cells in column A but my problem is tha
this file is loaded on a regular basis and does not necessarily hav
the same number of rows in it the next time it is loaded. I need t
copy the lookup into the last active cell in column A. Any suggestion
would be much appreciated.


Shirle

--
Shirley Munr
-----------------------------------------------------------------------
Shirley Munro's Profile: http://www.excelforum.com/member.php...info&userid=83
View this thread: http://www.excelforum.com/showthread.php?threadid=40190