Re: $$Excel-Macros$$ VBA to Vlookup from other Source!

2014-12-29 Thread Vaibhav Joshi
groups.com > *ReplyTo: * excel-macros@googlegroups.com > *Subject: *Re: $$Excel-Macros$$ VBA to Vlookup from other Source! > > hmn.writing macro is very easy, however as long as solution exist > using available resources then same should be explored.. > > + > *I did not do

Re: $$Excel-Macros$$ VBA to Vlookup from other Source!

2014-12-29 Thread saravanan R
Reason behind is, I am Working on a multiple manual task in one report, like already enquired, pulling data from Text file, changing data formats, based on this data pull information from other source, clean up templates. etc regards, saravanan R On Tue, Dec 30, 2014 at 12:33 PM, Mandeep Baluja

Re: $$Excel-Macros$$ VBA to Vlookup from other Source!

2014-12-29 Thread meetgoni
cel-macros@googlegroups.com Date: Tue, 30 Dec 2014 12:38:55 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ VBA to Vlookup from other Source! hmn.writing macro is very easy, however as long as solution exist using available resources then same

Re: $$Excel-Macros$$ VBA to Vlookup from other Source!

2014-12-29 Thread Vaibhav Joshi
hmn.writing macro is very easy, however as long as solution exist using available resources then same should be explored.. + *I did not do this for you. God is here working through me for you.* On Tue, Dec 30, 2014 at 12:33 PM, Mandeep Baluja wrote: > Haha, Same question from my side to

Re: $$Excel-Macros$$ VBA to Vlookup from other Source!

2014-12-29 Thread Mandeep Baluja
> > Haha, Same question from my side too Vabz but i was still trying to get > it. Too much logical by calling it with udf because whenever you're writing > a function the excel files during browsing cant be opened. > Trying this Macro to achieve the result. Option Explicit Public Sub Tes

Re: $$Excel-Macros$$ VBA to Vlookup from other Source!

2014-12-29 Thread Vaibhav Joshi
why you need macro when you simply get it done using builtin excel dialogue box.. + *I did not do this for you. God is here working through me for you.* On Tue, Dec 30, 2014 at 10:34 AM, saravanan R wrote: > i am looking for VBA Macro for this , reference file to opened by browse > option t

Re: $$Excel-Macros$$ VBA to Vlookup from other Source!

2014-12-29 Thread saravanan R
i am looking for VBA Macro for this , reference file to opened by browse option then select the range. thanks & regards, Saravanan On Mon, Dec 29, 2014 at 6:45 PM, saravanan R wrote: > Hi Team, > > Please help me on Vlookup function where I will need to refer the file(by > browsing the path) an

Re: $$Excel-Macros$$ VBA to Vlookup from other Source!

2014-12-29 Thread Vaibhav Joshi
Hi Yes you can do so..Keep both the file open & goto cell where yo need to insert formula and start vlookup dialogue box by pressing Shift + F3 .. When dialogue box appears select vlookup from Lookup & reference category and press enter..now select look value from col A, press tab & you will be i

$$Excel-Macros$$ VBA to Vlookup from other Source!

2014-12-29 Thread saravanan R
Hi Team, Please help me on Vlookup function where I will need to refer the file(by browsing the path) and update the correponding data in the current file. requirement as below: col x=vlookup(col A current working file, rng, 2,0) Col x & A refers to the current working file but range I have to s