Dear Ravinder,
Thanks for writing. Hope I clarify on below.
I have one macro by that macro some value get calculate and it will be any
number, once that number appears in 1 cell then next cell show the next
vale as per master. (target %)
E.g. if the 1 cell (by macro) value is 12.50 then next c
PFA
Cheers!!
On Thu, May 1, 2014 at 3:38 AM, kapil Gupta wrote:
>
>
> Hi,
>
>Please Unique name requirement using macro but without using advance
> filter.
>
>
> Regards,
> Kapil Gupta
>
> --
> 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)
Hi Amar,
Yes it is possible, but Excel Name doesnt accept spaces in between hence
you will be required to do more work to get it done.
See att for ref.
Cheers
On Wed, Apr 30, 2014 at 6:11 PM, amar takale wrote:
> Dear Vabs
>
> I have just idea for this issue but i dont know it is work or not
Hi
I am not sure of this.
Thx
On Wed, Apr 30, 2014 at 3:34 PM, renuka chari wrote:
> Dear Sir thanks alot...
>
> i have a one doubt i.e my client places they are using Lotus note we are
> used to send this dashboard to my client place is this macro would be work
> on that place.
>
> please su
Hello Paul,
I don't how to write a macro...and I request someone to write it for me
please.
Thanks
Rashid
On Wednesday, April 30, 2014 5:21:27 PM UTC+4, Paul Schreiner wrote:
>
> Do you know how to write macros and are asking for help?
> or are you asking for someone to write the macro?
>
> *
Sub macros_sample()
Dim baserange As Range
Dim cl As Range
Set baserange =
Sheets("Sheet1").Range("a2:a2500").SpecialCells(xlCellTypeVisible)
Application.EnableEvents = False
Application.Calculation = xlCalculationManual
For Each cl In baserange
If cl.Value <> ""
Sub macros_sample()
Dim baserange As Range
Dim cl As Range
Set baserange =
Sheets("Sheet1").Range("a2:a2500").SpecialCells(xlCellTypeVisible)
Application.EnableEvents = False
Application.Calculation = xlCalculationManual
For Each cl In baserange
If cl.Value <> ""
I think I've taken a half step forward. But now I'm locked in a circular
argument with Excel. It keeps telling me I have a next without a for. If
I remove the offending next it tells me I have a for without a next.
Here's where I am now:
Sub Check_Static()
Dim CompareRange As
Hi,
Please Unique name requirement using macro but without using advance
filter.
Regards,
Kapil Gupta
--
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 @
https://www.facebook.com/discussexcel
FO
HI Renuka,
No problem and no need to apologise with me. Actually i am trying to
open example one sheet view code but there is requiring the password.
Please if can possible to share the password with me.
Thanks,
Kapil Gupta
On Wednesday, April 30, 2014 8:32:07 PM UTC+5:30, renuka chari
Hi,
I am sending my resume. Kindly enclose the attached resume files and
please forward.
On Wednesday, April 30, 2014 11:35:23 PM UTC+5:30, ashish wrote:
>
> Please share your cv
>
> Regards
> Ashish Koul
>
>
>
>
>
>
> On Friday, 28 October 2011 21:36:28 UTC+5:30, Ayush Jain wro
Hi,
Please give me password of this application.
Regards,
Kapil Gupta
On Saturday, March 22, 2014 2:57:33 PM UTC+5:30, Deepak Pal Singh wrote:
>
> Try this one..
>
>
> On Sat, Mar 22, 2014 at 1:33 PM, Renukachari Kasee
>
> > wrote:
>
>> Ashish Sir,
>>
>> your macro was working very good for s
Hi Benjamin
Can you please let us know are all your values unique? - Yes the values are
unique. It's a list of invoice numbers. The first is a master list that
has been culled to remove a certain group of clients. The second set is a
list of clients that we've had difficulties with. The com
Hi Benjamin
Can you please let us know are all your values unique?
Do you want to compare the same row nos or cell. Numbers ?
Reason I m asking is if the values r unique and it is found you can use exit
for as soon as condtion is met
Also is it possible for you to share a sample file with dumm
Hey everyone and thanks in advance for any help.
I have a fairly simple macro, that worked wonders in my tiny test set, but
is slogging along at an incredibly slow pace when I set it to run it's full
scale application.
The 'Cull_List' worksheet has already been filtered down somewhat from it's
i can't see any image . Can you please repost it?
On Wed, Apr 30, 2014 at 8:32 PM, renuka chari wrote:
> kindly apologise for late response.
>
>
> Dear kapil gupta,
>
> here i didn't set any password for the code. please check.
>
>
> dear ashish,
>
> please check the image in the earlier po
Please share your cv
Regards
Ashish Koul
On Friday, 28 October 2011 21:36:28 UTC+5:30, Ayush Jain wrote:
> Dear members,
>
> E&Y(Gurgaon) looking out for VBA professionals with 1-2 years of
> experience.
> Refer your friends and send me resume @ jaina...@gmail.com .
>
> Please
kindly apologise for late response.
Dear kapil gupta,
here i didn't set any password for the code. please check.
dear ashish,
please check the image in the earlier post
on that i was run the code yellow color marking record would not reflect in
the T1 sheet and T2 Sheet.
please check
pls clear ur query
On Wed, Apr 30, 2014 at 5:32 AM, rameshwari shyam wrote:
> Dear Team,
>
> Please advice on below query.
>
>
> I have one target% and as per target% value need to change. For example
> if my target% is 12.50 then next Coolum need to fill as per my target% just
> like 15.00
>
Do you know how to write macros and are asking for help?
or are you asking for someone to write the macro?
Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the peo
Dear Vabs
I have just idea for this issue but i dont know it is work or not.If
we give name range each table then formula like = name range match
then vlookup search that value into that specific table only.
how to write formula as per my idea OR it is possible?
Regards
Amar
On Wed, Apr 30, 201
Dear Team,
Please advice on below query.
I have one target% and as per target% value need to change. For example
if my target% is 12.50 then next Coolum need to fill as per my target% just
like 15.00
Attached excel sheet.
if target %
Need to take as per Target %
12.50
15.00
67.90
69.00
Hello All,
I am using Excel 2010 and have the following problem.
I need a macro to look for x in Columns J to AX (Sample File Attached).
If it finds x then it should go to the Folder “C:\Test\Macro” which
contains the Folder names shown in J3 to AX3.
It should open the file inside the respec
Dear Vabs,
Super ...
On Wednesday, 30 April 2014 12:23:46 UTC+5:30, amar takale wrote:
>
> Dear Vabs Brother
>
> Its really cool formula which you have sent me… There was a glow in my
> face
>
> Thanks very very muchfor helping excel enthusiasts
> voluntarily !!
>
> Regards
>
> Dear Paul,
>
Apology for the late response. Thank you so much for hardwork and help.
The macro works great, exactly what I was looking for. Thank you very
much, I really appreciate your time and help.
Sorry, once again for the late response to your code.
Thank you!
--
Are you =EXP(
Dear Sir thanks alot...
i have a one doubt i.e my client places they are using Lotus note we are
used to send this dashboard to my client place is this macro would be work
on that place.
please suggest.
On Wednesday, 30 April 2014 10:41:25 UTC+5:30, Vabz wrote:
>
> Hi
>
> You can do so b
26 matches
Mail list logo
