Hi

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


Shirley