C the att.
From: Lokesh Loki
To: excel-macros@googlegroups.com
Sent: Monday, June 4, 2012 6:48 PM
Subject: $$Excel-Macros$$ Date format
Hi Experts,
I want to confirm the date format whether it is showing Indian date format or
us date format.
Please se
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
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
The line break seems fine. When I tried it with the doubled up quotes it
put the correct formula into the cell.
On 5 June 2012 11:27, charlyRoot wrote:
> I tried that and it outputs the formula characters to the cell when I run
> it. Is my line break correct?
>
> Thank you for the quick reply.
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.
It worked. Thanks.
On Monday, June 4, 2012 8:51:59 PM UTC-4, David Grugeon wrote:
>
> Probably need to double up all the quotes like
> "=SUBSTITUTE(HYPERLINK(CONCATENATE(statics!R1C1,RC[-11]), ""Link""), ""
> "", )"
>
> On 5 June 2012 10:27, charlyRoot wrote:
>
>> This works fine in the spr
Nevermind. I tried it again and it worked. Must have had a quote messed up.
Sorry to waste time.
On Monday, June 4, 2012 8:51:59 PM UTC-4, David Grugeon wrote:
>
> Probably need to double up all the quotes like
> "=SUBSTITUTE(HYPERLINK(CONCATENATE(statics!R1C1,RC[-11]), ""Link""), ""
> "", )
Also remember, a bubble chart has third variant, that specifies the bubble size.
Thanks,
Joseph
Sent on my BlackBerry® from Vodafone
-Original Message-
From: David Grugeon
Sender: excel-macros@googlegroups.com
Date: Tue, 5 Jun 2012 10:46:32
To:
Reply-To: excel-macros@googlegroups.com
Thanks its working...thank you very much.
Thanks & Regards,
*Deba Ranjan P*
On Tue, Jun 5, 2012 at 7:11 AM, David Grugeon wrote:
> You may need a formula like
> =LEFT(A1,FIND(":",A1)-1)/24+MID(A1,FIND(":",A1)+1,FIND(":",A1,FIND(":",A1)+1)-(FIND(":",A1)+1))/1440+MID(A1,FIND(":",A1,FIND(
I have data that I am importing regularly and the number of lines of the
data is highly variable. I have written code that first inserts a column of
data I need for my Y axis, then the second part of my code should select
the my X and Y range and change the graph accordingly then thirdly modify
I don't know VBA other than manipulating recorded macros. What is the quickest
way to learn from foundation up? Book? Some pay site? It takes to long to go
through youtubes.
I would like a info dense book that does not assume prior prior VBA knowledge
but also assumes I know what a keyboard is
You may need a formula like
=LEFT(A1,FIND(":",A1)-1)/24+MID(A1,FIND(":",A1)+1,FIND(":",A1,FIND(":",A1)+1)-(FIND(":",A1)+1))/1440+MID(A1,FIND(":",A1,FIND(":",A1)+1)+1,99)/86400
This will convert your pseudo time values to date/time values. Then you
can do further processing on them.
On 4 June 2012
I tried that and it outputs the formula characters to the cell when I run it.
Is my line break correct?
Thank you for the quick reply.
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, F
Probably need to double up all the quotes like
"=SUBSTITUTE(HYPERLINK(CONCATENATE(statics!R1C1,RC[-11]), ""Link""), "" "",
)"
On 5 June 2012 10:27, charlyRoot wrote:
> This works fine in the spreadsheet:
> =SUBSTITUTE(HYPERLINK(CONCATENATE(statics!$A$1,B2), "Link"), " ","")
>
> However I can
Could you post a picture of the chart you are talking about?
On 5 June 2012 08:01, SR wrote:
>
> I have seen a report in my company which shows on two axis - the two
> parameters of an account and a line connects to these and there is a bubble
> placed on the line to indicate the volume,
>
> OK
Hi Sonal
I hope you realise that if you apply any of the suggested solutions to your
string " rahul;6e3-" you will get "rahule" not "rahul". I hope this is
what you want. If not we might need to see a greater selection of strings
to see if there is a pattern (like - always cut them off at the fi
This works fine in the spreadsheet:
=SUBSTITUTE(HYPERLINK(CONCATENATE(statics!$A$1,B2), "Link"), " ","")
However I cannot escape the quotes correctly or something. I've tried every
combination and nothing.
Range("M2").Select
ActiveCell.FormulaR1C1 = _
"=SUBSTITUTE(HYPERLINK(CONCATENATE(statics!
Hi Rajan,
is there any chance, that you can explain me how you've done it?
Regards,
Pawel
From: Rajan_Verma
To: excel-macros@googlegroups.com
Sent: Monday, June 4, 2012 2:11 PM
Subject: RE: $$Excel-Macros$$ Graph with radio button
HTH
Regards
Rajan v
I have seen a report in my company which shows on two axis - the two
parameters of an account and a line connects to these and there is a bubble
placed on the line to indicate the volume,
OK to simplify - it is basically an AR related report - on one axis - it
shows - how many days old past du
Can some one looking into details and provide me help.
On Mon, Jun 4, 2012 at 12:19 AM, Puttu * wrote:
> Hi Excel Experts,
>
> Need a help on the macro for automated email reminders. below is the
> requirements. Attached is sheet for your reference
>
>
> Need a macro based on the given date and
Hi Jeetendra,
Appreciate your efforts putting here, but my requirements are little
different, which will not serve the purpose from your macro. Thanks for
your help
On Mon, Jun 4, 2012 at 5:06 PM, Jitendra singh wrote:
>
>
> Option Explicit
>
>
>
> Function RangetoHTML(rng As Range)
>
> ' Chang
Hi Rajan,
The date will most of the time current or future date.
On Mon, Jun 4, 2012 at 6:11 PM, Rajan_Verma wrote:
> When you want to send the mail?
>
> I mean when you will the date ?
>
> ** **
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
> ** **
>
> *From
I re-read your query and I see you only wanted alphabet characters. I had
this include numbers as well. for just alphabetical characters A-Z and a-z,
here is the correction:
Function CleanText(Text As String) As String
Dim NewText As String, Character As String * 1, Position As Long
For Pos
Ah , Cod is just a integer type variable , that will hold the ACSII Code or
each character in string,
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of sonal
Sent: 04 June 2012 9:04
To: excel-macros@
Hi Sonal,
Another function for you:
Function CleanText(Text As String) As String
Dim NewText As String, Character As String * 1, Position As Long
For Position = 1 To Len(Text)
Character = Mid(Text, Position, 1)
If Character Like "[A-z]" Or Character Like "#" Then
again thanks but i know how to run a macro what i was asking is
the explanation for "COD" that ypu have used in your code.
On Monday, June 4, 2012 8:59:23 PM UTC+5:30, Rajan_Verma wrote:
>
> Ok..
>
>
>
> Press ALT+F11
>
> ALT + I M
>
> Paste this code there
>
>
>
> Use Function Worksheet Li
select the range on the worksheet and run the macro
On Mon, Jun 4, 2012 at 8:58 PM, sonal gupta wrote:
> Thanks ashish.I'll try it.
>
> On Monday, June 4, 2012 8:51:06 PM UTC+5:30, ashish wrote:
>>
>> Sub text_clean()
>> Application.DisplayAlerts = False
>> Application.Calculation = xlCalculat
Ok..
Press ALT+F11
ALT + I M
Paste this code there
Use Function Worksheet Like :
= RemoveSpecialCharacters(YourString)
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of sonal gupta
Sent: 04 J
Thanks ashish.I'll try it.
On Monday, June 4, 2012 8:51:06 PM UTC+5:30, ashish wrote:
>
> Sub text_clean()
> Application.DisplayAlerts = False
> Application.Calculation = xlCalculationManual
> Dim cell As Range
> Dim str As String, text1 As String
> For Each cell In Selection
> str = ""
> text1 =
Thanks rajan, but i'm new to macros..can you please explain the use of
"COD" in this.
On Monday, June 4, 2012 8:51:52 PM UTC+5:30, Rajan_Verma wrote:
> Try this :
>
>
>
> Public Function RemoveSpecialCharacters(Shname As String) As String
>
> Dim Cod As Integer
>
> Dim ShN As String
>
>
Try this :
Public Function RemoveSpecialCharacters(Shname As String) As String
Dim Cod As Integer
Dim ShN As String
For i = 1 To Len(Shname)
Cod = Asc(Mid(Shname, i, 1))
If (Cod > 47 And Cod < 58) Or (Cod > 64 And Cod <
91) Or (Cod > 96 A
Sub text_clean()
Application.DisplayAlerts = False
Application.Calculation = xlCalculationManual
Dim cell As Range
Dim str As String, text1 As String
For Each cell In Selection
str = ""
text1 = ""
str = cell.Text
For i = 1 To Len(str)
If (Asc(Mid(str, i, 1)) > 64 And Asc(Mid(str, i, 1)) < 90) Or (A
Dear Sir,
i have little knowledge about vba. that's why i am asking sol
with index/match.
and plz tell me abt offset function also.
On Sun, Jun 3, 2012 at 11:42 PM, pawel lupinski wrote:
> Don,
>
> love it (great reply) :)
>
> Pawel
>
> --
> *From:*
Hi,
This is my first post in this group.I have learnt many things from this
group.I'm finding difficulty in cleaning the range in which each cell has
string like " rahul;6e3-".I need a macro which will clean the special
characters,spaces & numbers & leave the alphabets only.
Thanks in advanc
Hi ,,
Then removie ..YES ..just give " "
Thanks
=IF(NOT(ISERROR(VLOOKUP(A7,'C:\Documents and Settings\user\My
Documents\Downloads\New Folder\[Stock.xls]Sheet1'!$C$5:$C$914,1,0))),"NO","
")
On Sun, Jun 3, 2012 at 10:11 PM, prkhan56 wrote:
> Thanks.
> But it is showing "Yes" for Blanks also
Hi Deba
I think when you will enter valid time .. your formula is giving correct
results
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Deba Ranjan
Sent: 04 June 2012 6:48
To: excel-macros@google
Congrats ..Rajan ...
On Mon, Jun 4, 2012 at 9:00 AM, Lalit_Mohan wrote:
> Congratulation Rajanonce again you rock...
>
> Regards,
> Lalit Mohan
>
> On Sunday, 3 June 2012 23:12:31 UTC+5:30, Ayush Jain wrote:
>
>> Hello Everyone,
>>
>> Rajan Verma has been selected as '
Hi ,
use this formula.
6/4/2012June-04-2012
=TEXT(A2,"-dd-")
feel free drop me mail if need any clarification.
Regards
Amresh
On Mon, Jun 4, 2012 at 7:09 PM, Lokesh Loki wrote:
> Hi Experts,
>
> Suppose date is 06/04/2012 then i need a output like this (Month/Date/Y
Do you want this :
="Month " & MONTH(B3) & " Date " & DAY(B3) & " Year " & YEAR(B3)
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Lokesh Loki
Sent: 04 June 2012 7:09
To: excel-macros@googlegroup
Hi Experts,
Suppose date is 06/04/2012 then i need a output like this (Month/Date/Year)
only not for (June/Monday/2012).
06 is showing as Month,
04 is showing as Date,
2012 is showing as Year,
Suppose if i have made any changes in the month & date it should be
reflecting me that the d
thanks Asa,
i will apply these instead, but quick question, the countif works so why
are you saying i should avoid it. thanks
On Sun, Jun 3, 2012 at 9:53 PM, Asa Rossoff wrote:
> Ah, I didn't realize what you had done in the sample file. You looked up
> the last occurrence.. Yes. My formula c
Or you can use this in Custom format:
--
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Lokesh Loki
Sent: 04 June 2012 6:49
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$
Use this
=TEXT(B3,"mmm--")
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Lokesh Loki
Sent: 04 June 2012 6:49
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Date format
H
=TEXT(B3,"/dd/")
On Mon, Jun 4, 2012 at 6:48 PM, Lokesh Loki wrote:
> Hi Experts,
>
> I want to confirm the date format whether it is showing Indian date format
> or us date format.
>
> Please send me the formula,
>
> Regards
> Lokesh
>
> --
> FORUM RULES (986+ members already BANNED for
Hi Experts,
I want to confirm the date format whether it is showing Indian date format
or us date format.
Please send me the formula,
Regards
Lokesh
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent
Sir, i mean the times are like wise:
hour, minute, second
It can be 2000 hours
can be 300 mins
can be 200 seconds...
Thanks & Regards,
*Deba Ranjan P*
On Mon, Jun 4, 2012 at 6:29 PM, Rajan_Verma wrote:
> But how can second be 64?
>
> ** **
>
> * *
>
> *Regards*
>
>
HTH
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Anil Gawli
Sent: 04 June 2012 2:58
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Graph with radio button
See the attached data
But how can second be 64?
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Deba Ranjan
Sent: 04 June 2012 9:27
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Date format calculation
You can use formula like this
Either you can use this :
='C:\Users\XL_LOVER\Desktop\New
folder\[ExpenceSheet.xlsx]DailyExpenseBook'!A1
Or a SQL Query ( which is long way)
Except this .. I think no way to get data without open the excel file.
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
---
When you want to send the mail?
I mean when you will the date ?
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Puttu *
Sent: 04 June 2012 12:19
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$
Thank you all J
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of resp...@gmail.com
Sent: 04 June 2012 12:18
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Rajan Verma - Most helpful Me
You can also use..
=*IF(ISBLANK(B2),"","formula")*
On Sun, Jun 3, 2012 at 10:11 PM, prkhan56 wrote:
> Thanks.
> But it is showing "Yes" for Blanks also.
> I wish to show Blank for Blanks.
>
> On Saturday, June 2, 2012 12:12:39 PM UTC+4, vijayajith VA wrote:
>
>> Hi Rashid
>> As you requested..
Dear Karan,
Please use..
*=IF(RIGHT(A2,1)=",",LEFT(A2,LEN(A2)-1),A2)*
--
Thanks & regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com
On Mon, Jun 4, 2012 at 5:48 PM, Karan Singh wrote:
> Dear All,
>
> I need your assistance to remove last commas in the text string.
Dear Rajan,
Congratulations..
Keep the same stream always...
Regards,
Muneer,
CC
--
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
Option Explicit
Function RangetoHTML(rng As Range)
' Changed by Ron de Bruin 28-Oct-2006
' Working in Office 2000-2010
Dim fso As Object
Dim ts As Object
Dim TempFile As String
Dim TempWB As Workbook
TempFile = Environ$("temp") & "\" & Format(Now, "dd-mm-yy h-mm-ss")
well done rajan...
On Sun, Jun 3, 2012 at 11:12 PM, Ayush Jain wrote:
> Hello Everyone,
>
> Rajan Verma has been selected as 'Most Helpful Member' for the month of
> May'2012
> He has posted 147 posts in May 2012 and helped many people through his
> expertise.
>
> I truly appreciate his consist
Hi
Use one more *IF* condition with your formula to show blank as blank.
=IF(A1="","",Formula)
On Sun, Jun 3, 2012 at 9:41 AM, prkhan56 wrote:
> Thanks.
> But it is showing "Yes" for Blanks also.
> I wish to show Blank for Blanks.
>
> On Saturday, June 2, 2012 12:12:39 PM UTC+4, vijayajith V
Hi,
Also try below array formula,
=IFERROR(INDEX($C$2:$C$25,MATCH(0,COUNTIF($E$1:E1,$C$2:$C$25),0)),"")
On Mon, Jun 4, 2012 at 2:15 AM, NOORAIN ANSARI wrote:
> Nice Solution Mahesh.
>
>
> --
> Thanks & regards,
> Noorain Ansari
> www.noorainansari.com
> www.excelmacroworld.blogspot.co
Experts,
Could you please please help on the below request.
On Mon, Jun 4, 2012 at 2:00 PM, Puttu * wrote:
> below is the required details for your reference once again.
>
> Sr. No. Task (Subject Name) First Reminder Date & Time Second
> Reminder Date & Time Final Reminder Date & Time Sta
Congrats Rajan + Noorain + Vijay = Excel Group
Keep it up
Enjoy !!!
MangesH
On Mon, Jun 4, 2012 at 11:24 AM, Nikhil Shah wrote:
> Congratulation Rajan
>
> Nikhil Shah
>
>
> On Mon, Jun 4, 2012 at 11:02 AM, Maries wrote:
>
>> *Congrats Brother.*
>>
>>
>> On Sun, Jun 3, 2012 at 9:3
Hi Santosh,
Find the attached file. I hope this fulfill.
On Mon, Jun 4, 2012 at 2:27 AM, Anil Gawli wrote:
> See the attached data
> Regards,
> Gawli Anil
>
>
>
> On Mon, Jun 4, 2012 at 2:38 PM, santosh subudhi <
> santoshkumar.subu...@gmail.com> wrote:
>
>> Hi Maries,
>>
>> Thankyou for your
See the attached data
Regards,
Gawli Anil
On Mon, Jun 4, 2012 at 2:38 PM, santosh subudhi <
santoshkumar.subu...@gmail.com> wrote:
> Hi Maries,
>
> Thankyou for your early response.
>
> I want to show only the list of people who are available.
>
> I mean when I will select "team 1" then the gra
Hi Nesbit,
Please send ur query
--
Thanks & regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com
On Fri, Jun 1, 2012 at 2:29 PM, Nesbit Otieno wrote:
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor threa
Nice Solution Mahesh.
--
Thanks & regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com
On Sun, Jun 3, 2012 at 1:53 AM, Mahesh parab wrote:
> Hi Avinash
>
> Perhaps ..! you can use below Array formula with dynamic name range
> and without any helper column
>
Hi Maries,
Thankyou for your early response.
I want to show only the list of people who are available.
I mean when I will select "team 1" then the graph should show only the data
for the three people and no zero's .
Hope I am clear with query.
Regards
Santosh
santoshkumar.subu...@gmail.com
Fr
Hi,
PFA...
On Mon, Jun 4, 2012 at 1:39 AM, santosh subudhi <
santoshkumar.subu...@gmail.com> wrote:
> Hi Group,
>
> I want to create a graph which will show the work performance of different
> teams as and when they are selected.
>
> Attached is the sample sheet for your easy reference.
> --
> R
Hi Group,
I want to create a graph which will show the work performance of different
teams as and when they are selected.
Attached is the sample sheet for your easy reference.
--
Regards
Santosh
santoshkumar.subu...@gmail.com
--
FORUM RULES (986+ members already BANNED for violation)
1) Use c
below is the required details for your reference once again.
Sr. No. Task (Subject Name) First Reminder Date & Time Second Reminder
Date & Time Final Reminder Date & Time Status Email Group 1 Status Mail 6/4/12
17:00 6/5/12 20:00 6/6/12 22:00 Inprogress puttu...@gmail.com
puttu_...@yahoo.co.
Sorry, I don't have time. I tried to be very specific, but post back with
questions if you can't follow what I said.
Asa
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Deba Ranjan
Sent: Monday, June 04, 2012 1:24 AM
To: excel-macros@googlegroups.com
Su
Dear Asa,
Can you please explain in the sheet itself.
Thanks & Regards,
*Deba Ranjan P*
On Mon, Jun 4, 2012 at 1:22 PM, Asa Rossoff wrote:
> Hi Deba,
>
> ** **
>
> *For the Login Time column,* the reason SUM is not working properly is
> that many of the login times are being in
Hello Experts,
Any update on the below macro? Your help is much appreciated. Thanks
On Mon, Jun 4, 2012 at 12:19 AM, Puttu * wrote:
> Hi Excel Experts,
>
> Need a help on the macro for automated email reminders. below is the
> requirements. Attached is sheet for your reference
>
>
> Need a mac
Hi Deba,
For the Login Time column, the reason SUM is not working properly is that
many of the login times are being interpreted as text instead of as
[h]:mm:ss entries.
1) For the login time column with a custom format:
[h]:mm:ss
or the corresponding preset "Time" format:
37:30:55
2)
72 matches
Mail list logo