Thanks all.
Thanks & Regards,
*Deba Ranjan P*
On Mon, Jun 18, 2012 at 11:27 PM, NOORAIN ANSARI
wrote:
> Dear Deba Ranjan,
>
> See attachment, we can create it from here.
>
> --
> Thanks & regards,
> Noorain Ansari
> www.noorainansari.com
> www.excelmacroworld.blogspot.com
>
> On
Thanks Rajan ji, Is working fine.
Dear Don ji, exactly the same you expect, i mean it should copy and past
in the below row and correspondingly the same for other which is unique.
Thanks all.
Thanks & Regards,
*Deba Ranjan P*
On Mon, Jun 18, 2012 at 9:02 PM, dguillett1 wrote:
>
Definitely agreed.
-Original Message-
From: Ayush Jain
Sender: excel-macros@googlegroups.com
Date: Mon, 18 Jun 2012 23:41:44
To:
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Re: MIS executive
Vaibhav,
Allowing job posts is not only moderation but an invitatio
Vaibhav,
Allowing job posts is not only moderation but an invitation to spammers,
recruiters and employers for job posting.
I really do not want that to happen in this forum.
Banning job posts is not my sole decision but decided after the feedback of
many members in this forum.
Let's keep the sc
I would appreciate if you could take the discussion about job postings off
of the forum. Ayush has stated his decision regarding job postings as of
now. As he mentioned, once this is allowed, people start abusing the
option. That is why it has been banned.
For job seekers, there are numerous job s
Hi Ayush,
Why can't we have separate team of moderator like other sites.
-Original Message-
From: Ayush Jain
Sender: excel-macros@googlegroups.com
Date: Mon, 18 Jun 2012 23:02:07
To:
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Re: MIS executive
Hello All,
T
Hello All,
Thank you for sharing your views.
When I allowed the job posting earlier, people started posting all kind of
jobs. For me it is very difficult to moderate each job posts, and ban
people just because of job posting.
I will definitely think of channelising the job posts or add a link whe
Dear All,
Please share Dashboard Examples/Templates
I already viewed Chandoo's Site so no reference to that site.
--
Pankaj Kumar
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formu
I think you should try yourself, we can just give you the way that how you
can accomplish the task , if you feel any confusion in implement the
progress bar code in your module .. let us know
I will be happy to help you J
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macr
Hi,
Thank you everyone who has given a feedback to Ayush and he may come take
this as +ve feedback.
Please do call me if someone who is really looking for MIS profile and
ready for face to face interview.
On Mon, Jun 18, 2012 at 9:49 PM, pankaj gmail account
wrote:
> Hi To All,
>
> I also agr
Hi To All,
I also agree that we should also think about Job Posting in this forum.
If a Needy gets Job with our help that's the best result of the forum.
OK I also agree that this is not a Job Forum but instead of joining other
Job forums we should think some alternative like we can use some Mand
Thanks Don ,
But i am not able to understand this that is the reason i am asking for
help.
Regards,
Avinash
On Monday, June 18, 2012 8:57:26 PM UTC+5:30, Don Guillett wrote:
>
> http://oreilly.com/pub/h/2607
>
> Don Guillett
> Microsoft MVP Excel
> SalesAid Software
> dguille...@gmail.co
Thanks Don ,
But i am not able to understand this that is the reason i am asking for
help.
Regards,
Avinash
On Monday, June 18, 2012 8:57:26 PM UTC+5:30, Don Guillett wrote:
>
> http://oreilly.com/pub/h/2607
>
> Don Guillett
> Microsoft MVP Excel
> SalesAid Software
> dguille...@gmail.co
As is often the case you do not fully explain. Do you want a BLANK row below or
copy (and insert) the value and what to do with
Mah 5-10 L Aurangabad
Mah 1-5 L Kolhapur
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Deba Ranjan
Sent: Monday, June
http://oreilly.com/pub/h/2607
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Avinash
Sent: Monday, June 18, 2012 10:20 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Progress Bas for macro status - Help Required
Hi Rajan,
Thanks for your he
You just need to increase command bar width on every step ,
Send us your file with code to get desired result
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Avinash
Sent: 18 June 2012 8:50
To: exc
Hi Rajan,
Thanks for your help but can u please tell me how can i use this progress
bar in to my existing code i mean it is loading directly towards the end
but i want it should run like when my* first step gets completed* it should
say *10 % complete* and till *10 step* it should say *100% com
Try this:
Sub AddOneMore()
Dim rngRange As Range
Dim rngCell As Range
Set rngRange = Range("A1")
For Each rngCell In rngRange.CurrentRegion.Columns(1).Cells
If rngCell.Value = "" Then Exit For
If WorksheetFunction.CountIf(rngRange.Curr
Hello Rajan,
Thanks its working fine.
Regards,
Chandra Shekar B
On Mon, Jun 18, 2012 at 3:08 PM, Rajan_Verma wrote:
> ** **
>
> ** **
>
> =INT(B2-A2) in C2
>
> ** **
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
> ** **
>
> *From:* excel-macros@googlegroups.com
Dear Experts,
Please find the attached file. There is 39 Unique name in MARKET NAME, in
every market name is double (compulsary double), if the market name is
single then we need to add one row for making double .
Eg. if kolkata is single, so we need to add 1 row below the kolkata, is
there
Hi Santosh,
Nicely solved.
I checked IF condition but I've not understood how you set criteria for
different names. Ex .Selecting Halfday Leave will result HL in status
column.
How to set that. Can explain please.
Regards,
Suyog
On Monday, 18 June 2012 14:07:48 UTC+5:30, santosh wrote:
>
> Hi
=INT(B2-A2) in C2
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Chandra Shekar
Sent: 18 June 2012 6:18
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Date
Hello Rajan,
OOPS
Put a space between select and case
selectcase
select case
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
-Original Message-
From: jonnie...@gmail.com
Sent: Monday, June 18, 2012 4:10 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Need he
Try
Sub FooterSAS()
selectcase InputBox("Enter 1=Confidental, 2=For Internal Use Only 3=Other")
Case Is = 1: x = "Confidental"
Case Is = 2: x = "For Internal Use Only"
Case Is = 3: x = "Restricted"
Case Else
End Select
For Each wk In Application.Workbooks
For Each sh In wk.Worksheets
'
See the attached file
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Avinash
Sent: 18 June 2012 2:35
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Progress Bas for macro status - He
Hello Rajan,
Thanks for your reply.For example If date in Cell C2 18/06/2012 14:44:04
and in Cell D2 19/06/2012 14:42:04 then formula should show 0 because as
per time one day is not completed.
I hope this is clear.
Thanks,
Chandra Shekar B
On Mon, Jun 18, 2012 at 9:31 AM, ankur wrote:
> hi
press F5 > click special button > select blanks button
selected cell delete
On Fri, Jun 15, 2012 at 11:56 AM, Excel Vba wrote:
> Hi Smitha,
>
> PFA Workbook. I hope this will help u.
>
> Regards,
> Hemant.
>
>
>
> --
Hi Friends,
I am agree with Yogananda because many people are spending their time here
to learn excel concepts with the intention to get the job and hence if
someone is providing such nice opportunities then I think it is good.
Moreover, only related job posting should be there (with excel, access
yes, datavalidation-input message
Regards:
CMA Ankur Pandey
On Fri, Jun 15, 2012 at 4:13 PM, Anil Gawli wrote:
> Yes that is created by data validation
> Ahmed is Right.
> Regards,
> Gawli Anil
>
> On Fri, Jun 15, 2012 at 4:03 PM, Ahmed Honest wrote:
>
>> Dear Deba,
>>
>> That's INput
Thanks Manoj for you help.
But i want progress bar macro formatting macro i already have i
have mentioned sample macro code not my actual code.
Regards,
Avinash
On Monday, June 18, 2012 11:05:34 AM UTC+5:30, Manoj Kumar wrote:
>
> Dear Avinash.
>
>
> Sub gg()
>
> For a = 1 To Sheets.Count
> S
Santhosh for 1st june she get comp off and your formula is correct, and 2nd
june she had worked but half day that is also correct.
The problem is "Leave with loss of pay" for "Sachin G.A" he had no leaves
and no production. so i need "LOP" for this perticular person.
Regards
Lokesh
On Mon, Jun 1
Hi Santhosh,
Yes you are right, but when the amt is "0" with an comment "comp Off,
Halfday Leave, Loss of pay, Move to other project, Unplanned leave", that
time i need *this condition "See if the amt is "0" with comment It should
be "COMP","LOP","J","UL","M",*
And *See if amt is "0" without any
Hi Lokesh,
As per you comments these are the below conditions that come up
1 If total amount colum is more than "0" it should be treated a "P"
2 If total amount colum is "0" without any comment, it should be treated as
"L"
3 If total amount colum is "0" with the comment Unplanned Leave , it
hi chandra
Sorry for late reply
Please find the attached file for the solution,as i suggested you earlier
Regards:
CMA Ankur Pandey
On Fri, Jun 15, 2012 at 8:36 PM, Rajan_Verma wrote:
> Hi,
>
> ** **
>
> I think I am not getting you .
>
> Can you please explain how you want to get
34 matches
Mail list logo
