Hi Experts,
I need macro /formula for query given in attached file. The result should
come based on values given in column A.
Regards,
Mukesh Kumar
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
Solution Attached
On 16/07/2013 14:10, Mukesh Kumar wrote:
Hi Experts,
I need macro /formula for query given in attached file. The result
should come based on values given in column A.
Regards,
Mukesh Kumar
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
It’s
Thanks a lot Sir, but duplicate entries are also coming twice eg Alwar is
coming twice in result. Can it also come single time.
Regards,
Mukesh Kumar
On Tue, Jul 16, 2013 at 1:48 PM, De Premor d...@premor.net wrote:
Solution Attached
On 16/07/2013 14:10, Mukesh Kumar wrote:
Hi Experts,
Ups sorry, my mistake
i've attached new file for revision
Rgds,
[dp]
On 16/07/2013 15:27, Mukesh Kumar wrote:
Thanks a lot Sir, but duplicate entries are also coming twice eg Alwar
is coming twice in result. Can it also come single time.
Regards,
Mukesh Kumar
On Tue, Jul 16, 2013 at 1:48
Hi, Mukesh Try to change this code:
*For Each Rng In Data**
**If RangeCriteria.Cells(Rng.Row, 1) = Criteria Then Buf.Add
Rng.Value, Rng.Value**
**Next**
*
to
*For Each Rng In Data**
**i = i + 1**
**If RangeCriteria.Cells(i, 1) = Criteria Then Buf.Add
Thanks DP Sir, the code is now working perfectly.
Regards,
Mukesh Kumar
On Wed, Jul 17, 2013 at 6:40 AM, De Premor d...@premor.net wrote:
ignore my last email, i've made some change in variable declaration
PFA
On 17/07/2013 7:32, De Premor wrote:
Hi, Mukesh Try to change this code:
*
AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Need macro of formula and update in other sheet
Dear expert,
I need a macro of vlookup formula written in attached sheet of Vendor
Master which display only those concern data match with cell value of F1
and after editing