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
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 ca.mod...@gmail.com wrote:
Dear Sir,
Earlier i was able to download file from the excel group. I want to
download some useful files
Hi all,
Still i am not getting any reply from you, please do the needful.
regards
lokesh.M
-- Forwarded message --
From: Paul Schreiner schreiner_p...@att.net
Date: Jan 3, 6:46 pm
Subject: $$Excel-Macros$$ User login and logout time
To: MS EXCEL AND VBA MACROS
This may SEEM
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,
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 shankar.n...@gmail.comwrote:
Dear experts
I am using excel
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
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 sebastjan.hri...@gmail.com 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
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
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:
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:
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
Congrats Mr. Rajan;
Regards,
K Sagar
On Thu, Jan 5, 2012 at 1:16 PM, Subhash Yadav scy2...@gmail.com wrote:
Congrats.
On 1/5/12, Venkat CV venkat1@gmail.com wrote:
Congrats...Rajan All...
--
*Best Regards,*
*Venkat *
*Chennai*
*My Linked in profile
I can't thank you enough:)
It works like a charm!
best regards,
seba
On 5 jan., 14:07, NOORAIN ANSARI noorain.ans...@gmail.com 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
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
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
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
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
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=enpli=1
files are attached to the relevant messages.
Paul
-
“Do all the good you can,
By all the means you
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 schreiner_p...@att.netwrote:
What kind of reply are you looking
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 =
Dear Rajan
Performance wise which is best solution.
Regards
chandru
On Thu, Jan 5, 2012 at 6:52 PM, Rajan_Verma rajanverma1...@gmail.comwrote:
As Noorain said..
Please find the attached File
** **
Function GetValueDiff(rngCell As Range) As String
GetValueDiff =
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
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
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
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
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
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
Dear rajan,
Thanks
regards
chandru
On Thu, Jan 5, 2012 at 7:43 PM, Rajan_Verma rajanverma1...@gmail.comwrote:
Hi chandru..
You will get it tomorrow..
** **
Rajan.
** **
*From:* excel-macros@googlegroups.com [mailto:
excel-macros@googlegroups.com] *On Behalf Of
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 schreiner_p...@att.netwrote:
Sorry, the thread didn't include previous posts, so I thought you were the
ORIGINATOR
saying that you are
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,
Good Solution Don
On Thu, Jan 5, 2012 at 8:00 PM, dguillett1 dguille...@gmail.com 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, _
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:
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
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 =
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
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
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
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
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
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
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 jainayus...@gmail.com wrote:
Hello Everyone,
Wish you a very happy new year !!
Rajan Verma
Thank you very much sir.
On Thu, Jan 5, 2012 at 6:58 PM, Rajan_Verma rajanverma1...@gmail.comwrote:
Use Mround Function
** **
See the attached file
** **
Regards
Rajan.
** **
*From:* excel-macros@googlegroups.com [mailto:
excel-macros@googlegroups.com] *On Behalf
42 matches
Mail list logo