We received forms from consumer with supplier name. & we have standard supplier name list.
we use vba code to copy FER form details to our database automatically. but i'm unable to use this vba code as consumer is not using standard supplier name.
eg. if standard supplier name is Telx Group. then some customer use Telx. some use The Telx Group.Some use Telx America.
provide vba code to update standard name in database.
What, no hint of please, could someone help, this is what I tried. Just ... do this for me!Originally Posted by Pravina
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
'=VLOOKUP(AU8&"*"&AV8,CHOOSE({1,2},AQ1:AQ233&AR1:AR233,AS1:AS233),2,0)
i want forumal like that in excel vba
Supplier 60 Hudson Owner LLC Entity AAPT Ltd. Australia AIMS Data Centre Sdn. Bhd. Malaysia Alaska Communications er Arteria Networks Corporation Japan AT&T er ATM S.A.(Atman) er Azzurro HD LLC er Bayan Telecommunications, Inc. er BCEBCE NEXXIA INC. Canada Belgacom International Carrier er Bell Canada Canada
Posting Permissions
Reply With Quote
