Fri 25 Jul 2008, 15:04Delegate Jackie said...
Jackie has attended:
Access Introduction course
Access Intermediate course
Looking up a value
In one column of a worksheet I am entering a currency value.
I want to be able to look down the column and for excel to find me the last entry in the column and paste link it to another sheet.
I have been told elsewhere that this is not possible, but I am sure it must be.
Even if it is not possible in 2000, we are updating to 2007 soon - is it possible in 2007?
Fri 15 Aug 2008, 15:34Trainer Amanda said...
RE: Looking up a value
Hello Jackie
Thank you for your post.
I think that this is something that would need to be automated by writing VBA code, there is not a specific feature that would do this for you in Excel (even in the 2007 version).
Amanda
