Raja, can you supply a sample workbook so we can see your structure and
better understand what you mean?
Raja;415510 Wrote:
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


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=115688