from:"lucky singh"

Re: $$Excel-Macros$$ Summary for a Weekly report-Urgent

2012-01-11 Thread lucky singh

dear team,

Require you urgent help..

Thanks

On Thu, Jan 12, 2012 at 12:16 PM, lucky singh  wrote:

>
> Dear Team,
>
> Require a dashboard or a summary sheet for the attached weekly resource
> planning report.
>
> The format should be simple and better to understand.
>
> Thanks in Advance,
> Regards,
> Lucky
>
>  --
> 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 quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
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 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Dashboard.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

$$Excel-Macros$$ Summary for a Weekly report

2012-01-11 Thread lucky singh

Dear Team,

Require a dashboard or a summary sheet for the attached weekly resource
planning report.

The format should be simple and better to understand.

Thanks in Advance,
Regards,
Lucky

-- 
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 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com


Dashboard.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Hyperlink to Highlight weekly data

2011-12-29 Thread lucky singh

my cursor should automatically go on the data on next sheet

On Thu, Dec 29, 2011 at 7:05 PM, dguillett1  wrote:

>   I don’t understand your request. “it should highlight”
> examples
>
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
>
>  *From:* lucky singh 
> *Sent:* Thursday, December 29, 2011 3:59 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Hyperlink to Highlight weekly data
>
>
> Dear Team,
>
> Attached is the data which get updated on weekly basis i require a static
> formatted template i such a way
>
> 1. if i click a country's name in Activity Report sheet that particular
> data from the MEdata sheet.
>
> 2. If i click the campaign it should highlight that counties campaign data
> under new_partneridName.
>
>
> kindly help out with a suitable formula for a shortcut method as this
> report is sent on weekly basis and is very time consuming, can it be done
> by pivot.
>
> Request you to do the needful asap as the report has a tat line of EOD
> today.
>
> Thanks in advance,
> Lucky S
> --
> FORUM RULES (934+ 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 quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> --
> FORUM RULES (934+ 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 quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
FORUM RULES (934+ 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 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

$$Excel-Macros$$ Help on chart

2011-12-27 Thread lucky singh

Hi Team,

Request you to kindly help

I want is a grid on the right & the red line to be highlighted properly
with the blue lines

Regards,
Lucky S

-- 
FORUM RULES (934+ 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 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com


Chart.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Help for If nesting formula

2011-11-29 Thread lucky singh

Thanx to all my team member and Noorain.


On Wed, Nov 30, 2011 at 12:24 PM, NOORAIN ANSARI
wrote:

> Dear Lucky,
>
> Please paste below formula in B2 Cell.
>
> =IF(AND(A2>=$F$2,A2<=$G$2),"0-3 Month",IF(AND(A2>=$F$3,A2<=$G$3),"3-6
> Month",IF(AND(A2>=$F$4,A2<=$G$4),"6-9
> Month",IF(AND(A2>=$F$5,A2<=$G$5),"9-12
> Month",IF(AND(A2>=$F$6,A2<=$G$6),">12 Month","Prospect")
>
>
> On Wed, Nov 30, 2011 at 12:09 PM, lucky singh wrote:
>
>>
>> Hello Team,
>>
>>
>> Require your help for If nesting formula please see the attachment.
>>
>>
>> Regards,
>> Lucky
>>
>> --
>> FORUM RULES (934+ 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 quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>
>
> --
> Thanks & regards,
> Noorain Ansari
>  *http://excelmacroworld.blogspot.com/*<http://excelmacroworld.blogspot.com/>
> *http://noorain-ansari.blogspot.com/*<http://noorain-ansari.blogspot.com/>
>
>  --
> FORUM RULES (934+ 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 quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
FORUM RULES (934+ 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 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

$$Excel-Macros$$ Excel-Macros for protecting cell

2011-08-02 Thread lucky singh

Hi Team,

Attached below is the Marco code for Protecting cells in excel sheet.

Steps to Protect a cell

Step 1 - Open that particular file which you want to lock and hide any
formulas in sheet.
Step 2 - Open file "PROTECT" and press CTRL + j


Steps to Unprotect a cell
Step 1 - Open that particular file which you want to Unlock
Step 2 - Open file "PROTECT" and press CTRL + Shift + j


Enjoy Guys

You can also use the below mentioned VB Codes...


Sub Protect()
'
' Protect Macro
'
' Keyboard Shortcut: Ctrl+j
'
Cells.Select
Selection.Locked = True
Selection.FormulaHidden = True
ActiveSheet.Protect DrawingObjects:=True, Contents:=True,
Scenarios:=True _
, AllowFormattingCells:=True
End Sub
Sub Unprotect()
'
' Unprotect Macro
'
' Keyboard Shortcut: Ctrl+Shift+J
'
ActiveSheet.Unprotect
Cells.Select
Selection.Locked = False
Selection.FormulaHidden = False
End Sub


Regards,
Lucky

-- 
--
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/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


Protect.xlsm
Description: Binary data

$$Excel-Macros$$ Excel-Macros for protecting cell

2011-08-02 Thread lucky singh

Hi Team,

Attached below is the Marco code for Protecting cells in excel sheet.

Steps to Protect a cell

Step 1 - Open that particular file which you want to lock and hide any
formulas in sheet.
Step 2 - Open file "PROTECT" and press CTRL + j


Steps to Unprotect a cell
Step 1 - Open that particular file which you want to Unlock
Step 2 - Open file "PROTECT" and press CTRL + Shift + j


Enjoy Guys

You can also use the below mentioned VB Codes...


Sub Protect()
'
' Protect Macro
'
' Keyboard Shortcut: Ctrl+j
'
Cells.Select
Selection.Locked = True
Selection.FormulaHidden = True
ActiveSheet.Protect DrawingObjects:=True, Contents:=True,
Scenarios:=True _
, AllowFormattingCells:=True
End Sub
Sub Unprotect()
'
' Unprotect Macro
'
' Keyboard Shortcut: Ctrl+Shift+J
'
ActiveSheet.Unprotect
Cells.Select
Selection.Locked = False
Selection.FormulaHidden = False
End Sub


Regards,
Lucky

-- 
--
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/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ Indirect Formula Help required...

2011-06-10 Thread lucky singh

Hi Team,

Required help for indirect formula...

Thanks in advance,

Regards,
Lucky

-- 
--
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/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


TL Recital Snapshot_June.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Please help me

2011-01-19 Thread lucky singh

Hi Sudhir,

PFA...

Regards,
Lucky

On Wed, Jan 19, 2011 at 2:01 PM, sudhir kumar  wrote:

> Hi
>
> All Dear members
>
> Plz help on the following point.
>
> I want count no. of Days between two Dates.
>
> Example
>
> 1-12-10   31-12-1031
>
> thanx
>
>
> --
> Sudhir Verma
> Asstt. Mngr. A/c's
> 9818479722
> *
> P think Before you print
> *
> *
> **
> Life is Very beautiful !!!
> *
> *
> ¨`•.•´¨) Always
> `•.¸(¨`•.•´¨) Keep
> (¨`•.•´¨)¸.•´ Smiling!
>  `•.¸.•´.
> *
> *
> *
>
> --
>
> --
> 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/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
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/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


number of days.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Separate the values in different columns

2011-01-19 Thread lucky singh

hi kanti,

can u help me to extract only the mobile numbers

   +  022-2 Ex-6432341 ~+  9870188646   +  022-2 Ex-6487723  +  022-2
Ex-6658518 ~+  9821916656   +  022-2 Ex-6795123  +  0251- Ex-2311543 ~+
9869478989  ~+  2311543   +91 (022) 9920283747  ~+91 (91) 9221201496   +
(0832) 2217393  ~+91 (0) 9049914155  ~+91 (0) 9850687476  ~+91 (0)
9820194010   + (033) 9831556578  ~+91 (033) 9477092032

On Mon, Jun 21, 2010 at 11:28 PM, Kantilal Badale  wrote:

> Attached Required Formula
>
> Kantilal Badale
>
>   On Tue, Jun 15, 2010 at 11:05 AM, Saurabh Patel <
> saurabh.pa...@in.aegisglobal.com> wrote:
>
>>  Hi All,
>>
>>
>>
>> Required help in attached file
>>
>>
>>
>> *Regards,
>> Saurabh Patel*
>>
>>
>>
>> DISCLAIMER:The information contained in this electronic message and in any 
>> attachments to this message is
>>confidential, legally privileged and intended only for the person 
>> or entity to which this electronic
>>message is addressed. If you are not the intended recipient, 
>> please notify the system manager and
>>you are hereby notified that any distribution, copying, review, 
>> retransmission, dissemination or
>>other use of this electronic transmission or the information 
>> contained in it is strictly prohibited.
>>Please accordingly also note that any views or opinions presented 
>> in this email are solely those of
>>the author and may not represent those of the Company or bind the 
>> Company. This message has been
>>scanned for viruses and dangerous content by Mail Scanner, and is 
>> believed to be clean.
>>The Company accepts no liability for any damage caused by any 
>> virus transmitted by this email.
>>
>>
>> --
>>
>> --
>> 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/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> HELP US GROW !!
>>
>> We reach over 7000 subscribers worldwide and receive many nice notes about
>> the learning and support from the group.Let friends and co-workers know they
>> can subscribe to group at
>> http://groups.google.com/group/excel-macros/subscribe
>>
>
> --
>
> --
> 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/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 7000 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>

-- 
--
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/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Fwd: need help

2011-01-19 Thread lucky singh

thanx ashish will try this code

i also wanted formula to extract only the 10 digit mobile numbers from the
data list

   +  022-2 Ex-6432341 ~+  9870188646   +  022-2 Ex-6487723  +  022-2
Ex-6658518 ~+  9821916656   +  022-2 Ex-6795123  +  0251- Ex-2311543 ~+
9869478989  ~+  2311543   +91 (022) 9920283747  ~+91 (91) 9221201496   +
(0832) 2217393  ~+91 (0) 9049914155  ~+91 (0) 9850687476  ~+91 (0)
9820194010   + (033) 9831556578  ~+91 (033) 9477092032

Regards,
Lucky



On Wed, Jan 19, 2011 at 1:55 PM, ashish koul  wrote:

> codes
>
>
> Sub clear()
>
>
>
> Sheets("Score").Cells(3, 2).Value = ""
>
>
>
> Sheets("Score").Cells(4, 2).Value = ""
>
>
>
> Sheets("Score").Cells(5, 2).Value = ""
>
>
>
> Sheets("Score").Cells(6, 2).Value = ""
>
>
>
> Sheets("Score").Cells(7, 2).Value = ""
>
>
>
> End Sub
>
>
>
>
>
> Sub update()
>
> Dim z, k, s As Long
>
>
>
>
>
> For i = 1 To Sheets("Summary").Range("b65356").End(xlUp).Row
>
> If Sheets("score").Cells(2, 2).Value = Sheets("Summary").Cells(i, 2).Value
> Then
>
>
>
> z = i
>
> Exit For
>
>
>
> End If
>
> Next i
>
> Sheets("Summary").Select
>
> Sheets("Summary").Cells(z + 1, 2).Select
>
> k = Selection.End(xlToRight).Column + 1
>
>
>
>
>
> Sheets("Summary").Cells(z + 1, k).Value = Sheets("score").Cells(10,
> 2).Value
>
>
>
> Sheets("Summary").Cells(z + 2, k).Value = Sheets("score").Cells(14,
> 2).Value
>
>
>
> Sheets("Summary").Cells(z + 3, k).Value = Sheets("score").Cells(18,
> 2).Value
>
> Sheets("Summary").Cells(z + 4, k).Value = Sheets("score").Cells(22,
> 2).Value
>
>
>
> Sheets("Summary").Cells(z + 4, k).Value = Sheets("score").Cells(22,
> 2).Value
>
> Sheets("Summary").Cells(z + 5, k).Value = Sheets("score").Cells(26,
> 2).Value
>
>
>
> Sheets("Summary").Cells(z + 6, k).Value = Sheets("score").Cells(30,
> 2).Value
>
> Sheets("Summary").Cells(z + 7, k).Value = Sheets("score").Cells(34,
> 2).Value
>
>
>
> For s = z To z + 7
>
>
>
> If Sheets("Summary").Cells(s + 1, k).Value = "GOOD" Then
>
> Sheets("Summary").Cells(s + 1, k).Value = 10
>
> ElseIf Sheets("Summary").Cells(s + 1, k).Value = "AVERAGE" Then
>
> Sheets("Summary").Cells(s + 1, k).Value = 5
>
> ElseIf Sheets("Summary").Cells(s + 1, k).Value = "POOR" Then
>
> Sheets("Summary").Cells(s + 1, k).Value = 0
>
> ElseIf Sheets("Summary").Cells(s + 1, k).Value = "YES" Then
>
> Sheets("Summary").Cells(s + 1, k).Value = 10
>
> ElseIf Sheets("Summary").Cells(s + 1, k).Value = "NO" Then
>
> Sheets("Summary").Cells(s + 1, k).Value = 5
>
> Else
>
> Sheets("Summary").Cells(s + 1, k).Value = ""
>
> End if
>
> Next s
>
> End Sub
>
>
>   On Wed, Jan 19, 2011 at 10:28 AM, lucky singh wrote:
>
>>
>> sorry ashish,
>>
>> the file is not working when i click on update it opens a pop up says read
>> only, notify & cancel...
>>
>>
>> Regards,
>>
>>
>>
>>
>> On Tue, Jan 18, 2011 at 8:56 PM, ashish koul wrote:
>>
>>> check  the attachment
>>>
>>> On Tue, Jan 18, 2011 at 12:20 PM, lucky singh wrote:
>>>
>>>>
>>>> Hello,
>>>>
>>>> Guys Need your help urgently
>>>>
>>>> please
>>>>
>>>> Regrads
>>>>
>>>> -- Forwarded message --
>>>> From: lucky singh 
>>>> Date: Tue, Jan 18, 2011 at 10:51 AM
>>>> Subject: need help
>>>> To: excel-macros@googlegroups.com
>>>>
>>>>
>>>>
>>>> Hi Guys need your help,
>>>>
>>>> I have 25 agenst overall & I have to record & listen to 12 calls per
>>>> agent,
>>>>
>>>> While rating a call i'll put scores in sheet one & automatically it
>>>> should get updated in sheet 3 i.e. summary sheet & all the scores shuld get
>>>> accumulated...
>>>>
>>>> Thanx in advance
>>>>
>>>> Regards,
>>>> Lucky
&g

Re: $$Excel-Macros$$ Fwd: need help

2011-01-18 Thread lucky singh

sorry ashish,

the file is not working when i click on update it opens a pop up says read
only, notify & cancel...


Regards,




On Tue, Jan 18, 2011 at 8:56 PM, ashish koul  wrote:

> check  the attachment
>
> On Tue, Jan 18, 2011 at 12:20 PM, lucky singh wrote:
>
>>
>> Hello,
>>
>> Guys Need your help urgently
>>
>> please
>>
>> Regrads
>>
>> -- Forwarded message --
>> From: lucky singh 
>> Date: Tue, Jan 18, 2011 at 10:51 AM
>> Subject: need help
>> To: excel-macros@googlegroups.com
>>
>>
>>
>> Hi Guys need your help,
>>
>> I have 25 agenst overall & I have to record & listen to 12 calls per
>> agent,
>>
>> While rating a call i'll put scores in sheet one & automatically it should
>> get updated in sheet 3 i.e. summary sheet & all the scores shuld get
>> accumulated...
>>
>> Thanx in advance
>>
>> Regards,
>> Lucky
>>
>> --
>>
>> --
>> 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/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>
> --
> *Regards*
> * *
> *Ashish Koul*
> *akoul*.*blogspot*.com <http://akoul.blogspot.com/>
> *akoul*.wordpress.com <http://akoul.wordpress.com/>
> My Linkedin Profile <http://in.linkedin.com/pub/ashish-koul/10/400/830>
>
>
> P Before printing, think about the environment.
>
>
> --
>
> --
> 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/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
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/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ Fwd: need help

2011-01-17 Thread lucky singh

Hello,

Guys Need your help urgently

please

Regrads

-- Forwarded message --
From: lucky singh 
Date: Tue, Jan 18, 2011 at 10:51 AM
Subject: need help
To: excel-macros@googlegroups.com



Hi Guys need your help,

I have 25 agenst overall & I have to record & listen to 12 calls per agent,

While rating a call i'll put scores in sheet one & automatically it should
get updated in sheet 3 i.e. summary sheet & all the scores shuld get
accumulated...

Thanx in advance

Regards,
Lucky

-- 
--
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/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


Assessment Sheet.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

$$Excel-Macros$$ need help

2011-01-17 Thread lucky singh

Hi Guys need your help,

I have 25 agenst overall & I have to record & listen to 12 calls per agent,

While rating a call i'll put scores in sheet one & automatically it should
get updated in sheet 3 i.e. summary sheet & all the scores shuld get
accumulated...

Thanx in advance

Regards,
Lucky

-- 
--
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/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


Assessment Sheet.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

$$Excel-Macros$$ Want a formula that find the value as positive or pending as per horizontal and vertical.

2011-01-10 Thread lucky singh

Hi Friends,

Want a formula that find the value as positive or pending as per horizontal
and vertical.


Thanx...

-- 
--
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/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


Formula.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ HAPPY NEW YEAR 2011

2010-12-31 Thread lucky singh

Wish u the same dudue

does any one has excel greetings for new year if yes den plz do forward it
to me

Regards,
Lucky

On Fri, Dec 31, 2010 at 12:20 PM, SAJID MEMON wrote:

> Dear All Experts,
>
> I would like to wishing you "A VERY VERY HAPPY NEW YEAR 2011, YOU WILL BE
> MORE EXPERT IN VBA THROUGH THIS GROUP"
>
> Thanking you
>
> Sajid Memon
>
>
> --
>
> --
> 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/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>

-- 
--
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/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

Re: $$Excel-Macros$$ Merry Christmas & Happy new year...

2010-12-24 Thread lucky singh

Thanx a lot venkat


does any one has more of it...


Regards,
Lucky

On Fri, Dec 24, 2010 at 4:17 PM, Venkat  wrote:

> Hi Lucky,
>
> Find attached 
>
> Best Regards,
>
> Venkat Cv
>
>   On Fri, Dec 24, 2010 at 11:15 AM, lucky singh wrote:
>
>>
>> Hi Guys,
>>
>> Do anyone has a excel greetings for Christmas or new year...
>>
>>
>> plz do forward.
>>
>>
>> Thanx in advance,
>> Regards,
>> Lucky
>>
>> --
>>
>> --
>> 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/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>>
>> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>>
>
>
>
> --
> *Best Regards,*
> *Venkat*
> ) 91 99414 31925
>
>

-- 
--
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/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

$$Excel-Macros$$ Merry Christmas & Happy new year...

2010-12-24 Thread lucky singh

Hi Guys,

Do anyone has a excel greetings for Christmas or new year...


plz do forward.


Thanx in advance,
Regards,
Lucky

-- 
--
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/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

Re: $$Excel-Macros$$ Fwd: Specialized Data Analyst position with a Global MNC (no night shifts) ( if anyone interested )

2010-12-17 Thread lucky singh

Hi Ashish,

Jay here working as a Sr. MIS Analyst...

Do u have any thing for mumbai...

Regards,
Jay S

On Sat, Dec 18, 2010 at 11:51 AM, ashish koul  wrote:

>
>
>
> Hi,
>
> We have an urgent opportunity with one of our clients for the position of
> Reporting Data Analyst,
>
> Position: Specialized Data Analyst
> Location: Gurgaon
> Reporting to : Manager
> Must have experience in:
> VBA programming
> Automation of reports
> SQL
> writing queries in SQL/ MS Access using VBA
> Advanced excel and access knowledge.
>
> Profile:
> Assist with the migration of current reports and development of new reports
> using Excel, Powerpoint and Business Intelligence reporting tools
> Work with US and Bermuda based resources to transition reporting activities
>
> Assist with identification of opportunities for efficiency and automation
> The Analyst will be responsible for preparation and delivery of internal
> Investments reports and presentations used in Investment Management Decision
> Making.
>
>
> Experience: 3-6 years
>
> CTC: 4-5Lacs fixed + variables (negotiable in case of an exceptional
> candidates).
>
> If you are interested in this opportunity, please reply with your updated
> CV.
>
> We shall get in touch to discuss about this opportunity further.
>
> Kind Regards
> Shubha
> Kelly Services
>
>  *Disclaimer:*
> The sender of this email is registered with naukri.com as *KELLY Services*(
> helpd...@kellyservices.co.in, Kelly Services India Pvt Ltd., Unitech
> Cyber, Park, Tower C, 10th Floor, Sector -39,, GURGAON, Haryana - 122002)
> using Naukri.com services. The responsibility of checking the authenticity
> of offers/correspondence lies with you.
>
> If you consider the content of this email inappropriate or spam, you may:
>
>1. Report abuse by forwarding this email to: ab...@naukri.com
>2. You can also Block this 
> Companyfrom searching your 
> resume in the database.
>
>
> Advisory: Please do not pay any money to anyone who promises to find you a
> job. This could be in the form of a registration fee, or document processing
> fee or visa charges or any other pretext. The money could be asked for
> upfront or it could be asked after trust has been built after some
> correspondence has been exchanged. Also please note that in case you get a
> job offer or a letter of intent without having been through an interview
> process it is probably a scam and you should contact ab...@naukri.com for
> advise.
>
>   To be on the top of Employer's Resume Search Update Your Resume 
> Now
>   Your CV has only 30 seconds to impress a Recruiter. Use Resume 
> Services& see the 
> difference!
> Ads by Google   Full Time 
> Jobs
>  Entry
> Level 
> Jobs
>
> Partner Sites  Find your dream match on 
> Jeevansathi.com Get
> career advice on asknaukri.com 
>  Buy/Sell/Rent Property on 
> 99acres.com Build
> your professional network on 
> Brijj
>
> Sponsored Links  Try visual studio 2008. It's 
> Free
>
>
>
> --
> *Regards*
> * *
> *Ashish Koul*
> *akoul*.*blogspot*.com 
> *akoul*.wordpress.com 
> My Linkedin Profile 
>
>
> P Before printing, think about the environment.
>
>
> --
>
> --
> 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/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>

-- 
--
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/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email t

$$Excel-Macros$$ need your help on Validation

2010-12-14 Thread lucky singh

Hi All,

need your help on validation

if i select softdiet then only the menu of soft diet should be shown in
dropdown & not hard diet similarly to hard diet on hard diet should be shown
in dropdown & not soft diet...

Regards,

Lucky

-- 
--
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/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts


diet chart.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ need formula to extract on email ids

2010-12-14 Thread lucky singh

Thanx vaibhav it was impossible for me...

Regards,
Lucky

On Mon, Dec 13, 2010 at 9:45 PM, in.vaib...@googlemail.com <
in.vaib...@gmail.com> wrote:

> Try This,
>
>
> http://www.signaturebar.com/> http://www.signaturebar.com/uploads/images/24667.png border=0>
>
>
>   On Mon, Dec 13, 2010 at 9:37 PM, in.vaib...@googlemail.com <
> in.vaib...@gmail.com> wrote:
>
>> Hi Lucky,
>>
>> PFA, Formula pasted n column C.
>>
>> WR//
>>
>> Vaibhav J.
>>
>>
>> http://www.signaturebar.com/>> http://www.signaturebar.com/uploads/images/24667.png border=0>
>>
>>
>>
>> On Mon, Dec 13, 2010 at 12:33 PM, lucky singh wrote:
>>
>>>
>>> Hi All,
>>>
>>> need formula to extract on email ids
>>>
>>> Regards,
>>> Lucky
>>>
>>> --
>>>
>>> --
>>> 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/groups?gid=1871310
>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> Like our page on facebook , Just follow below link
>>>
>>> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>>>
>>
>>
>   --
>
> --
> 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/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>

-- 
--
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/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

$$Excel-Macros$$ need formula to extract on email ids

2010-12-13 Thread lucky singh

Hi All,

need formula to extract on email ids

Regards,
Lucky

-- 
--
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/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

$$Excel-Macros$$ Need help to get the collection date with the help of formula

2010-12-10 Thread lucky singh

Hi All,

kindly help me to get the collaction date with the help of an formula...

please refer the attachment...


Regards,
Lucky

-- 
--
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/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

$$Excel-Macros$$ plz help to automate diet chart

2010-11-19 Thread lucky singh

hi Guys

plz help me to automate diet chart

Regards,
Lucky

-- 
--
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/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts


diet chart.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ plz help to automate diet chart

2010-11-18 Thread lucky singh

hi Guys

plz help me to automate diet chart

Regards,
Lucky

-- 
--
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/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts


diet chart.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Formula Correction

2010-08-25 Thread lucky singh

Hi,

Need help in formula...

I just need the only the first name to be extracted without space or gap...

Regards,
Jay S
8108932708

-- 
--
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/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe


First Name.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Re: Exrtact only numbers.

2010-06-30 Thread lucky singh

Thank you...
Thanx a lot dude...


Regards,
Jay S


On Wed, Jun 30, 2010 at 5:06 PM, devi prasadc wrote:

> Hi Jay,
>
> I could get solutions for couple of things only.
>
> Regards
> DeviPrasad
>
> On Wed, Jun 30, 2010 at 4:03 PM, lucky singh  wrote:
> >
> > 4 variours formulas reuired...
> > sample attached along...
> > Regards,
> > Jay S
> >
> >
> > On Wed, Jun 30, 2010 at 3:21 AM, r  wrote:
> >>
> >>
> >> On 29 Giu, 12:05, lucky singh  wrote:
> >> > Hi All,
> >> >
> >> > 1. I want to extract all the numbers
> >> > 2. I want to trim only the middle name
> >> >
> >> > Regards,
> >> > Jay S
> >> >
> >> >  Nadine.xls
> >> > 18KVisualizzaScarica
> >>
> >> can you give an example of the result you want
> >> Regards
> >> r
> >>
> >> --
> >>
> >>
> --
> >> 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/groups?gid=1871310
> >> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
> >>
> >> To post to this group, send email to excel-macros@googlegroups.com
> >>
> >> <><><><><><><><><><><><><><><><><><><><><><>
> >> HELP US GROW !!
> >>
> >> We reach over 7000 subscribers worldwide and receive many nice notes
> about
> >> the learning and support from the group.Let friends and co-workers know
> they
> >> can subscribe to group at
> >> http://groups.google.com/group/excel-macros/subscribe
> >
> > --
> >
> --
> > 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/groups?gid=1871310
> > 3. Excel tutorials at http://www.excel-macros.blogspot.com
> > 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
> >
> > To post to this group, send email to excel-macros@googlegroups.com
> >
> > <><><><><><><><><><><><><><><><><><><><><><>
> > HELP US GROW !!
> >
> > We reach over 7000 subscribers worldwide and receive many nice notes
> about
> > the learning and support from the group.Let friends and co-workers know
> they
> > can subscribe to group at
> > http://groups.google.com/group/excel-macros/subscribe
> >
>
> --
>
> --
> 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/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 7000 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>

-- 
--
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/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ Re: Exrtact only numbers.

2010-06-30 Thread lucky singh

4 variours formulas reuired...

sample attached along...

Regards,
Jay S



On Wed, Jun 30, 2010 at 3:21 AM, r  wrote:

>
>
> On 29 Giu, 12:05, lucky singh  wrote:
> > Hi All,
> >
> > 1. I want to extract all the numbers
> > 2. I want to trim only the middle name
> >
> > Regards,
> > Jay S
> >
> >  Nadine.xls
> > 18KVisualizzaScarica
>
> can you give an example of the result you want
> Regards
> r
>
> --
>
> --
> 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/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 7000 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>

-- 
--
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/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe


Book3.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Urgent formula required for Stock forecasting...

2010-06-29 Thread lucky singh

Hi All,

urgent help required for forecasting stock in warehouse

I have 8 products in my warehouse month on month the balance get deducted
from it as and when it get sale

However I need to know the available stock because it takes 50 days for my
order

Regards,
Jay S
9987337414

-- 
--
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/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe


Forcast.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Exrtact only numbers.

2010-06-29 Thread lucky singh

Hi All,


1. I want to extract all the numbers
2. I want to trim only the middle name

Regards,
Jay S

-- 
--
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/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe


Nadine.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Help required with if formula

2010-05-12 Thread lucky singh

Dear All,


Kindly help with the IF formula in the attached sheet asap.

Thanks an advance.


Regards,
Lucky Singh
Sr. MIS Analyst.
9987337414

-- 
--
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/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe


fORMULA hELP.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Summary for a Weekly report-Urgent

$$Excel-Macros$$ Summary for a Weekly report

Re: $$Excel-Macros$$ Hyperlink to Highlight weekly data

$$Excel-Macros$$ Help on chart

Re: $$Excel-Macros$$ Help for If nesting formula

$$Excel-Macros$$ Excel-Macros for protecting cell

$$Excel-Macros$$ Excel-Macros for protecting cell

$$Excel-Macros$$ Indirect Formula Help required...

Re: $$Excel-Macros$$ Please help me

Re: $$Excel-Macros$$ Separate the values in different columns

Re: $$Excel-Macros$$ Fwd: need help

Re: $$Excel-Macros$$ Fwd: need help

$$Excel-Macros$$ Fwd: need help

$$Excel-Macros$$ need help

$$Excel-Macros$$ Want a formula that find the value as positive or pending as per horizontal and vertical.

Re: $$Excel-Macros$$ HAPPY NEW YEAR 2011

Re: $$Excel-Macros$$ Merry Christmas & Happy new year...

$$Excel-Macros$$ Merry Christmas & Happy new year...

Re: $$Excel-Macros$$ Fwd: Specialized Data Analyst position with a Global MNC (no night shifts) ( if anyone interested )

$$Excel-Macros$$ need your help on Validation

Re: $$Excel-Macros$$ need formula to extract on email ids

$$Excel-Macros$$ need formula to extract on email ids

$$Excel-Macros$$ Need help to get the collection date with the help of formula

$$Excel-Macros$$ plz help to automate diet chart

$$Excel-Macros$$ plz help to automate diet chart

$$Excel-Macros$$ Formula Correction

Re: $$Excel-Macros$$ Re: Exrtact only numbers.

Re: $$Excel-Macros$$ Re: Exrtact only numbers.

$$Excel-Macros$$ Urgent formula required for Stock forecasting...

$$Excel-Macros$$ Exrtact only numbers.

$$Excel-Macros$$ Help required with if formula

31 matches

Site Navigation

Mail list logo

Footer information