Thank you very much sir.
On Thu, Jan 5, 2012 at 6:58 PM, Rajan_Verma wrote:
> Use Mround Function
>
> ** **
>
> See the attached file
>
> ** **
>
> Regards
>
> Rajan.
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Shank
Hey Rajan,
Congratulations to you on this achievement.
Hope this year will be fantastic for you and "you will add a member in
your family soon."
Thanks & Regards,
BS
On Jan 3, 11:20 pm, Ayush Jain wrote:
> Hello Everyone,
>
> Wish you a very happy new year !!
>
> Rajan Verma has been selec
Sorry,,couldnt respond immediately..
Yeah i want each of these to a sheet of its own in another workbook.i
want all the car loans to be placed in one sheet...all the home loans in
another sheet in the same workbook and so on
This data keeps on changing every month...and new records ge
Hi Team,
I am New to this forum. I have a problem in my newly created macro in
my office.
As per the system screen size I have developed a userform for my
requirement. But the other user who has supposed to be used this tool
has having different monitor size.
Now I request you to provide me a co
Te data you initially receive is brought in as a STRING.
When you copy it down, Excel is converting it to a DATE (number).
So, no matter WHAT date format you choose, the two VALUES will be different.
So, you have a choice, either you play around with forcing Excel to duplicate
the values as String
I think this can be done with a web fetch and a macro to extract the data.
However, it will take a LOT of programming with very specific URL samples
telling where to find the data and desired output EXAMPLES. Contact me
privately at dguillett1 @gmail.com
Don Guillett
SalesAid Software
dguille.
Hi Asa,
Thanks for testing the code. I always use arrays. Application.counta and
index would work on arrays just like worksheet function works in ranges.
Anyway I converted those variant array into a range.
Can you please test this one for me ?
Sub kTest_v2()
Dim ka As Range, k(), i
Congrats Rajan.
Many thanks for devoting your valuable time daily from your busy schedule.
Regards,
Kaushik Savla
--
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 P
Dear all,
I would choose dd/mm/ format first, however, should I standardize all
the date format first before running the macro, or simply use the code from
Paul as,
If IsEmpty(Cells(i, 5)) Then
Cells(i, 5).Value = Cells(i - 1, 5).Value
Else
Cells(i, 5).Value = Cells(i,
Value2 gives faster performance as it doesn't take formats in memory
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 will not get
qu
Thanks Paul, Don’t remember encountering that. However, when I changed the
destination date, formulas calculated...
1/1/2012
2/1/2012
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Paul Schreiner
Sent: Thursday, January 05, 2012 8:12 AM
To: excel-macros@googlegroups.c
Good Solution Don
On Thu, Jan 5, 2012 at 8:00 PM, dguillett1 wrote:
> Another way, using FIND, or use application.vlookup
>
> Sub GetData()
> Dim mv As Range
> mv = InputBox("Please enter a value")
> If mv = "" Then Exit Sub
> Set mf = Columns(1).Find(What:=mv, LookIn:=xlValues, _
> LookAt:=xlW
Another way, using FIND, or use application.vlookup
Sub GetData()
Dim mv As Range
mv = InputBox("Please enter a value")
If mv = "" Then Exit Sub
Set mf = Columns(1).Find(What:=mv, LookIn:=xlValues, _
LookAt:=xlWhole, SearchOrder:=xlByRows, _
SearchDirection:=xlNext, _
MatchCase:=False, Sear
ya he is attending my query and will informed to me soon.
thanks for your valuable concern.
regards
lokesh.M
On Thu, Jan 5, 2012 at 7:45 PM, Paul Schreiner wrote:
> Sorry, the thread didn't include previous posts, so I thought you were the
> ORIGINATOR
> saying that you are waiting for someone
Dear rajan,
Thanks
regards
chandru
On Thu, Jan 5, 2012 at 7:43 PM, Rajan_Verma wrote:
> Hi chandru..
>
> You will get it tomorrow..
>
> ** **
>
> Rajan.
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *chandra sekaran
Sorry, the thread didn't include previous posts, so I thought you were the
ORIGINATOR
saying that you are waiting for someone to respond to your query.
Instead, you were asking if he got the reply and did he find a solution.
sorry for the misunderstanding...
(on a personal note, if he DID find
Hi chandru..
You will get it tomorrow..
Rajan.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of chandra sekaran
Sent: Jan/Thu/2012 07:40
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Cash flow Date Problem Urgent need pl.
Dear Rajan
Actually, I almost made the same mistake!
What's really happening is that HIS Windows environment is configured to
display
dates as dd/mm/
so to HIM both date formats look the same.
But since OUR environment settings use mm/dd/, then
when we open the workbook, all legitimate Excel "dates
Dear Rajan,
Cashflow Date Problem can i get sir,
Regards
chandru
--
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 will not get
qui
You can refer value to get appropriate result..
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of chandra sekaran
Sent: Jan/Thu/2012 07:35
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ what is different between .value and .value2
Dear
You may want to reconsider what you are asking for.
One set dd/mm/ and the other mm/dd/
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Darwin Chan
Sent: Thursday, January 05, 2012 3:42 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ VBA code for pasting date,
Dear Rajan
Performance wise which is best solution.
Regards
chandru
On Thu, Jan 5, 2012 at 6:52 PM, Rajan_Verma wrote:
> As Noorain said..
>
> Please find the attached File
>
> ** **
>
> Function GetValueDiff(rngCell As Range) As String
>
> GetValueDiff = "Value = " & rngCel
Use this For Vertical List
If you list is Horizontal then use Application.Transpose twice.
Sub GetDataFromList()
Dim rngList As Range
Dim strResult As String
Set rngList = Application.InputBox("Please select any Range", , , , , ,
, 8)
strResult = Join(Application.Transpose(
No, i am not disagree with the reply what i have received from you. just i
am waiting for the reply to the concerned person.
Thanks a lot for your valuable concern.
Regards
lokesh.M
On Thu, Jan 5, 2012 at 7:03 PM, Paul Schreiner wrote:
> What kind of reply are you looking for?
>
> Do you disagr
He said he wants to download files FROM the group,
not upload files TO the group.
The group site is:
http://groups.google.com/group/excel-macros?hl=en&pli=1
files are attached to the relevant messages.
Paul
-
“Do all the good you can,
By all the means you
What kind of reply are you looking for?
Do you disagree with the repy you received?
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 people you can,
As long a
Are not you using your mail to interact with Group??
You can use you mail to send and receive your solutions..
Group Link is this :
http://groups.google.com/group/excel-macros
Regards
Rajan.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of NOORA
Use Mround Function
See the attached file
Regards
Rajan.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Shankar Bheema
Sent: Jan/Thu/2012 12:31
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ doubt with rounding off and change event
I think the problem is that your first Pivot table (at A4)
doesn't contain "Dates", it contains a string of characters that RESEMBLE a
date.
If you try to change the date format to... say... Long Date... nothing happens.
After you copy the table to cells, when you copy this string DOWN,
Excel lo
I can't thank you enough:)
It works like a charm!
best regards,
seba
On 5 jan., 14:07, NOORAIN ANSARI wrote:
> Dear Seba,
>
> Please see attached sheet, Hope it will help you
> otherwise pls share your workbook with group.
>
>
>
>
>
>
>
>
>
> On Thu, Jan 5, 2012 at 6:25 PM, Seba wrote:
> > Hi,
Congrats Mr. Rajan;
Regards,
K Sagar
On Thu, Jan 5, 2012 at 1:16 PM, Subhash Yadav wrote:
> Congrats.
>
> On 1/5/12, Venkat CV wrote:
> > Congrats...Rajan& All...
> >
> > --
> > *Best Regards,*
> > *Venkat *
> > *Chennai*
> > *My Linked in profile <
> http://in.linkedin.com/pub/venkatesan
As Noorain said..
Please find the attached File
Function GetValueDiff(rngCell As Range) As String
GetValueDiff = "Value = " & rngCell.Value
GetValueDiff = GetValueDiff + " | Value2 = " & rngCell.Value2
End Function
Regards
Rajan.
From: excel-macros@googlegroups.com [mailto
Hi
How many rows may be Consolidated ?? I mean may be it can cross limit of
Excel.
Regards
Rajan.
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of vitorjose
Sent: Jan/Thu/2012 07:41
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macr
Use this :
=SUM((Sheet2!$G$2:$G$65536=UPPER(LEFT(D4,1)&MID(D4,FIND("
",D4,1)+1,LEN(D4)-FIND(" ",D4,1)+1)))*Sheet2!$D$2:$D$65536)
Regards
Rajan.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of lokesh
Sent: Jan/Thu/2012 08:23
To: excel-macros@googlegr
First of all, for 251, the NEAREST multiple of 10 is 250, not 260.
You're wishing to round UP to the NEXT multiple of 10!
Also, you said that the "fraction should not be considered"
That would imply that:
251.0 would round to 260
but:
250. would round to 250
if that's what you're looking
Dear Seba,
Please see attached sheet, Hope it will help you
otherwise pls share your workbook with group.
On Thu, Jan 5, 2012 at 6:25 PM, Seba wrote:
> Hi,
>
> I need help with the getting the data from a list and display it in a
> msgbox. I don't wan't to do this via the ususal lookup functio
Hi,
I need help with the getting the data from a list and display it in a
msgbox. I don't wan't to do this via the ususal lookup functions in
excel, because I'd like to avoid moving around the worksheet too much.
Would it be possible to get a macro to do the following:
1. Open a inputbox to enter
Hi,
User following formula:
=MROUND(A2, 10)
Check following details for more details
http://office.microsoft.com/en-us/excel-help/round-a-number-HP003056144.aspx
Regards,
Swapnil.
On Thu, Jan 5, 2012 at 4:38 PM, Shankar Bheema wrote:
> Dear experts
>
> I am using excel vba. I want to round o
Dear experts
I am using excel vba. I want to round off an amount to its nearest
multiple of 10.
eg : 251.10 (here fraction should not be considered only the whole number
which has to be rounded off to its nearest multiple of 10 i.e. 260)
252 = 260
but 250 remains 250
Pls do reply
--
FORUM
Hi all,
Still i am not getting any reply from you, please do the needful.
regards
lokesh.M
-- Forwarded message --
From: Paul Schreiner
Date: Jan 3, 6:46 pm
Subject: $$Excel-Macros$$ User login and logout time
To: MS EXCEL AND VBA MACROS
This may SEEM like a simple request, b
Dear L.K,
If you are using gmail id, then attach your file and send on below Email ID
excel-macros@googlegroups.com
On Thu, Jan 5, 2012 at 1:33 PM, L.K. Modi wrote:
> Dear Sir,
>
> Earlier i was able to download file from the excel group. I want to
> download some useful files from there . can
Dear Sir,
Earlier i was able to download file from the excel group. I want to
download some useful files from there . can any one send me that link.
Regards
LKModi
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Pleas
42 matches
Mail list logo