Hi Guys,

Currently i have Abbreviations and its expansions in the Sheet2 at
column A and B respectively and in the sheet1 i have abbreviations
filled in the D column and i have applied Vlookup formula with the in
the colmun F of sheet 1 to display the expansions.however the data of
abbreviations is huge and it will change everyday as per the flow we
receive so it is very difficult for the user to drag the vlookup formula
till last data.

So can any tell how this can be sorted though Macro instead of a
Vlookup formula.

Any help would be appreciated.

Regards,

Raja


--
Raja
------------------------------------------------------------------------
Raja's Profile: http://www.thecodecage.com/forumz/member.php?userid=497
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=115688