Hello
Thanks for your email, I had a look at the requirement. Unfortunately, I do
not have any consultant available on my bench for the role, However I would
like to inform you that at present I have few excellent Business Analyst
candidates available, let me know if you have any positions availab
hi,
i need your help on one more thing ...i somehow seek trough and able to see
vba project code but there is a click on refresh button. While i cannot
see code behind that button. there are three xlam files which also have
some passwords Please help me again..i know i am asking too much of favor
ok thank so much for your prompt replies and readiness to help. I really
appreciate that.
well i need to fetch data from an api call and then use some mathematical
functions to dynamically perform some operation son few columns fetched.
Can you send me something like this type as an example or som
Dear Ankur
In that case you will be required to take help of person who created this
Macro or create macro on your own.
We can assist you in developing new macro but not breaking it.
Cheers!!
On Jun 20, 2014 9:48 PM, "Ankur Gupta" wrote:
> yes it is prompting me for password. I tried opening i
yes it is prompting me for password. I tried opening in notepad and tried
to find gpd n ol but it crashes the workbook. Please help me out?
On Fri, Jun 20, 2014 at 12:21 AM, Vaibhav Joshi wrote:
> hi
>
> You can pres Alt + F11 to go in to VBE mode, then press Ctr + R to view
> project explorer
hi
You can pres Alt + F11 to go in to VBE mode, then press Ctr + R to view
project explorer on left side.
Browse for your WB name (this will be like "VBA Project(workbook name)" and
click on plus sign to expand it. If it is not protected then you will be
able to see code, if it is protected then
hi vaibhav,
Could you please illustrate as in what you want to tell me? The workbook
is not protected but the button , i cant see the code even in design mode.
It remains clickable even after entering the design mode. Is there any way
i can check the code for macro written? Please advise me bette
Hi
Is macro module protected? if you can open WB then its not diff. to
unprotect VBA module.
You can google it around to know how to unprotect it. Pl note rule 3 "Don't
post questions regarding breaking or bypassing any security measure."
Cheers!!
On Fri, Jun 20, 2014 at 10:33 AM, Ankur Gupta
15:51, wrote:
>>
>>> Y don't u use sumifs or countifs
>>> Sent on my BlackBerry(R) from Vodafone
>>> --
>>> *From: * Prabhu Pinky
>>> *Sender: * excel-macros@googlegroups.com
>>> *Date: *Mon, 17 Mar 20
excel-macros@googlegroups.com
>> *Date: *Mon, 17 Mar 2014 15:48:28 +0530
>> *To: *
>> *ReplyTo: * excel-macros@googlegroups.com
>> *Subject: *Re: $$Excel-Macros$$ Very urgent . i need to submit my
>> project today.. please help
>>
>> Am using excel 2007.
&g
) from Vodafone
> --
> *From: * Prabhu Pinky
> *Sender: * excel-macros@googlegroups.com
> *Date: *Mon, 17 Mar 2014 15:48:28 +0530
> *To: *
> *ReplyTo: * excel-macros@googlegroups.com
> *Subject: *Re: $$Excel-Macros$$ Very urgent . i need to submit my project
> today.. please help
>
Y don't u use sumifs or countifs
Sent on my BlackBerry(R) from Vodafone
-Original Message-
From: Prabhu Pinky
Sender: excel-macros@googlegroups.com
Date: Mon, 17 Mar 2014 15:48:28
To:
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Very urgent . i need to s
Am using excel 2007.
On 17-Mar-2014 12:24 PM, "ashish koul" wrote:
> which version of excel r u using
>
>
> On Mon, Mar 17, 2014 at 12:22 PM, Prabhu Pinky wrote:
>
>> Guys...pls help with my query
>> On 17-Mar-2014 9:22 AM, "Prabhu Pinky" wrote:
>>
>>> Hi Experts,
>>>
>>> Please find the att
which version of excel r u using
On Mon, Mar 17, 2014 at 12:22 PM, Prabhu Pinky wrote:
> Guys...pls help with my query
> On 17-Mar-2014 9:22 AM, "Prabhu Pinky" wrote:
>
>> Hi Experts,
>>
>> Please find the attached file. there i used many SUMPRODUCT formula. it
>> slow down my excel.
>>
>>
Guys...pls help with my query
On 17-Mar-2014 9:22 AM, "Prabhu Pinky" wrote:
> Hi Experts,
>
> Please find the attached file. there i used many SUMPRODUCT formula. it
> slow down my excel.
>
> please help with macro or any simplified formula.
>
>
> *am doing this on a daily basis, if u give me
Hi Puttu,
Please find attached solved sheet.
Thanks
Mukesh
- Original Message -
From: Puttu *
To: excel-macros@googlegroups.com
Cc: Rohan Young
Sent: Friday, February 25, 2011 5:37 PM
Subject: Re: $$Excel-Macros$$ Very Urgent Help required in Excel formula
Attached is
Try this
IF(VLOOKUP(A3,$C$5:$C$9,1,0),"YES", " ")
On Fri, Feb 25, 2011 at 6:32 PM, Puttu * wrote:
> Thanks a lot it worked out me. Cold you please help on my second question
> in Attached is the sheet
>
>
> On Fri, Feb 25, 2011 at 5:42 PM, Vikas Chouhan wrote:
>
>> Hi Puttu,
>>
>>
>> if you are
Thanks a lot it worked out me. Cold you please help on my second question
in Attached is the sheet
On Fri, Feb 25, 2011 at 5:42 PM, Vikas Chouhan wrote:
> Hi Puttu,
>
>
> if you are using Excel 2007 then
>
> use formal : - =IFERROR((IF(VLOOKUP(C12,Ukey,1,0),"
> YES", " "),"")
>
> AND 2003 then
>
Hi Puttu,
if you are using Excel 2007 then
use formal : - =IFERROR((IF(VLOOKUP(C12,Ukey,1,0),"
YES", " "),"")
AND 2003 then
=ISERROR((IF(VLOOKUP(C12,Ukey,1,0),"
YES", " "),"",(IF(VLOOKUP(C12,Ukey,1,0),"
YES", " "))
On Thu, Feb 24, 2011 at 6:13 PM, Puttu * wrote:
> Hi Experts,
>
> I have t
Attached is the question with attachment. Please help me out
On Fri, Feb 25, 2011 at 5:22 PM, Puttu * wrote:
> No Still not working
>
>
> 2678
>
> YES
>
> This is fine
>
> 2558
>
> #N/A
>
> This one I want as blank (if the data doesn't match then it should show
> blank cell)
>
>
>
> #N/A
Dear Puttu,
Try it..
=IFERROR(IF(VLOOKUP(A2,C5:C9,1,0),"YES", " "),"")
On Fri, Feb 25, 2011 at 5:22 PM, Puttu * wrote:
> No Still not working
>
>
> 2678
>
> YES
>
> This is fine
>
> 2558
>
> #N/A
>
> This one I want as blank (if the data doesn't match then it should show
> blank cell)
>
> 22
No Still not working
2678
YES
This is fine
2558
#N/A
This one I want as blank (if the data doesn't match then it should show
blank cell)
#N/A
This one I want as blank (if the data doesn't match then it should show
blank cell)
On Fri, Feb 25, 2011 at 9:48 AM, Rohan Young wrote:
Hi Puttu,
it is working well see the attachment, r u sure you are putting right
criteria in your data, pls. send the sample sheet for understanding,
Thanks & Regd
ROHAN
On Thu, Feb 24, 2011 at 8:16 PM, Puttu * wrote:
> Team, Please help me on this
>
> On Thu, Feb 24, 2011 at 6:13 PM, Puttu *
Team, Please help me on this
On Thu, Feb 24, 2011 at 6:13 PM, Puttu * wrote:
> Hi Experts,
>
> I have two questions
>
> 1. I am using Vllokup formula =IF(VLOOKUP(C12,Ukey,1,0),"YES", " ") in this
> if any error it shows as #N/A, insted of this i want it show as balnk, how
> to do this?
>
> 2. In
see if it helps
On Thu, Feb 24, 2011 at 6:13 PM, Puttu * wrote:
> Hi Experts,
>
> I have two questions
>
> 1. I am using Vllokup formula =IF(VLOOKUP(C12,Ukey,1,0),"YES", " ") in this
> if any error it shows as #N/A, insted of this i want it show as balnk, how
> to do this?
>
> 2. In Vlookup form
Hello.
Have a look at consolidation (Data, Consolidation)
Regards.
Daniel
> -Message d'origine-
> De : excel-macros@googlegroups.com [mailto:excel-
> mac...@googlegroups.com] De la part de L.K.Modi
> Envoyé : lundi 29 mars 2010 07:36
> À : MS EXCEL AND VBA MACROS
> Objet : $$Excel-Macros$$
Thanx Andy .
On Wed, Dec 9, 2009 at 9:15 PM, Aindril De wrote:
> Hi Bharghav,
>
> Try this in any cell other than A1,
> Suppose A1 contains the text Data for abc 07
>
> =MID(A1,FIND(" ",A1,(FIND(" ",A1,1)+1))+1,(FIND(" ",A1,FIND(" ",A1,(FIND("
> ",A1,1)+1))+1)-FIND(" ",A1,(FIND(" ",A1,1)+1))-1))
Hi Bharghav,
Try this in any cell other than A1,
Suppose A1 contains the text Data for abc 07
=MID(A1,FIND(" ",A1,(FIND(" ",A1,1)+1))+1,(FIND(" ",A1,FIND(" ",A1,(FIND("
",A1,1)+1))+1)-FIND(" ",A1,(FIND(" ",A1,1)+1))-1))
Regards,
Andy
On Wed, Dec 9, 2009 at 7:26 PM, bharghav r wrote:
> All,
>
>
28 matches
Mail list logo
