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
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
in
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 sarva0...@gmail.com wrote:
Hi Team,
Please help me on Vlookup function where I will need to refer the file(by
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 sarva0...@gmail.com wrote:
i am looking for VBA Macro for this , reference file to opened
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
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 rockerna...@gmail.com
wrote:
Haha, Same
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
@googlegroups.com
Date: Tue, 30 Dec 2014 12:38:55
To: excel-macros@googlegroups.comexcel-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
@googlegroups.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 this for you. God
