Congrats Rajan
On Aug 4, 7:19 am, Venkat CV wrote:
> Hi SantRam,
>
> Thank u so much...
>
> *Best Regards,*
> *Venkat *
> *Chennai*
>
> On Thu, Aug 4, 2011 at 12:21 AM, Sant Ram wrote:
> > congratulation Rajan,Ashish,Dilip,Venkat,Sunny (XLS
> > S),Noorain..
>
> > On Wed, Aug 3, 2
Hi,
Look below links See if helps...
http://www.leonelson.com/2009/08/25/windows-cannot-access-the-specified-device-path-or-file-you-may-not-have-the-appropriate-permissions-to-access-the-item/
*Best Regards,*
*Venkat *
*Chennai*
On Fri, Aug 5, 2011 at 10:16 AM, Cab Boose wrote:
> Hi
>
> I am
Hi Raghavendra,
You can attach and sent a Mail to *excel-macros@googlegroups.com* same will
be in discussion forum...
*Best Regards,*
*Venkat *
*Chennai*
*
*
On Thu, Aug 4, 2011 at 11:28 PM, Raghavendra wrote:
> Hi,
>
> Attach option is not reflecting in "new post". could you please
> advise?
That code was only of Categorize the Entered Amount in 3rd Column
Thanks
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of srinivas m
Sent: Wednesday, August 03, 2011 4:46 PM
To: rajanverma1...@gmail.com
Subject: Re: $$Excel-Macros$$ National insurance cal
Hi
I am using Win7 and Excel 2000.
Have never had problems for years, but now all of a sudden Excel will not
open. Comes up with : "Windows can not access the specified device, path
or file."
I have been advised to reload Office 2000. A couple of questions:
1. Do I reload all of Office 200
Please unsubscribe my this email ID from this group.
Thanks for all your help.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of dewbro2
Sent: 04 August 2011 21:55
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Subtract the minimum value base
Congratulations Rajan...!
Regards, Haseeb
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.l
Hi,
One easy way can be to add a helper column and use =MONTH ( B7) to
find the Month number for the date of birth in column B and then in
the lower part of column B we can use =COUNUTIF($B$7:$B$81, B84) to
see how many people were born in the first month which gives the
result as 4 in this case.
Excel test...
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/grou
Please see attachment.
On Thu, Aug 4, 2011 at 4:29 PM, Jagadeesh B S wrote:
> Pdt Jan Feb March April May June July
> A 0.52 0.60 0.60 0.71 0.71 0.66 0.00
> B 0.72 0.72 0.71 0.86 0.96 0.81 0.77
> C 3.84 4.35 4.39 3.88 4.23 4.06 3.69
> D 1.16 1.49 1.49 1.49 1.67 1.92 0.00
> E 1.13 1.32
change the formula...
ActiveCell.Formula = "=SUMIFS(D3:D20,$C$3:$C$20,"">""&EOMONTH(MAX(D3:D20),-1))"
sees on the right hand side of the = sign the two string literals
"SUMIFS(D$3:D$200,$C$3:$C$20,"
and
"&EOMONTH(MAX($D$3:$D$20),-1))"
with the > comparison operator between the
Hello dewbro,
See the attached. Used DMIN to avoid Array Formulas. Insert 3 rows above the
heading & use as shown in the attached.
HTH
Haseeb
For tips visit;
http://www.excelfox.com/forum/forum.php
--
--
Some impo
Macro.macro is a predefine function..you can automate your
report and excel work. also save your time
and macro basically backed of excel..
On Thu, Aug 4, 2011 at 3:12 PM, prince73_in wrote:
> hi
> im just starting to learn macros can any one of you guide me in th
Hi Noorain Ansari,
Ohh...sorry... I got...
Regards,
raghavendra
On Aug 4, 11:40 pm, Raghavendra wrote:
> Hi Noorain Ansari,
>
> Thanks for your reply
>
> I have one issue in this. If I have more than 1000 line items ( in
> each cell 5 characters)then the given code is not working. Could you
> p
Hi Noorain Ansari,
Thanks for your reply
I have one issue in this. If I have more than 1000 line items ( in
each cell 5 characters)then the given code is not working. Could you
please advise?
Regards,
Raghavendra
On Aug 4, 11:22 pm, NOORAIN ANSARI wrote:
> Dear Raghavendra,
>
> Please use bel
Dear Raghavendra,
Please use below code and see attached sheet...
Sub consolidate()
Dim i, j As Integer
j = Sheet1.Range("B1000").End(xlUp).Row
For i = 2 To j
If i = 2 Then
Sheet1.Range("D4").Value = Sheet1.Range("D4").Value & Sheet1.Range("B" &
i).Value
Else
Sheet1.Range("D4").Value = S
Hi,
Attach option is not reflecting in "new post". could you please
advise?
Regards,
Raghavendra
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/ex
Hi,
** **
** **
Can anyone advise me on VBA code to perform the task as mentioned in the
attachment?
** **
Regards,
Raghavendra
--
--
Some important links for excel users:
1. Follow us on TWITTER
Thnx Noorain.
On Thu, Aug 4, 2011 at 11:49 AM, NOORAIN ANSARI wrote:
>
> *Short Key* *Activity* Alt+A+Q Advance Filter Alt+D+F+A Advance
> Filter Alt+D+P Pivot Table Alt+E+I+S Fill Series Alt+E+L Delete Sheet
> Alt+H+B For Border Alt+H+F Font Colour Alt+H+F+P Format Painter
> Alt+H
I have a worksheet that tracks rates for multiple lanes by multiple
carriers. I am trying to find an easy way to calculate the difference
between the rate for each carrier on a lane and the lowest rate for a
given lane. I am spending a lot of time manually correcting formulas,
and I would like
I have a worksheet that tracks rates for multiple lanes by multiple
carriers. I am trying to find an easy way to calculate the difference
between the rate for each carrier on a lane and the lowest rate for a
given lane. I am spending a lot of time manually correcting formulas,
and I would like
I have a worksheet that tracks rates for multiple lanes by multiple
carriers. I am trying to find an easy way to calculate the difference
between the rate for each carrier on a lane and the lowest rate for a
given lane. I am spending a lot of time manually correcting formulas,
and I would like to
Macro is program which gives Result on a single Click,
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of haythamzoro...@gmail.com
Sent: Thursday, August 04, 2011 8:41 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros
Dear prince73_in,
>From my personal experience, if you regular do some jobs in excel you can
>automate this task. So you save the time in tasks.
BRegards,
Haytham Zoromba
Sent from my BlackBerry® smartphone from Etisalat Misr
-Original Message-
From: prince73_in
Sender: excel-macros@g
I can help you with this later today, but, i need more info. I'm
assuming you want to do this in a macro. what does b/w mean?
Send me a sample of the speadsheet or just an email to
i...@millsproducts.com and I will try to help.
Bill Anderson
IT Administrator
Mills Products, Inc
www.millsproducts.
Team,
Can you please help me on my query.
I want you to work on attached file itself.
Waiting for your response
Regards,
-- Forwarded message --
From: hemant shah
Date: Wed, Aug 3, 2011 at 9:26 PM
Subject: $$Excel-Macros$$ Need help on Email from Excel
To: excel-macros
Dear
Select February – July data
First rule :
=(C2-B2)/B2>0.05 è Red
Second rule :
=AND((C2-B2)/B2>0,(C2-B2)/B2<=0.05) è yellow
Third rule :
=C2mailto:excel-macros@googlegroups.com] De
la part de Jagadeesh B S
Envoyé : jeudi 4 août 2011 13:00
À : excel-macros@googlegroups.com
Objet : $$Excel-Mac
I got the point, can you attach a sample file for me to apply revised logic.
Regards,
DILIPandey
On 8/4/11, tuffhu...@yahoo.com wrote:
> Thanks for the time. However, it's not quite what I was looking for.
>
> I am trying to design a user form that basically interviews the user. The
> first qu
Send ur queries on this id , regarding this job
shashi@avvasinfotech.com
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Sanjay Maurya
Sent: Thursday, August 04, 2011 12:45 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ !!!JOB!!!
Thanks for the time. However, it's not quite what I was looking for.
I am trying to design a user form that basically interviews the user. The
first question will be "What manufacturer"? (Instead of a list box, I think
a combo box is actually better). There are at least 5 different choices
Hi Arun,
Excel Macros...can Speed up your work...and all routine works we can
automate and save the time &Manpower by Using VBA...and for More info Please
look Below Links..
http://office.microsoft.com/en-us/excel-help/about-macros-in-excel-HP005201201.aspx
http://answers.yahoo.com/question/index?
I first encountered this problem in Excel2007.
Not at all in Excel2003.
What I discovered is that it seems to be a Windows Priority issue.
(Possibly an XP issue after all!)
What seems to happen is that while the macro is running,
and nothing else is going on, Excel is the "highest" priority
for
hi
im just starting to learn macros can any one of you guide me in this
task. let me know the use of macros as well.
with regards
arun
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tric
Pdt Jan Feb March April May June July
A 0.52 0.60 0.60 0.71 0.71 0.66 0.00
B 0.72 0.72 0.71 0.86 0.96 0.81 0.77
C 3.84 4.35 4.39 3.88 4.23 4.06 3.69
D 1.16 1.49 1.49 1.49 1.67 1.92 0.00
E 1.13 1.32 1.32 1.57 1.57 1.44 0.00
F 1.14 1.29 1.29 1.29 3.12 3.18 0.00
I can to apply conditional formatting
thankss noorain
On Thu, Aug 4, 2011 at 11:49 AM, NOORAIN ANSARI wrote:
>
> *Short Key* *Activity* Alt+A+Q Advance Filter Alt+D+F+A Advance
> Filter Alt+D+P Pivot Table Alt+E+I+S Fill Series Alt+E+L Delete Sheet
> Alt+H+B For Border Alt+H+F Font Colour Alt+H+F+P Format Painter
> Alt+H+F
Dear All,
There is the minor puzzle and answer too.
Regards,
Bhushan Sabbani.
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Joi
can you share the macro with us
On Thu, Aug 4, 2011 at 11:58 AM, Stuart Redmann wrote:
> On 3 Aug., Rruffpaw wrote:
> > I have a very large Excel spreadsheet (13 MB) with several macros. One
> > of them runs a loop with multiple commands.
> >
> > The macro runs fine, as long as I sit back and ju
On 3 Aug., Rruffpaw wrote:
> I have a very large Excel spreadsheet (13 MB) with several macros. One
> of them runs a loop with multiple commands.
>
> The macro runs fine, as long as I sit back and just watch it run. If I
> click on another window however, it invariably freezes and I have to
> termi
38 matches
Mail list logo
