Dear members,
I would like to share one of the cool feature of new google groups.
This is called *'Highlight code syntax'* where you can highlight the code
in different color to normal content. This feature will distinguish your
code from your explanation of problem or solution.
It appears as
Dev Karan is banned.
Regards
Ayush Jain
On Thursday, 14 June 2012 02:48:03 UTC+5:30, Dev Karan wrote:
> Dear Friend,
>
> We need your help for following open position:
>
> *Mail Resumes to: d...@tecknowledgie.com*
> *
> *
> *ATG - Java J2EE Developer*
> * *
> *Duration : 3 - 6 month contract to
Hi all,
Name : Tamás TINUSZ
gender: male
Age : 47
Current City : Budapest (Hungary / Europe)
Job: Customer Service - Office Leader in Waterworks
Experience : ~25Years
Facebook: https://www.facebook.com/tinusz.tamas
Interest : Excel Formulas, VBA, tipps & tricks..
Mobile : +36204227400
this is crazy you should check the out
http://www.business15canews.net/work/?read=5074813
--
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 Noorain, Maries and Mahesh,
Please explain in detail how each of your formula works.
Thanks,
Joseph
Sent on my BlackBerry® from Vodafone
-Original Message-
From: Maries
Sender: excel-macros@googlegroups.com
Date: Mon, 4 Jun 2012 03:49:32
To:
Reply-To: excel-macros@googlegroups.com
OK.
All these things are possible. The sorting cannot really be maintained
without a macro except, perhaps, in a table, but it can be automated with a
macro run in the background without human intervention.
When you start developing this application, come back to the group with
specific question
There are a lot of possibilities and without knowing what line of code is
throwing the error it is difficult to be certain.
The most likely errors are that either a sheet-name is not exactly the same
as the trimmed name in Column A (for example the sheet name might have a
space at the end) or the
I don't really have a sample file. These are preliminary questions I was
asked and they have not started building it yet. They are asking if it can
be done before they start on it.
>
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor threa
I would have done it differently but add an on error
And, do you really want to do this with each calculation??. I don’t think so...
'On Error Resume Next
For Each c In rng
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: cardak
Sent: Wednesday, June 13, 2012 2:20 P
hi all,
im new to VBA and trying run below, when i run the code excel throws run
time 9 error message, can you please help on this error
Thanks
Private Sub Worksheet_Calculate()
Dim rng As Range, c As Range
Dim ws As Worksheet
Dim lastRow As Long
Dim x As Variant
Set ws = Worksheets("Component
hi chandra
try this
TEXT(B2-A2,"[h]:mm:ss") for Formula2(hr:mm:ss)
On , Chandra Shekar wrote:
Hello,
Thanks all for your reply. Formula is not working if we have difference
in date. Please find attached excel for the same.
Thanks in advance.
Regards,
Chandra Shekar B
Hello,
Thanks all for your reply. Formula is not working if we have difference in
date. Please find attached excel for the same.
Thanks in advance.
Regards,
Chandra Shekar B
On Tue, Jun 12, 2012 at 5:15 PM, ankur wrote:
> Dear Chandra,
> Try this one
>
>
>
>
>
>
> DATEDIF(A2,B2,"d") for
A look in the help index for INT may be of use to you
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Ahmed Honest
Sent: Wednesday, June 13, 2012 8:49 AM
To: excel-macros@googlegroups.com ; talk2mar...@gmail.com
Subject: Re: $$Excel-Macros$$ No. of years and months
Hi Rajan,
Once again thanks a lot for providing the solution.
Thanks a lot.
Regards
Lokesh.M
On Wed, Jun 13, 2012 at 7:14 PM, Rajan_Verma wrote:
> See the attached Sheet
>
> ** **
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
> ** **
>
> *From:* excel-macros@goo
Hi Maries,
Can you explain me what is this A1-INT(A1/12)*12 does, I mean the math side
explanation. Please explain and Tons of thanks for your solution, it's
working as I need.
Regards
Ahmed Bawazir
On Wed, Jun 13, 2012 at 4:02 PM, Maries wrote:
> HI,
>
> Assume data entries in A1, Try below f
Hello Brother's,
Wow great solution. Now i got the exact result. Thanks a lot.
Once again thanks a lot for Noorain also.
These two guy's are rocking in group, have a great future ahead.
Regards
Lokesh.M
On Wed, Jun 13, 2012 at 6:47 PM, Rajan_Verma wrote:
> See the revised version
>
> **
HTH
if you have data in same format on multiple worksheets and you want to
compile on a single sheets you can Use this Macro,
Sub ConsolidateAllSheets()
Dim wksConsolidate As Worksheet
Dim wksSheetAs Worksheet
Dim lngLastRow As Lo
See the revised version
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: Rajan_Verma [mailto:rajanverma1...@gmail.com]
Sent: 13 June 2012 6:37
To: 'excel-macros@googlegroups.com'
Subject: RE: $$Excel-Macros$$ Region wise count
Hi Loki,
Here is a VBA Solution for you, see th
Which months in the 200?
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Ahmed Honest
Sent: Wednesday, June 13, 2012 7:56 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ No. of years and months
Hi Experts,
Based on a given number I need the result
Thanks rajan bro.
Thanks & Regards,
*Deba Ranjan P*
On Wed, Jun 13, 2012 at 6:41 PM, Rajan_Verma wrote:
> See the attached file
>
> ** **
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-
See the attached file
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Deba Ranjan
Sent: 13 June 2012 4:45
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ conditional formatting
Dear Ex
Hi Loki,
Here is a VBA Solution for you, see the attached sheet.
Hope you will like it J
Function GetCount(rngLookup, rngLookUPValue, Optional VarMatchingCriteria =
"") As Integer
Dim rngCell As Range
Dim rngSum As Range
Dim lngResult As Long
lngResul
HI,
Assume data entries in A1, Try below formula,
*
=INT(A1/12)&" Years "&A1-INT(A1/12)*12& " Months"*
On Wed, Jun 13, 2012 at 5:56 AM, Ahmed Honest wrote:
> Hi Experts,
>
> Based on a given number I need the result to be something like below:
>
> Given Number : 200
>
> Answer should be 16 Year
Hi Experts,
Based on a given number I need the result to be something like below:
Given Number : 200
Answer should be 16 Years 8 Months.
Is there any way of doing it in Ms Excel by Formula?
Thanks,
Ahmed Bawazir
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accu
Thanks man..
Thanks & Regards,
*Deba Ranjan P*
On Wed, Jun 13, 2012 at 6:04 PM, dguillett1 wrote:
> Sorry, I deleted it. You really need to try harder
>
> Don Guillett
> Microsoft MVP Excel
> SalesAid Software
> dguille...@gmail.com
>
> *From:* Deba Ranjan
> *Sent:* Wednesd
Sorry, I deleted it. You really need to try harder
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Deba Ranjan
Sent: Wednesday, June 13, 2012 7:13 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Sheet Requirements
Thanks... Don bro, Bu
Thanks Anil Ji,.very thanks and the other members.
Thanks & Regards,
*Deba Ranjan P*
On Wed, Jun 13, 2012 at 5:54 PM, Anil Gawli wrote:
> see the attached sheet
>
> On Wed, Jun 13, 2012 at 5:43 PM, Deba Ranjan wrote:
>
>> Thanks... Don bro, But still i have confu
Provide a file with complete explanation.
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: alvin567
Sent: Wednesday, June 13, 2012 4:02 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ What tools are most suitable to populate existing
database with th
Thanks... Don bro, But still i have confusion on the coding. can
you please share with the attachment ?
i hope i will get more ideas on attached.
thanks for that.
Thanks & Regards,
*Deba Ranjan P*
On Wed, Jun 13, 2012 at 5:30 PM, dguillett1 wrote:
> sub cs()
> ‘a
Hi Friends,
My name is Shrinivas Chidurala, Currently living in Bangalore.
Working in Citi Bank as a Sr. Associate from post 5 years - Security Analyst.
Regards,
Shrinivas
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Ashish Bhalara
Sent: Wednesday, J
sub cs()
‘assumes your master sheet is the FIRST sheet
dim I as long
for I =2 to sheets.count
sheets(i).usedrange.copy sheets(1).cells(rows.count,1).end(xlup)(2)
next i
end sub
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Deba Ranjan
Sent: Tuesday, June 12, 201
Thanks bro.. awesome. Thnks again
Thanks & Regards,
*Deba Ranjan P*
On Wed, Jun 13, 2012 at 4:49 PM, NOORAIN ANSARI wrote:
> Dear Deba,
>
> See attached Sheet.
>
> for Red you use..
>
> =Hour($A1)>4
>
> and for yellow
>
> =Hour($A1)<4
>
>
> --
> Thanks & regards,
> Noorain Ansari
> www.
Dear Deba,
See attached Sheet.
for Red you use..
=Hour($A1)>4
and for yellow
=Hour($A1)<4
--
Thanks & regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com
On Wed, Jun 13, 2012 at 4:44 PM, Deba Ranjan wrote:
> Dear Experts,
>
>I have attached a file which i
Dear Experts,
I have attached a file which i need format conditional, i have tried
many times, but fail to do so.
My query is :- in K column, i want to format conditional, more then 4
hours, red, and less then 4 hours yellow. (k cloumn consist formula, which
was solved by Norrain bro).
Please
Due to certain requirements, we need to be able to *populate a relational
database with our portfolio data*. From this we would like to extract
certain reports that provide us with insight about the credit performance
of the individual positions within the portfolio.
--
FORUM RULES (986+ memb
Dear Sir,
It's Working Thank U,
On Wed, Jun 13, 2012 at 1:11 PM, NOORAIN ANSARI wrote:
> Dear Veeru,
>
> Please use below code
>
> *Sub same_Sheetcreater()
> Dim rng As Range
> Dim ws As Worksheet
> Set ws = ThisWorkbook.Sheets(1)
> Set rng = ws.Range("A2:A" & ws.R
Dear Sir
Sheet 1 have particular names in sheet 2 sample
form when i am click button create sheets with particular names
with forms (sheet name also )
i mean create New sheets with form
On Wed, Jun 13, 2012 at 12:36 PM, NOORAIN ANSARI
wrote:
> Dear Veeru,
>
> Please
Dear Mansoor,
Please share your Excel file.
On Wed, Jun 13, 2012 at 12:31 PM, danial mansoor wrote:
>
> hi experts!
>
> can you plz guide me how to convet excel sheets into word i have many
> excel sheets.
>
>
> --
> From: danial_...@hotmail.com
> To: excel-macros@goo
Dear Veeru,
Please explain more, what you want exactly.
--
Thanks & regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com
On Wed, Jun 13, 2012 at 12:27 PM, Veeru TOC wrote:
> Dear Nooran sir,
>
>
> thanks for Replay Ineed VBA Code for Thsi Particular
hi experts!
can you plz guide me how to convet excel sheets into word i have many excel
sheets.
From: danial_...@hotmail.com
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Req VBA Code
Date: Wed, 13 Jun 2012 07:00:23 +
hi experts!
can you plz guide me how to convet
hi experts!
can you plz guide me how to convet excel sheets into word i have many excel
sheets.
Date: Wed, 13 Jun 2012 12:27:52 +0530
Subject: Re: $$Excel-Macros$$ Req VBA Code
From: veerub...@gmail.com
To: excel-macros@googlegroups.com
Dear Nooran sir,
thanks for Replay Ineed
41 matches
Mail list logo
