Hi Friends,
I need urgent help, If any one can help me.
actually I have got one assignment, I need to solve it, but I'm completely
stuck into this.
Please see the attachment and help.
--
Thanks £ Regards
Rakesh Kumar
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It
Hi All,
i am working IE automation with one of the citrix page. when i nevigate
through page and click on close claim buttion i got one message.. do you
want to close the claim.
However i written one API which find the message and find the OK button and
click on OK. but issue to click on OK i
Hi,
Want to search header "Name" in attached file through vba but unable to do
with find method. Please help
Regards,
Soumyendu
--
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.co
Hi Every One,
Friend I need a big help from you all, as I work in BPO company as a MIS
executive but I am not aware about Access or SQL. But every day I need to scrub
the NDNC data which I receive it from my client side.. Volume of a data will be
around 5 to 6 lake. Where I get NDNC scrubbed fi
Dear All,
I need your Favour.I have a database in which no. & calls summary are
mentioned below.But i am not able to find Any formula to map Calls Against
Calls summary.If possible Please let me know is it possible through
VBA.Please Find Attached Raw Dump & Format of data exactly i have to give.
Hi Guy's,
I've a worksheet containing three columns Serial No, Month and
New/CarryForward. I want to get count of New & Carry Forward on Monthly
basis using an excel formula not by pivot table, I've tried to done it using
COUNTIF but couldn't get success.
Please Help
Thanks
Deepak Kumar
--
---
May be this is very simple for you experts . I am unable to crack the
converiosn from Test file to excel for the data below.
The fields are not aligned to draw column lines for import
the dtat is not of conistent length.
Only patterm I see is the text and numeric data nd spaces in between (these
a
Hi
I am ruchi gaba
I hv 2 probs
1- can i open the pdf file in word without using software like pdf tranformer?
2- i hv interview on monday and VBA, MS Access ,MS excel is required
in the software co. i hv dont all this in my course but the probs is
my concepts are not clear specially in VBA wat
Dear All,
Please provied me help on attached sheet.
Thanks
Sachin Shukla
--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text),
Hi,
I'm Very new for this group.I'm facing problem in Excel in Date Formatting.
When I'm Selecting to Column & go to Option of Date in Format, Whole column
is not coming accoroding to that selected Date Format.
Can anybody help me out in this ?
Thanks in Advance
Sachin Patil
Dreams are today's
Dear Excel Champs...,
Please help me out, I want to password for an XLA (add-ins) file.
Is there any way to know the coding of an XLA file???
awaiting reply.
Viral Pandy
--~--~-~--~~~---~--~~
--
>
> Dear Experts,
>>
>
I need your help to sort this problem
i have attached one file, i have mentioned my problem in file itself.
thanks in advance
regards
Girish
>
>> --
>> Some important links for excel user
Hi All.
As m working in a import house for that i have to sales bills on daily basis
i just want a help that makes me easy to make that
If someone tell that how to make 5 random numbers selection between 197.001
to 203.999 which gives the total of 1000.000
Please help meurgent guys
Cheers
Hi,
Is there a way to convert all the cells with numbers in to million format
with shortcut / formula.
Example: 1232345487 i want as 1232.
Attached is the sample file
Best Regards,
PRATHAP D
M +91 9899-370-328
--
---
Hi,
Please find attached excel sheet named Errors Bifurcation.
In this sheet there are many columns in which errors have been reported
seperated by commas. I want that all the errors seperated by commas should
appear in seperate rows with the data for Target ID and Tranaction ID. For
example:
In
Question not clear
On Mon, Jul 17, 2017 at 9:13 AM, Rakesh kumar
wrote:
> Hi Friends,
>
> I need urgent help, If any one can help me.
>
> actually I have got one assignment, I need to solve it, but I'm completely
> stuck into this.
>
> Please see the attachment and help.
>
>
> --
> Thanks £ Rega
see this attachment. hope it makes you understand.
On Mon, Jul 17, 2017 at 11:59 AM, Saleem Ansari
wrote:
> Question not clear
>
> On Mon, Jul 17, 2017 at 9:13 AM, Rakesh kumar
> wrote:
>
>> Hi Friends,
>>
>> I need urgent help, If any one can help me.
>>
>> actually I have got one assignment,
On Mon, 7/17/17, Saleem Ansari wrote:
Subject: Re: $$Excel-Macros$$ Urgent Help required
To: excel-macros@googlegroups.com
Date: Monday, July 17, 2017, 9:29 AM
Question not clear
On Mon, Jul 17, 2017 at
9:13 AM, Rakesh kumar
wrote:
Hi
Does that mean you would like to have color from 09th October till 23rd
Oct. in this case.
On Sun, Sep 28, 2014 at 12:20 PM, Rakesh kumar
wrote:
> hi friends,
>
> i need urgent help of yours
>
> in attached sheets column DOC has date. in next column 'No. of Days Req'
>
> if we enter 8 oct in
e places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-
From: Soumyendu Paul
To: excel-macros@googlegroups.com
Sent: Wednesday, August 26, 2015 1:24 AM
Subject: $$Excel-Macros$$ Urgent Help Required
Hi,
Want to searc
Dear Seniors,
I want total count of Sold Items according to the state or months. I'hve
tried this through Counta formula but this is huge volume of data, so
please suggest me the easy way.
Thanks,
Ashish
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,D
Hi,
Do you want to chek whether the master file ph.# are callable or
non-callable by verying it with NDNC sheet?
On Sat, Mar 3, 2012 at 4:16 AM, Satvik wrote:
> Hi Every One,
>
> Friend I need a big help from you all, as I work in BPO company as a MIS
> executive but I am not aware about Acce
chk attachments solved
On Fri, Mar 2, 2012 at 6:11 PM, Shaik Waheed wrote:
> Hi,
>
> Do you want to chek whether the master file ph.# are callable or
> non-callable by verying it with NDNC sheet?
>
>
>
> On Sat, Mar 3, 2012 at 4:16 AM, Satvik wrote:
>
>> Hi Every One,
>>
>> Friend I need a b
Thanks for the replay Shaik...
Yes I need to check with DNC..
Sent from BlackBerry® on Airtel
-Original Message-
From: Shaik Waheed
Sender: excel-macros@googlegroups.com
Date: Fri, 2 Mar 2012 18:11:44
To:
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Urgent
erry® on Airtel
> --
> *From: *Shaik Waheed
> *Sender: *excel-macros@googlegroups.com
> *Date: *Fri, 2 Mar 2012 18:11:44 +0530
> *To: *
> *ReplyTo: *excel-macros@googlegroups.com
> *Subject: *Re: $$Excel-Macros$$ Urgent Help Required...!
>
> Hi,
>
> Do you want to chek wh
43:19
To:
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Urgent Help Required...!
Hi,
You can use vlookup to find the callable # from DNC sheet. Find the
attached file for ur reference.
On Sat, Mar 3, 2012 at 6:59 AM, Satvik wrote:
> **
> Thanks for the replay Shaik
*To: *
> *ReplyTo: *excel-macros@googlegroups.com
> *Subject: *Re: $$Excel-Macros$$ Urgent Help Required...!
>
> Hi,
> You can use vlookup to find the callable # from DNC sheet. Find the
> attached file for ur reference.
>
> On Sat, Mar 3, 2012 at 6:59 AM, Satvik wrote:
: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Urgent Help Required...!
u can try this one
=INDEX('E:\Desktop\[NDNC
file.xlsx]Sheet1'!$A$2:$B$11,MATCH(A2,'E:\Desktop\[NDNC
file.xlsx]Sheet1'!$A$2:$A$11,0),2)
On Sat, Mar 3, 2012 at 7:19 AM, Satvik wrote:
> **
not return an error if the number
is not found, so we need to verify that it found the correct number.
Asa
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Satvik
Sent: Friday, March 02, 2012 5:49 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macro
Hi Deepak,
Pls find attached shet with the soultion as per your requirement.
Let me know if its find you helpful.
Best,
Bhupendra Chaudhari
On 9/7/2010 10:21 AM, Deepak Pal Singh wrote:
Hi Guy's,
I've a worksheet containing three columns Serial No, Month and
New/CarryForward. I want to get
ed message --
From: Deepak Pal Singh
Date: Tue, Sep 7, 2010 at 10:21 AM
Subject: $$Excel-Macros$$ Urgent Help Required
To: excel-macros@googlegroups.com
Hi Guy's,
I've a worksheet containing three columns Serial No, Month and
New/CarryForward. I want to get count of New & Carry Forwar
Hi Deepak,
Have a look at the attached to see if it's what you need.
Regards - Dave
Date: Tue, 7 Sep 2010 10:21:26 +0530
Subject: $$Excel-Macros$$ Urgent Help Required
From: deepaktheind...@gmail.com
To: excel-macros@googlegroups.com
Hi Guy's,
I've a worksheet containin
Dear Andy,
This is working Good i believe in Tag There are many categories are
available separated by comma(,),(/).is it Possible to match All word so that
i can match maximum apart from Checking only one word.
Thanks for your Support,
Chandrabhan Singh
On Mon, Nov 1, 2010 at 1:47 PM, Aindril
check the attachment see if it helps .
On Sat, Nov 27, 2010 at 6:46 PM, girish kumar
wrote:
> Dear Experts,
>>>
>>
> I need your help to sort this problem
>
> i have attached one file, i have mentioned my problem in file itself.
>
> thanks in advance
>
> regards
>
> Girish
>
>
>
>
>
>> --
Dear Ashish / Experts
Its wonderfull, its solved what i need.
But i need VBA code for this because i need to send this file to my higher
officials if formulas are there it wont be look good.
and for drop box (Column XFD) u put only those destinations which are in
Master sheet, if i need to add m
Hi Ashish,
i want one small info again in provided macro
if i hide the Master sheet macro is not running, is there any way to hide
the Master sheet and run the macro successfully?
thanks in advance
Regards
Girish.
On Tue, Nov 30, 2010 at 7:05 PM, ashish koul wrote:
> its ok bro
>
>
> On Tue
Hi Ashish,
Any updates??
On Mon, Dec 6, 2010 at 3:04 PM, girish kumar wrote:
> Hi Ashish,
>
> i want one small info again in provided macro
>
> if i hide the Master sheet macro is not running, is there any way to hide
> the Master sheet and run the macro successfully?
>
> thanks in advance
>
> R
pl stop this
On Tue, Jan 4, 2011 at 2:07 PM, ashish koul wrote:
> check the attachment see if it helps
>
>
>
> On Tue, Jan 4, 2011 at 11:58 AM, Born to Win wrote:
>
>> Hi Friends,
>>
>> Please help me to Apply sum & Average Formula at the end of Month however
>> when i am taking more than 30 Ar
Dear Ashish Ji,
i hv a question, i am looking your attachment where u r using an array
formula and the average col. many of cells is empty where the no. of calls
having value (1 or 2) is it ok? or the calculating method of mine for
average is correct.
please clear me, or suggest me if my working
Thanks u So much Experts.
Thanks,
Chandrabhan Singh
On Tue, Jan 4, 2011 at 3:37 PM, Rohan Young wrote:
> Hi,
>
> Please find the attachment
>
> Thanks & Regards
>
> ROHAN
> 9818247278, 8860567680
>
>
> On Tue, Jan 4, 2011 at 2:10 PM, ashish koul wrote:
>
>> ignore the previous mail check thi
See if it helps
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Anshul Gupta
Sent: Saturday, July 02, 2011 7:39 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Urgent Help required!!
Hi All.
As m working in a import house for
Sir,
Do u have any idea of auto filling magic squre for a particular sum total.
Iam interested
to know it. Thanks if u could help.
-R.Karunanithi
--- On Sat, 7/2/11, Rajan_Verma wrote:
From: Rajan_Verma
Subject: RE: $$Excel-Macros$$ Urgent Help required!!
To: excel-macros
Verma wrote:
> *See if it helps*
>
> * *
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Anshul Gupta
> *Sent:* Saturday, July 02, 2011 7:39 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Exc
See if it help
http://www.mrexcel.com/tip069.shtml
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of karunanithi ramaswamy
Sent: Saturday, July 02, 2011 9:29 PM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Urgent Help required
*On Behalf Of *karunanithi ramaswamy
> *Sent:* Saturday, July 02, 2011 9:29 PM
>
> *To:* excel-macros@googlegroups.com
> *Subject:* RE: $$Excel-Macros$$ Urgent Help required!!
>
> ** **
>
> Sir,
> Do u have any idea of auto filling magic squre for a particular su
roups.com] *On Behalf Of *karunanithi ramaswamy
>> *Sent:* Saturday, July 02, 2011 9:29 PM
>>
>> *To:* excel-macros@googlegroups.com
>> *Subject:* RE: $$Excel-Macros$$ Urgent Help required!!
>>
>> ** **
>>
>> Sir,
>> Do u have any
it help*
> >>
> >> http://www.mrexcel.com/tip069.shtml
> >>
> >> ** **
> >>
> >> * *
> >>
> >> * *
> >>
> >> *From:* excel-macros@googlegroups.com [mailto:
> >> excel-macros@googlegroups.com] *On
Hi Prathap
Assuming u r value in cell A1
'=A1/10^6
HTH
Mahesh
On Thu, Oct 13, 2011 at 8:22 PM, Prathap wrote:
> Hi,
>
> Is there a way to convert all the cells with numbers in to million format
> with shortcut / formula.
>
> Example: 1232345487 i want as 1232.
>
> Attached is the sample file
@googlegroups.com
Subject: $$Excel-Macros$$ Urgent Help required
Hi,
Is there a way to convert all the cells with numbers in to million format
with shortcut / formula.
Example: 1232345487 i want as 1232.
Attached is the sample file
Best Regards,
PRATHAP D
M +91 9899-370-328
Custom Format
#,##0,, ;[Red](#,##0,,);- ;
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Prathap
Sent: Thursday, October 13, 2011 9:52 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Urgent Help required
Hi,
Is there a way to convert all the cells with numbers in
Thank you all for your assistance.
However i have a sheet (containing 67 columns & 3980 rows) were i need to
change the entire cell into million. Attached is the sample sheet
Best Regards,
PRATHAP D
M +91 9899-370-328
On 13 October 2011 20:22, Prathap wrote:
> Hi,
>
> Is there a way to conver
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-
From: Prathap
To: excel-macros@googlegroups.com
Sent: Thu, October 13, 2011 1:31:01 PM
Subject: Re: $$Excel-Macros$$ Urgent H
.
-Original Message-
From: Prathap
Sender: excel-macros@googlegroups.com
Date: Thu, 13 Oct 2011 23:01:01
To:
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Urgent Help required
Thank you all for your assistance.
However i have a sheet (containing 67 columns &
Hi Prathap,
If this is one time exercise then, write 100 somewhere in and copy
it. Now select the data and apply paste special - > Values -> Divide.
If this is kinda template where figures will come and go, then you can
use custom format.
Regards,
DILIPandey
On 10/13/11, Prathap wrote:
> H
Here's a VBA formula that does the trick
http://www.ozgrid.com/forum/showthread.php?t=144212
Regards,
Sam Mathai Chacko (GL)
On Fri, Oct 14, 2011 at 11:03 AM, Dilip Pandey wrote:
> Hi Prathap,
>
> If this is one time exercise then, write 100 somewhere in and copy
> it. Now select the data
where you want the
data? Do you want the file changed or do you want a list on another sheet?, etc.
Don Guillett
SalesAid Software
dguille...@gmail.com
From: nitin arora
Sent: Wednesday, January 04, 2012 1:20 AM
To: excel-macros
Subject: $$Excel-Macros$$ Urgent help required
Hi,
Please find
ged or do you want a list on another
> sheet?, etc.
>
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
>
> *From:* nitin arora
> *Sent:* Wednesday, January 04, 2012 1:20 AM
> *To:* excel-macros
> *Subject:* $$Excel-Macros$$ Urgent help required
>
>
>
Hi
Do you want this procedure Only in AB Column..?
Regards
Rajan
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of nitin arora
Sent: Jan/Wed/2012 12:51
To: excel-macros
Subject: $$Excel-Macros$$ Urgent help required
Hi,
Please find attached
---
“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 people you can,
As long as ever you can.” - John Wesley
-------------
From: nitin
It appears that Paul has solved it for you.
Don Guillett
SalesAid Software
dguille...@gmail.com
From: nitin arora
Sent: Wednesday, January 04, 2012 7:52 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Urgent help required
Hi Don,
My apologies for the subject and I promise
Hi Paul,
Can you do a favour for me ?
ping me your mail ID at: excelfox at live.in
Kris
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
Hi,
--
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
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help
Hi Ashish,
Please confirm that the all data in a single sheet or in different
different sheets.
On Sat, Sep 7, 2013 at 11:13 AM, Ashish Kumar wrote:
> Dear Seniors,
>
>
> I want total count of Sold Items according to the state or months. I'hve
> tried this through Counta formula but this is h
The good thing is that your sheet name have a same name with what we are
looking for also the name of month, so we can process it easily, try
this on B2
=COUNTA(OFFSET(INDIRECT($A2&"!$A1"
),2,MATCH(B$1,INDIRECT($A2&"!$1:$1"),0)-1,2^16))
On 07-09-2013 12:43, Ashish Kumar wrote:
Dear Seniors,
Dear Senior,
All data in single workbook in different sheets and i want to create a
summary in output sheet. Data pattern will be same according to the sheet
which i'hve attached for query reference.
Thanks,
Ashish
On Saturday, September 7, 2013 11:22:03 AM UTC+5:30, Excel Group wrote:
>
> Hi
Dear De Premor & Ravinder Sir,
Thanks for your help and valuable support. Thanks a lot.
Thanks,
Ashish Kumar
On Saturday, September 7, 2013 11:32:20 AM UTC+5:30, De Premor wrote:
>
> The good thing is that your sheet name have a same name with what we are
> looking for also the name of month,
Pal Singh* <mailto:deepaktheind...@gmail.com>>
Date: Tue, Sep 7, 2010 at 10:21 AM
Subject: $$Excel-Macros$$ Urgent Help Required
To: excel-macros@googlegroups.com <mailto:excel-macros@googlegroups.com>
Hi Guy's,
I've a worksheet containing three columns Serial No, Month and
New/Carry
ut I
need the count of New and Carry Forward.
Saurabh can we do it without adding a new column?
Thanks
Deepak Kumar
-- Forwarded message --
From: *Deepak Pal Singh* <mailto:deepaktheind...@gmail.com>>
Date: Tue, Sep 7, 2010 at 10:21 AM
Subject: $$Excel-Macros$$ Urgent Help
Hi Group,
I'm working in a huge excel sheet with thousands of entries. I am currently
looking for a macro, that when invoked (upon press of a key etc) would open
a dialogue box having three fields. The first field being Select Row, In
which I can write a row number Like 3, the second filed would c
Hi
i have attached 1 file, in this file i want to fill the frequency column
i hv tried count formula but it doesnt work may be the way i m using
the formula is rong
plz help me
Regards
Ruchi
--~--~-~--~~~---~--~~
-
Hi Experts,
I have data with Employee number,based on employee number i need to
get the date of join.i have many file with DOJ.
What is the VBA vlookup code for looking one file and if not find the
DOJ filter blanks and asking next file to lookup. Thanks in advance.
--
Thanks&Regards
Nagendra.
Select
Exit For
Next c
D = ActiveCell.Value
ActiveCell.Value = A
Range(B).Value = D
End Sub
It should be quicker than a dialogue box with 3 questions.
Regards - Dave.
Date: Tue, 20 Apr 2010 14:55:44 +0300
Subject: $$Excel-Macros$$ Urgent Help Required in a macr
or
> Next c
> D = ActiveCell.Value
> ActiveCell.Value = A
> Range(B).Value = D
> End Sub
>
> It should be quicker than a dialogue box with 3 questions.
>
> Regards - Dave.
>
> ----------
> Date: Tue, 20 Apr 2010 14:55:44 +0300
>
You're welcome.
Regards - Dave.
Date: Wed, 21 Apr 2010 11:45:50 +0300
Subject: Re: $$Excel-Macros$$ Urgent Help Required in a macro
From: chaudhry.zahid@gmail.com
To: excel-macros@googlegroups.com
Thanks a bundle Dave. This has expedited my work even more. :-)
(P.S) Can anyone
Hey Pankaj,
The File is password protected, provide password to unlock and get the
required.
Group is waiting
On Tue, Aug 3, 2010 at 7:13 PM, Intelligent But Crazy
wrote:
> Hi group,
>
> My self pankaj,
> currentally I m working on a project, I have created
My Apologiese
Pls find the Password details.
For Workbook: bads...@143
For VBA Editor : bads...@143
For Worksheets : SecretShot
For Mastersheet : SecretShot
Pls help me in this.
Thanks
Pankaj k Pandey
On 8/3/10, Intelligent But Craz
Hi Dav,
First of all congrats, I request you to pls help me in
this problem, my whok project n promotion is now only depands on this.
I m waitinig for your reply.
Regards
Pankaj k Pandey
On 8/4/10, Intelligent But Crazy wrote:
> My Apologiese
>
> Pls find the
Try this,
But check it may have adverse effects,
Private Sub CommandButton2_Click()
UserForm1.Show 0
End Sub
Also check for help on SHOW method ( modal/nonmodal forms).
Share with me if you have any problems
Bye,
Kishan Reddy, K
kishanreddy.kethire...@gmail.com
On Aug 5, 6:38 am, Intelligen
Agreed with your point, but i want that if i required so i can only
see any other Excel file while opening a Form. I dont want to do any
thing on that file just want to see for refrence.
Kindly suggest
Regards
Pankaj k Pandey
On 8/5/10, Intelligent But Crazy wrote:
> Hi Dav,
>
>
Thanks a lot Krisnan
It is working.
I really appricieat your knowladge, I m glade to get help from you.
Regards
Pankaj k PAndey
On 8/5/10, Kishan Reddy, K wrote:
> Try this,
>
> But check it may have adverse effects,
>
> Private Sub CommandButton2_Click()
> UserForm1.Show 0
> End Sub
>
> Also c
Hi Pankaj
What is the password of Excel sheet
Regards
Madhu
From: Intelligent But Crazy
To: excel-macros@googlegroups.com
Cc: Intelligent But Crazy
Sent: Tue, 3 August, 2010 9:43:41 PM
Subject: $$Excel-Macros$$ Urgent: Help required in VBA form
Hi
Hi All,
I would be grateful if you could help me out with the following problem I am
facing with regard to data formatting:
The changes I need to make to the file are as follows:
1. I need to deduct one hour from the 'CaptureTime' field(column E) which is in
seconds.
This I have
just share your data.
Gawli Anil
On Tue, Jun 5, 2012 at 10:00 AM, Nagendra Modupalli wrote:
> Hi Experts,
>
> I have data with Employee number,based on employee number i need to
> get the date of join.i have many file with DOJ.
>
> What is the VBA vlookup code for looking one file and if not find
Dear Nagendra,
Please use it
Sub USINGVLOOKUP()
Dim X As Range
Set X = Sheets(1).Range("$A$1:$D$9")
Range("E15").Value
=Application.Worksheetfunction.VLookup(Sheets(1).Range("B15").Value, X, 4,
False)
End Sub
--
Thanks & regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.bl
: $$Excel-Macros$$ Urgent help required for Vlookup macro code
Hi Experts,
I have data with Employee number,based on employee number i need to
get the date of join.i have many file with DOJ.
What is the VBA vlookup code for looking one file and if not find the
DOJ filter blanks and asking next
Hi,
Function English(ByVal N As Currency) As String
Const Thousand = 1000@
Const Million = Thousand * Thousand
Const Billion = Thousand * Million
Const Trillion = Thousand * Billion
If (N = 0@) Then English = "zero": Exit Function
Dim Buf As String: If (N < 0@
86 matches
Mail list logo
