Fwd: $$Excel-Macros$$ Copying Value by Column Header Name into new Sheet

[C.G.Kumar]

Hi,


The macro is close to expectation but still need fix.


Total Quantity as per data sheet(Sheet 1) is matching with "results" sheet
..

But, *total value* as per data sheet (Sheet 1) is not matching with but the
value captured by macro is not correct.

Guess the price pulled by macro is first price of the part number falling
in that column .

For example  : Part  Number 3716-000275 has 166 Qty @ 163.40 and 166 Qty @
0 price whereas in result sheet Part  Number 3716-000275 has only one rate
@163.40 .

This lead to GAP of INR  13398.80 in Value of part number 3716-000275.




May you please review and fix the error.


Results - Part Number wise (Using Pivot) Data captured through Macro
Part Number Qty Sum Value Sum Part Number Qty Sum Value Sum GAP
3716-000275 164 26797.6 3716-000275 164 13398.8 13398.8
3716-000275-H 166 0 3716-000275-H 166 0 0
3719-001543 306 2487.78 3719-001543 306 829.26 1658.52
3719-001545 575 12362.5 3719-001545 575 3633.5 8729
3719-001554-H 220 0 3719-001554-H 220 0 0
3719-001565 660 5365.8 3719-001565 660 1341.45 4024.35
3719-001554 16 1513.6 3719-001554 16 1513.6 0
3719-001802 165 97911 3719-001802 165 97911 0
3719-001979 402 43456.2 3719-001979 402 7242.7 36213.5
3719-001575-E 102 0.102 3719-001575-E 102 0.102 0
3719-001803 165 104297 3719-001803 165 104296.5 0
6001-001213 67 0.067 6001-001213 67 0.067 0
Total : 3008 294191 3008 230167 64024.17








-- Forwarded message --
From: Paul Schreiner 
Date: Wed, Oct 26, 2016 at 6:27 PM
Subject: Re: $$Excel-Macros$$ Copying Value by Column Header Name into new
Sheet
To: "excel-macros@googlegroups.com" 


I wrote a macro to report the data.

Take a look at the attached file and see if you can follow along.

*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 as ever you can.” - John Wesley*
-


On Wednesday, October 26, 2016 2:58 AM, C.G.Kumar <
kumar.bemlmum...@gmail.com> wrote:


Hi,


Thanks for looking at my query.


Background (Why the data is scattered) : Data are shared by multiple team
(18-20) and after consolidation it becomes a table where Part Number , Qty
, Price and Value are repeated 18-20 times.  - Example refer Sheet 1
attached of raw data.

Desired output is to pull data of all adjacent cells where Part Number is
not blank.

If Part Number is not blank, pull qty and value of that specific part
number from Sheet 1 and paste value Result Sheet in respective column.

  -  Refer "Results" Sheet -Based on part number not blank  in column A of
Sheet 1 and pulling qty and Value (C&D).
  - Similar results need to be pulled from all subsequent column till last
column with Part Number heading.



Don't know if i explain enough to understand the desired output. In case
not, please ask.


br,

CGK


On Wed, Oct 26, 2016 at 12:37 AM, Paul Schreiner 
wrote:

Without seeing your actual workbook, I'm only guessing.

What do you mean by the code "not giving desired output"?

I created a workbook with two sheets called "Sheet1" and "Sheet2".

In Sheet1 I put several column headings and made three of them equivalent
to:
Part Number
Qty
Value

I noticed that in your description, you said you had columns:
"Part No", "Qty", "Value"

but in your code, you used:
desc = WorksheetFunction.Match("Part Number", Rows("1:1"), 0)

If your data actually has "Part No" instead of "Part Number", then this
will produce an error.

When I created a sample with "Part Number" in the heading,
the code worked properly.

What is yours doing?

*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 as ever you can.” - John Wesley*--
---


On Tuesday, October 25, 2016 10:58 AM, C.G.Kumar 
wrote:


Does anyone help me to fix the VB code (I'm not a VB guru either)for  an
Open spreadsheet -
Purpose : when looking in a spreadsheet, I to look for a couple of column
header names, and then copy those columns only (in a predefined order) into
a clean separate worksheet.


For example,
On Sheet 1 -
Out of say 30 column headers (with data underneath), look for column
headers called "Part No", "Qty", "Value"
Then copy value to Sheet 2 -"Part No", "Qty", "Value".

Below codes (copied from web) are not giving desired output and i don't
have clue to fix the error.


Sub Getvalues()
Sheets("sheet1").Select
desc = WorksheetFunction.Match("Part Number", Rows("1:1"), 0)
QTY = WorksheetFunctio

Re: $$Excel-Macros$$ Copying Value by Column Header Name into new Sheet

[C.G.Kumar]

Hi,


Thanks for looking at my query.


Background (Why the data is scattered) : Data are shared by multiple team
(18-20) and after consolidation it becomes a table where Part Number , Qty
, Price and Value are repeated 18-20 times.  - Example refer Sheet 1
attached of raw data.

Desired output is to pull data of all adjacent cells where Part Number is
not blank.

If Part Number is not blank, pull qty and value of that specific part
number from Sheet 1 and paste value Result Sheet in respective column.

  -  Refer "Results" Sheet -Based on part number not blank  in column A of
Sheet 1 and pulling qty and Value (C&D).
  - Similar results need to be pulled from all subsequent column till last
column with Part Number heading.



Don't know if i explain enough to understand the desired output. In case
not, please ask.


br,

CGK


On Wed, Oct 26, 2016 at 12:37 AM, Paul Schreiner 
wrote:

> Without seeing your actual workbook, I'm only guessing.
>
> What do you mean by the code "not giving desired output"?
>
> I created a workbook with two sheets called "Sheet1" and "Sheet2".
>
> In Sheet1 I put several column headings and made three of them equivalent
> to:
> Part Number
> Qty
> Value
>
> I noticed that in your description, you said you had columns:
> "Part No", "Qty", "Value"
>
> but in your code, you used:
> desc = WorksheetFunction.Match("Part Number", Rows("1:1"), 0)
>
> If your data actually has "Part No" instead of "Part Number", then this
> will produce an error.
>
> When I created a sample with "Part Number" in the heading,
> the code worked properly.
>
> What is yours doing?
>
> *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 as ever you can.” - John Wesley*
> -
>
>
> On Tuesday, October 25, 2016 10:58 AM, C.G.Kumar <
> kumar.bemlmum...@gmail.com> wrote:
>
>
> Does anyone help me to fix the VB code (I'm not a VB guru either)for  an
> Open spreadsheet -
> Purpose : when looking in a spreadsheet, I to look for a couple of column
> header names, and then copy those columns only (in a predefined order) into
> a clean separate worksheet.
>
>
> For example,
> On Sheet 1 -
> Out of say 30 column headers (with data underneath), look for column
> headers called "Part No", "Qty", "Value"
> Then copy value to Sheet 2 -"Part No", "Qty", "Value".
>
> Below codes (copied from web) are not giving desired output and i don't
> have clue to fix the error.
>
>
> Sub Getvalues()
> Sheets("sheet1").Select
> desc = WorksheetFunction.Match("Part Number", Rows("1:1"), 0)
> QTY = WorksheetFunction.Match("Qty", Rows("1:1"), 0)
> Value1 = WorksheetFunction.Match("Value", Rows("1:1"), 0)
>
>
> Sheets("sheet1").Columns(desc).Copy Destination:=Sheets("sheet2").
> Range("A1")
> Sheets("sheet1").Columns(QTY).Copy Destination:=Sheets("sheet2").
> Range("B1")
> Sheets("sheet1").Columns(Value1).Copy Destination:=Sheets("sheet2").
> Range("C1")
>
> End Sub
>
>
> Any help and VB examples would be much appreciated.
>
> Best regards
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 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) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.c

$$Excel-Macros$$ Copying Value by Column Header Name into new Sheet

[C.G.Kumar]

Does anyone help me to fix the VB code (I'm not a VB guru either)for  an
Open spreadsheet -
Purpose : when looking in a spreadsheet, I to look for a couple of column
header names, and then copy those columns only (in a predefined order) into
a clean separate worksheet.


For example,
On Sheet 1 -
Out of say 30 column headers (with data underneath), look for column
headers called "Part No", "Qty", "Value"
Then copy value to Sheet 2 -"Part No", "Qty", "Value".

Below codes (copied from web) are not giving desired output and i don't
have clue to fix the error.


Sub Getvalues()
Sheets("sheet1").Select
desc = WorksheetFunction.Match("Part Number", Rows("1:1"), 0)
QTY = WorksheetFunction.Match("Qty", Rows("1:1"), 0)
Value1 = WorksheetFunction.Match("Value", Rows("1:1"), 0)


Sheets("sheet1").Columns(desc).Copy
Destination:=Sheets("sheet2").Range("A1")
Sheets("sheet1").Columns(QTY).Copy
Destination:=Sheets("sheet2").Range("B1")
Sheets("sheet1").Columns(Value1).Copy
Destination:=Sheets("sheet2").Range("C1")

End Sub


Any help and VB examples would be much appreciated.

Best regards

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Re: Macro for Ageing of Inventory

[C.G.Kumar]

Dear Vaibhav,

I would try to explain how we do it manually so that it is

*Cell C-5 refers to quantity found after Physical Counting. (IT has some
900 rows of unique items).*

To determine ageing of Inventory, the item code is looked into "Purchase
Data". If material code is not available in purchase sheet,Ageing is Zero
"0". If material code is found then,

data in purchase sheet is sorted at two level, first material(small to
large) and second doc date (Newest to Oldest)

[image: Inline image 1]

After this, we put filter on material like below (*Same Material code as
put by user  in B4*)

[image: Inline image 3]
[image: Inline image 2]

Then , select qty equal to physically available and entered in Cell C5 in
Inventory List.

For these 8 qty ageing ,Ageing days and value are are updated in Worksheet.

[image: Inline image 4]

This activity need to be repeated for list containing around 900 -1200 rows
of material code.

Doing manually is time consuming and accuracy not certain.

Format of data and result expected is shown for one item code on "Inventory
List" Tab


Hope you can advise either formula or macro  to determine ageing and
purchase value.








On Wed, Dec 24, 2014 at 12:59 PM, Vaibhav Joshi  wrote:

> I did not got the logic of putting 8 in cell C5, can u pl explain..
>
> +
> *I did not do this for you. God is here working through me for you.*
>
> On Tue, Dec 23, 2014 at 9:18 PM, C.G.Kumar 
> wrote:
>
>> May someone please look and advise macro to solve the puzzle.
>>
>> Thanks and Regards,
>> C.G.Kumar
>>
>> -- Forwarded message -
>> From: C.G.Kumar 
>> Date: Mon Dec 22 2014 at 7:09:55 PM
>> Subject: Re: $$Excel-Macros$$ Re: Macro for Ageing of Inventory
>> To: excel-macros@googlegroups.com 
>>
>>
>> Macro is not providing desired result.
>>
>> Attached worksheet looks at total Purchase of Specific qty and provides
>> ageing.
>>
>> But the need is to have ageing (& Value) of balance stock only.
>>
>> This mean in Solved worksheet of yours, total qty left in Cell "B5" is to
>> be keyed in Manually and macro is expected to fill all other data.
>>
>> Modified your worksheet and highlighted area in Yellow of Desired result.
>>
>>
>> Hope I explained enough details for try .
>>
>>
>>
>>
>> On Mon, Dec 22, 2014 at 6:23 PM, Mandeep Baluja 
>> wrote:
>>
>>> Try this File hope it reach you expected Result.
>>>
>>>
>>> Regards,
>>> Mandeep Baluja
>>> LearningZmyPassion
>>> https://www.linkedin.com/profile/view?id=312532939
>>> https://www.facebook.com/VBAEXCELSQL?ref=hl
>>>
>>>
>>> On Monday, December 22, 2014 9:44:49 AM UTC+5:30, kumar wrote:
>>>>
>>>> Hi,
>>>>
>>>> I have purchase data in a spreadsheet and List of Inventory Items on
>>>> another worksheet of excel.
>>>>
>>>> May someone help me with a macro or advance formula which computes
>>>> Ageing of Inventory.
>>>>
>>>> Age of Inventory is calculated in Purchase Sheet but do not know how to
>>>> compute for available qty only.
>>>>
>>>> Sample Sheet attached.
>>>>
>>>>
>>>>  --
>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES
>>>
>>> 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) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>>> members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To unsubscribe from this group and stop receiving emails from it, send
>>> an email to excel-macros+unsubscr...@googlegroups.com.
>>> To post to this group, send email to excel-macros@googlegro

Fwd: $$Excel-Macros$$ Re: Macro for Ageing of Inventory

[C.G.Kumar]

May someone please look and advise macro to solve the puzzle.

Thanks and Regards,
C.G.Kumar
-- Forwarded message -
From: C.G.Kumar 
Date: Mon Dec 22 2014 at 7:09:55 PM
Subject: Re: $$Excel-Macros$$ Re: Macro for Ageing of Inventory
To: excel-macros@googlegroups.com 


Macro is not providing desired result.

Attached worksheet looks at total Purchase of Specific qty and provides
ageing.

But the need is to have ageing (& Value) of balance stock only.

This mean in Solved worksheet of yours, total qty left in Cell "B5" is to
be keyed in Manually and macro is expected to fill all other data.

Modified your worksheet and highlighted area in Yellow of Desired result.


Hope I explained enough details for try .




On Mon, Dec 22, 2014 at 6:23 PM, Mandeep Baluja 
wrote:

> Try this File hope it reach you expected Result.
>
>
> Regards,
> Mandeep Baluja
> LearningZmyPassion
> https://www.linkedin.com/profile/view?id=312532939
> https://www.facebook.com/VBAEXCELSQL?ref=hl
>
>
> On Monday, December 22, 2014 9:44:49 AM UTC+5:30, kumar wrote:
>>
>> Hi,
>>
>> I have purchase data in a spreadsheet and List of Inventory Items on
>> another worksheet of excel.
>>
>> May someone help me with a macro or advance formula which computes Ageing
>> of Inventory.
>>
>> Age of Inventory is calculated in Purchase Sheet but do not know how to
>> compute for available qty only.
>>
>> Sample Sheet attached.
>>
>>
>>  --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 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) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


Ageing Inventory_Kumar (5).xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12

Re: $$Excel-Macros$$ Cash Flow Dashboard

[C.G.Kumar]

Thanks Vaibhav .

Will look at chandoo.com .

On Mon, 22 Dec 2014 15:40 Vaibhav Joshi  wrote:

> PFA, this is what i found on Web, however you can check on chandoo.org.
>
> Cheers!!
>
> +
> *I did not do this for you. God is here working through me for you.*
>
> On Mon, Dec 22, 2014 at 10:23 AM, C.G.Kumar 
> wrote:
>
>> Hi,
>>
>> I would appreciate if anyone can help me with Cash Flow Dashboard.
>>
>> Many Thanks,
>>
>> C.G.Kumar
>>
>> --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 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) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>  --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 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) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Re: Macro for Ageing of Inventory

[C.G.Kumar]

Macro is not providing desired result.

Attached worksheet looks at total Purchase of Specific qty and provides
ageing.

But the need is to have ageing (& Value) of balance stock only.

This mean in Solved worksheet of yours, total qty left in Cell "B5" is to
be keyed in Manually and macro is expected to fill all other data.

Modified your worksheet and highlighted area in Yellow of Desired result.


Hope I explained enough details for try .




On Mon, Dec 22, 2014 at 6:23 PM, Mandeep Baluja 
wrote:

> Try this File hope it reach you expected Result.
>
>
> Regards,
> Mandeep Baluja
> LearningZmyPassion
> https://www.linkedin.com/profile/view?id=312532939
> https://www.facebook.com/VBAEXCELSQL?ref=hl
>
>
> On Monday, December 22, 2014 9:44:49 AM UTC+5:30, kumar wrote:
>>
>> Hi,
>>
>> I have purchase data in a spreadsheet and List of Inventory Items on
>> another worksheet of excel.
>>
>> May someone help me with a macro or advance formula which computes Ageing
>> of Inventory.
>>
>> Age of Inventory is calculated in Purchase Sheet but do not know how to
>> compute for available qty only.
>>
>> Sample Sheet attached.
>>
>>
>>  --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 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) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


Ageing Inventory_Kumar (5).xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12

Re: $$Excel-Macros$$ Re: Macro for Ageing of Inventory

[C.G.Kumar]

Hi,


At year end, we need to determine age of Items left in Inventory.

For example, we are left with 2 pieces of Material Part No.357000 at year
end, and need to determine age of these two quantities of material based on
purchase.

We go to purchase data and find most recent purchase.

Recent Purchase (1) : 1 qty On 14.02.2014 so, Age of 1 qty is* 289 days.*

Then we look again on purchase and find recent purchase (2)  before Recent
Purchase (1)

Recent Purchase (2) is of qty 1 on 26.06.2013 so age of balance qty is *522
days. *

*This process continues till age of quantities left in stock are
calculated.*

*After calculation of age , it is plotted in Ageing Table. ( Colm H to Q)*

*In given example, age of two qty is *

*Qty 1 Age is 289, so, "1" is placed in col N of part number 357000 row 3*

*Another Qty 1 is 522 days old, so "1" is placed in col O **of part number
357000 row 3*




*Please see attached excel sample file.*


*Let me know if further details are required.*


*Many Thanks,*

*C.G.kumar*










On Mon, Dec 22, 2014 at 3:15 PM, Mandeep Baluja 
wrote:

> Please explain your Query Again I an unable to understand it . Aeging can
> be count but on what criteria whether on particular order no, material no ,
> document no. where is availble qty column.
>
>
> On Monday, December 22, 2014 9:44:49 AM UTC+5:30, kumar wrote:
>>
>> Hi,
>>
>> I have purchase data in a spreadsheet and List of Inventory Items on
>> another worksheet of excel.
>>
>> May someone help me with a macro or advance formula which computes Ageing
>> of Inventory.
>>
>> Age of Inventory is calculated in Purchase Sheet but do not know how to
>> compute for available qty only.
>>
>> Sample Sheet attached.
>>
>>
>>  --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 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) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


Ageing Inventory_Kumar.xlsx
Description: MS-Excel 2007 spreadsheet

Re: $$Excel-Macros$$ Re: Macro for Ageing of Inventory

[C.G.Kumar]

Please see attached file.

Let me know if any additional info is required.



On Mon, Dec 22, 2014 at 3:18 PM, Anil Gawli  wrote:

> Dear Rockernayal,
>
> Pls share a workbook with us.
>
> Regards,
> Gawli Anil
>
> On Mon, Dec 22, 2014 at 3:15 PM, Mandeep Baluja 
> wrote:
> > Please explain your Query Again I an unable to understand it . Aeging
> can be
> > count but on what criteria whether on particular order no, material no ,
> > document no. where is availble qty column.
> >
> >
> > On Monday, December 22, 2014 9:44:49 AM UTC+5:30, kumar wrote:
> >>
> >> Hi,
> >>
> >> I have purchase data in a spreadsheet and List of Inventory Items on
> >> another worksheet of excel.
> >>
> >> May someone help me with a macro or advance formula which computes
> Ageing
> >> of Inventory.
> >>
> >> Age of Inventory is calculated in Purchase Sheet but do not know how to
> >> compute for available qty only.
> >>
> >> Sample Sheet attached.
> >>
> >>
> > --
> > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> > https://www.facebook.com/discussexcel
> >
> > FORUM RULES
> >
> > 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) Jobs posting is not allowed.
> > 6) Sharing copyrighted material and their links is not allowed.
> >
> > NOTE : Don't ever post confidential data in a workbook. Forum owners and
> > members are not responsible for any loss.
> > ---
> > You received this message because you are subscribed to the Google Groups
> > "MS EXCEL AND VBA MACROS" group.
> > To unsubscribe from this group and stop receiving emails from it, send an
> > email to excel-macros+unsubscr...@googlegroups.com.
> > To post to this group, send email to excel-macros@googlegroups.com.
> > Visit this group at http://groups.google.com/group/excel-macros.
> > For more options, visit https://groups.google.com/d/optout.
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 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) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE  : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


Ageing Inventory_Kumar.xlsx
Description: MS-Excel 2007 spreadsheet

Re: $$Excel-Macros$$ Macro for Ageing of Inventory

[C.G.Kumar]

Hi,

The formula added does not help in case Available Qty is less than last
purchase qty.

Further, Ageing can be located in more than a period.Please see red marked
result.

Formula need to be executed for  line items more than 12000.

Do Not believe  a formula can solve this.


Thanks a lot for your support .

Regards,

C.G.Kumar





On Mon, Dec 22, 2014 at 10:15 AM, Ashish Bhalara 
wrote:

> Mr.C.G.Kumar
> See attached file as your require function.
>
> Regards.
> Ashish Bhalara
> 9624111822
> P*Please do not print this email unless it is absolutely necessary.
> Spread environmental üawareness.♣♣♣*
>
>
> On Mon, Dec 22, 2014 at 9:44 AM, C.G.Kumar 
> wrote:
>
>> Hi,
>>
>> I have purchase data in a spreadsheet and List of Inventory Items on
>> another worksheet of excel.
>>
>> May someone help me with a macro or advance formula which computes Ageing
>> of Inventory.
>>
>> Age of Inventory is calculated in Purchase Sheet but do not know how to
>> compute for available qty only.
>>
>> Sample Sheet attached.
>>
>>
>>  --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 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) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>  --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 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) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


Ageing Inventory_Kumar.xlsx
Description: MS-Excel 2007 spreadsheet

$$Excel-Macros$$ Cash Flow Dashboard

[C.G.Kumar]

Hi,

I would appreciate if anyone can help me with Cash Flow Dashboard.

Many Thanks,

C.G.Kumar

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Macro for Ageing of Inventory

[C.G.Kumar]

Hi,

I have purchase data in a spreadsheet and List of Inventory Items on
another worksheet of excel.

May someone help me with a macro or advance formula which computes Ageing
of Inventory.

Age of Inventory is calculated in Purchase Sheet but do not know how to
compute for available qty only.

Sample Sheet attached.

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


Ageing Inventory.xlsx
Description: MS-Excel 2007 spreadsheet

Re: $$Excel-Macros$$X Copy sand paste dynamic data range

[C.G.Kumar]

Thanks for response.

All solution provided is considering outlook as default mail client. But my
need is diiferent innfollwing way;


1. IBM lotus is my default email.

2. Need to paste filtered data (8 column and many row) as part of email.
This will be in addition of body of the message.

In above scenario, solution never br advised.

Will appreciate if you can suggest.

On Sunday, August 17, 2014, Vaibhav Joshi  wrote:

> Hi
>
> Browse thru forum, solution to mass mailer is available, you can use that
> template.
>
> Cheers!!
>
>
> On Fri, Aug 15, 2014 at 1:20 AM, C.G.Kumar  > wrote:
>
>> Hi,
>>
>> Can añy one would suggest ;
>>
>> 1. How to copy data from specific worksheeet . data range is dynamic
>> meaning end row is varying but header row remain from m a1 to h1.
>>
>> 2. Paste data so copied in body of the email.
>>
>> Or copy data from excel , store it as image and then use some code to
>> pull this imageto be part of email.
>>
>>
>> Many thanks in advance;
>>
>>
>> C.G. Kumar
>>
>>
>>
>> -- Forwarded message --
>> From: *C.G.Kumar* > >
>> Date: Saturday, August 9, 2014
>> Subject: $$Excel-Macros$$ Include dynamic data range
>> To: "excel-macros@googlegroups.com
>> " <
>> excel-macros@googlegroups.com
>> >
>>
>>
>> Attached is sample excel file used to remind customer in India to pay.
>>
>> Excel expert help and support is expected on the below concern to modify
>> attached macro:
>>
>>
>> 1. Once "Send EMail" button in cell N1 is clicked, it capture details
>> well.
>>
>> But, before, mail is sent to customer , I need to go to sheet 2, filter
>> by same customer code (active cell in sheet 1 and column B) and then copy
>> entire rannge by selecting range, and paste data range at the bottom of
>> e-mail and adding Title " Outstanding Dues".
>>
>>
>> 2. How to add Cc and Bcc through macro. It is available in col K and L
>>  if available.
>>
>>
>> 3. The macro run for one customer at a time . Can it be modified to run
>> for range selected.
>>
>>
>> Thanks in advance.
>>
>>
>>
>>  --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 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) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/d/optout.
>>
>>  --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 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) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you ar

Fwd: $$Excel-Macros$$X Copy sand paste dynamic data range

[C.G.Kumar]

Hi,

Can añy one would suggest ;

1. How to copy data from specific worksheeet . data range is dynamic
meaning end row is varying but header row remain from m a1 to h1.

2. Paste data so copied in body of the email.

Or copy data from excel , store it as image and then use some code to pull
this imageto be part of email.


Many thanks in advance;


C.G. Kumar



-- Forwarded message --
From: *C.G.Kumar* 
Date: Saturday, August 9, 2014
Subject: $$Excel-Macros$$ Include dynamic data range
To: "excel-macros@googlegroups.com" 


Attached is sample excel file used to remind customer in India to pay.

Excel expert help and support is expected on the below concern to modify
attached macro:


1. Once "Send EMail" button in cell N1 is clicked, it capture details well.

But, before, mail is sent to customer , I need to go to sheet 2, filter by
same customer code (active cell in sheet 1 and column B) and then copy
entire rannge by selecting range, and paste data range at the bottom of
e-mail and adding Title " Outstanding Dues".


2. How to add Cc and Bcc through macro. It is available in col K and L  if
available.


3. The macro run for one customer at a time . Can it be modified to run for
range selected.


Thanks in advance.



 --
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups
"MS EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to excel-macros+unsubscr...@googlegroups.com

.
To post to this group, send email to excel-macros@googlegroups.com
.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


Sending Reminder.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12

$$Excel-Macros$$ Include dynamic data range

[C.G.Kumar]

Attached is sample excel file used to remind customer in India to pay.

Excel expert help and support is expected on the below concern to modify
attached macro:


1. Once "Send EMail" button in cell N1 is clicked, it capture details well.

But, before, mail is sent to customer , I need to go to sheet 2, filter by
same customer code (active cell in sheet 1 and column B) and then copy
entire rannge by selecting range, and paste data range at the bottom of
e-mail and adding Title " Outstanding Dues".


2. How to add Cc and Bcc through macro. It is available in col K and L  if
available.


3. The macro run for one customer at a time . Can it be modified to run for
range selected.


Thanks in advance.

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


Sending Reminder.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12

Re: $$Excel-Macros$$ Re: Filter Data based on Criteria

[C.G.Kumar]

Missed to attach sample file in trail mail.


On Thu, Apr 11, 2013 at 12:48 PM, C.G.Kumar wrote:

> Thanks for trying but still the solution is not useful to me.
>
> Let me explain correctly; Auto filter based on condition.
>
> Data is available in range (say A6:I6) and i need filter based on
> condition .Number of condition may vary from time to time but conditions
> need to be entered manually as required in condition row provided (A1:. For
> example,
>
> 1 If user enters in condition , 5000 (I2), data range shoud get
> automatically filter by amount >=5000.
>
> 2. If user put party Name "ada", data range should automatically filter by
> party name "*ada*"
>
> 3. If user puts two condition in condition row say name = ada & amount =
> 5000,, data range needs to be filtered for party with name consisting ada
> and amount >=5000 (both condition (from Left to right)).
>
>
> I am doing it manually now and believe that there must be some way to
> automate it through macro.
>
>
> Thanks in advance.
>
>
>
>
> On Thu, Apr 11, 2013 at 10:37 AM, Mukul Garg wrote:
>
>> Hi Mr. Kumar,
>>
>> Please find below code , hope it will be help to resolve your issue.
>>
>> Sub Auto_filter()
>> Dim sh As Worksheet
>> Dim customer As String
>> Dim invd As Date
>> Dim po As String
>> Dim amt As Long
>> Dim gmt As String
>> Set sh = ThisWorkbook.Sheets("Sheet1")
>> Application.ScreenUpdating = False
>>
>> customer = sh.Range("B2").Value
>> invd = sh.Range("C2").Value
>> po = sh.Range("F2").Value
>> amt = sh.Range("J2").Value
>> gmt = sh.Range("I2").Value
>> sh.Range("A5").AutoFilter Field:=Array(2, 3, 6, 9), Criteria1:=Array("*"
>> & customer & "*", invd, po, gmt & amt)
>> sh.Rows("6:6").Select
>> Selection.Copy
>> sh.Range("A14").PasteSpecial xlPasteAll
>> sh.Range("A5").AutoFilter
>> sh.Range("A1").Select
>> End Sub
>>
>>
>> On Wednesday, April 10, 2013 1:58:11 PM UTC+5:30, kumar wrote:
>>>
>>> Hi,
>>>
>>>
>>> I need to filter a long list in excel based on criteria (Cell Values). I
>>> can do it manually by selecting filter and then selecting manually each
>>> criteria like Name = Adag, Amount > 5000 and so on  .
>>>
>>>
>>> Is there any way where the list get auto filtered based on criteria
>>> mentioned at the top of the list or something alike.
>>>
>>>
>>> Attached sample workbook with Sample Data, output expected.
>>>
>>>
>>> Thanks for understanding.
>>>
>>> C.G.Kumar
>>>
>>  --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 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) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>> For more options, visit https://groups.google.com/groups/opt_out.
>>
>>
>>
>
>  --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 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 answe

$$Excel-Macros$$ Re: Filter Data based on Criteria

[C.G.Kumar]

Thanks for trying but still the solution is not useful to me.

Let me explain correctly; Auto filter based on condition.

Data is available in range (say A6:I6) and i need filter based on condition
.Number of condition may vary from time to time but conditions need to be
entered manually as required in condition row provided (A1:. For example,

1 If user enters in condition , 5000 (I2), data range shoud get
automatically filter by amount >=5000.

2. If user put party Name "ada", data range should automatically filter by
party name "*ada*"

3. If user puts two condition in condition row say name = ada & amount =
5000,, data range needs to be filtered for party with name consisting ada
and amount >=5000 (both condition (from Left to right)).


I am doing it manually now and believe that there must be some way to
automate it through macro.


Thanks in advance.




On Thu, Apr 11, 2013 at 10:37 AM, Mukul Garg wrote:

> Hi Mr. Kumar,
>
> Please find below code , hope it will be help to resolve your issue.
>
> Sub Auto_filter()
> Dim sh As Worksheet
> Dim customer As String
> Dim invd As Date
> Dim po As String
> Dim amt As Long
> Dim gmt As String
> Set sh = ThisWorkbook.Sheets("Sheet1")
> Application.ScreenUpdating = False
>
> customer = sh.Range("B2").Value
> invd = sh.Range("C2").Value
> po = sh.Range("F2").Value
> amt = sh.Range("J2").Value
> gmt = sh.Range("I2").Value
> sh.Range("A5").AutoFilter Field:=Array(2, 3, 6, 9), Criteria1:=Array("*" &
> customer & "*", invd, po, gmt & amt)
> sh.Rows("6:6").Select
> Selection.Copy
> sh.Range("A14").PasteSpecial xlPasteAll
> sh.Range("A5").AutoFilter
> sh.Range("A1").Select
> End Sub
>
>
> On Wednesday, April 10, 2013 1:58:11 PM UTC+5:30, kumar wrote:
>>
>> Hi,
>>
>>
>> I need to filter a long list in excel based on criteria (Cell Values). I
>> can do it manually by selecting filter and then selecting manually each
>> criteria like Name = Adag, Amount > 5000 and so on  .
>>
>>
>> Is there any way where the list get auto filtered based on criteria
>> mentioned at the top of the list or something alike.
>>
>>
>> Attached sample workbook with Sample Data, output expected.
>>
>>
>> Thanks for understanding.
>>
>> C.G.Kumar
>>
>  --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 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) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.

Re: $$Excel-Macros$$ Filter Data based on Criteria

[C.G.Kumar]

The macro provided does not serve the purpose. It does not filter data
based on condition provided in row 1:2.

The data needs to filtered on the same place and not on different location.
Output given in sample sheet was only for checking the results .

I hope you can modify the results .:)


On Wed, Apr 10, 2013 at 6:03 PM, xlstime  wrote:

> Hi CG,
>
> Please try to use Advance filter and macro recording.PFA
>
>
>
>
> .
>
> Enjoy
> Team XLS
>
>
>
> On Wed, Apr 10, 2013 at 1:58 PM, C.G.Kumar wrote:
>
>> Hi,
>>
>>
>> I need to filter a long list in excel based on criteria (Cell Values). I
>> can do it manually by selecting filter and then selecting manually each
>> criteria like Name = Adag, Amount > 5000 and so on  .
>>
>>
>> Is there any way where the list get auto filtered based on criteria
>> mentioned at the top of the list or something alike.
>>
>>
>> Attached sample workbook with Sample Data, output expected.
>>
>>
>> Thanks for understanding.
>>
>> C.G.Kumar
>>
>> --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 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) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>> For more options, visit https://groups.google.com/groups/opt_out.
>>
>>
>>
>
>  --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 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) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.

$$Excel-Macros$$ Filter Data based on Criteria

[C.G.Kumar]

Hi,


I need to filter a long list in excel based on criteria (Cell Values). I
can do it manually by selecting filter and then selecting manually each
criteria like Name = Adag, Amount > 5000 and so on  .


Is there any way where the list get auto filtered based on criteria
mentioned at the top of the list or something alike.


Attached sample workbook with Sample Data, output expected.


Thanks for understanding.

C.G.Kumar

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.




Custom Filter bases on cell values.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Macro for filter data & send it to respective user through mail

[C.G.Kumar]

Can we do the same thing using Lotus Notes


On Fri, Mar 15, 2013 at 10:58 AM, अनिल नारायण गवली
wrote:

> Dear Sagar,
>
> Enclosed herewith the required data.  Is it Ok ?  Tell me .
>
> Files are save in C:\Anil.
> note:- When file are saved in the required dir. then automatically one
> message box will be poped which says successfully transformed then
> automatically outlook format one sheet will be activated there you have to
> put the email id , sub,body,sign,and the attachments and then click on send
> button.
>
>
>
>
>
> Warm Regards,
>
>
>
> On Thu, Mar 14, 2013 at 4:43 PM, Sagar Aher  wrote:
>
>> Outlook
>> On Mar 14, 2013 3:37 PM, "अनिल नारायण गवली" 
>> wrote:
>>
>>> Dear Sagar,
>>>
>>> From which mail u want to send the file ? from gmail,yahoo, or from
>>> outlook???
>>>
>>>
>>> Warm Regards,
>>> Gawli Anil
>>>
>>>
>>>
>>> On Thu, Mar 14, 2013 at 3:29 PM, sagaraher  wrote:
>>>
 Hello,

 I am looking for Macro for filter data & send it to respective user
 through mail, pl find details below
 1) I have various dept like SCM / Mktg / Engg / HR etc & data attached
 to each dept, when we apply filter we can see data related to particular
 dept.
 2) I want to create separate excel file for each dept & send it to
 respective dept people

 Pl help me to design macro for the same

 --
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
 It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 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) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners
 and members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google
 Groups "MS EXCEL AND VBA MACROS" group.
 To unsubscribe from this group and stop receiving emails from it, send
 an email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros?hl=en.
 For more options, visit https://groups.google.com/groups/opt_out.



>>>
>>>
>>>
>>> --
>>> Thanks & Regards,
>>> Gawli Anil Narayan
>>> Software Developer,
>>> Abacus Software Services Pvt Ltd
>>
>>
>
>
> --
> Thanks & Regards,
> Gawli Anil Narayan
> Software Developer,
> Abacus Software Services Pvt Ltd
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 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) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in 

Re: $$Excel-Macros$$ Extracting Text from Cell

[C.G.Kumar]

Thanks Anoop for helping & supporting me.

Regards,

C.G.Kumar


On Fri, Dec 7, 2012 at 9:40 AM, Anoop K Sharma wrote:

> Use the Ashish's formula for second case.
>
> Regards,
> Anoop
>
>
>
> On Thu, Dec 6, 2012 at 8:01 PM, ashish koul  wrote:
>
>> try this
>>
>> =RIGHT(G4,LEN(G4)-FIND("~",SUBSTITUTE(G4,"
>> ","~",LEN(G4)-LEN(SUBSTITUTE(G4," ","")
>>
>>
>>
>>
>> On Thu, Dec 6, 2012 at 4:07 PM, C.G.Kumar wrote:
>>
>>> Dear Anoop,
>>>
>>> Thanks.
>>>
>>> But the formula in sector gives errorenous result when the last text are
>>> like  "HYD/DXB/AMS/DXB/HYD"
>>>
>>>
>>> Sample attached.
>>>
>>> Can you advise.
>>>
>>>
>>>
>>>
>>>
>>> On Thu, Dec 6, 2012 at 2:16 PM, Anoop K Sharma 
>>> wrote:
>>>
>>>> Hi CG,
>>>>
>>>> PFA.
>>>>
>>>> Regards,
>>>> Anoop
>>>>
>>>>
>>>> On Thu, Dec 6, 2012 at 12:59 PM, C.G.Kumar 
>>>> wrote:
>>>>
>>>>>
>>>>> Hi ,
>>>>>
>>>>>
>>>>> I need to extract a relevant portion from Excel cell.
>>>>>
>>>>> Attached example file.
>>>>>
>>>>>
>>>>> Many Regards,
>>>>>
>>>>> C.G.Kumar
>>>>>
>>>>> --
>>>>> Join official Facebook page of this forum @
>>>>> https://www.facebook.com/discussexcel
>>>>>
>>>>> FORUM RULES
>>>>>
>>>>> 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) Jobs posting is not allowed.
>>>>> 6) Sharing copyrighted material and their links is not allowed.
>>>>>
>>>>> NOTE : Don't ever post confidential data in a workbook. Forum owners
>>>>> and members are not responsible for any loss.
>>>>> ---
>>>>> You received this message because you are subscribed to the Google
>>>>> Groups "MS EXCEL AND VBA MACROS" group.
>>>>> To post to this group, send email to excel-macros@googlegroups.com.
>>>>> To unsubscribe from this group, send email to
>>>>> excel-macros+unsubscr...@googlegroups.com.
>>>>> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>>
>>>> --
>>>> Regards,
>>>> Anoop
>>>> Sr. Developer
>>>>
>>>>  --
>>>> Join official Facebook page of this forum @
>>>> https://www.facebook.com/discussexcel
>>>>
>>>> FORUM RULES
>>>>
>>>> 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) Jobs posting is not allowed.
>>>> 6) Sharing copyrighted material and their links is not allowed.
>>>>
>>>> NOTE : Don't ever post confidential data in a workbook. Forum owners
>>>> and members are not responsible for any loss.
>>>> ---
>>>> You received this message because you are subscribed to the Google
>>>> Groups "MS EXCEL AND VBA MACROS" group.
>>>> To post to this group, send email to excel-macros@googlegroups.com.
>>>> To unsubscribe from this group, send email to
>>>> excel-macros+unsubscr...@googlegroups.com.
>>>> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>>&

Re: $$Excel-Macros$$ Extracting Text from Cell

[C.G.Kumar]

It worked.

Thanks a lot.


On Thu, Dec 6, 2012 at 8:01 PM, ashish koul  wrote:

> try this
>
> =RIGHT(G4,LEN(G4)-FIND("~",SUBSTITUTE(G4,"
> ","~",LEN(G4)-LEN(SUBSTITUTE(G4," ","")
>
>
>
>
> On Thu, Dec 6, 2012 at 4:07 PM, C.G.Kumar wrote:
>
>> Dear Anoop,
>>
>> Thanks.
>>
>> But the formula in sector gives errorenous result when the last text are
>> like  "HYD/DXB/AMS/DXB/HYD"
>>
>>
>> Sample attached.
>>
>> Can you advise.
>>
>>
>>
>>
>>
>> On Thu, Dec 6, 2012 at 2:16 PM, Anoop K Sharma wrote:
>>
>>> Hi CG,
>>>
>>> PFA.
>>>
>>> Regards,
>>> Anoop
>>>
>>>
>>> On Thu, Dec 6, 2012 at 12:59 PM, C.G.Kumar 
>>> wrote:
>>>
>>>>
>>>> Hi ,
>>>>
>>>>
>>>> I need to extract a relevant portion from Excel cell.
>>>>
>>>> Attached example file.
>>>>
>>>>
>>>> Many Regards,
>>>>
>>>> C.G.Kumar
>>>>
>>>> --
>>>> Join official Facebook page of this forum @
>>>> https://www.facebook.com/discussexcel
>>>>
>>>> FORUM RULES
>>>>
>>>> 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) Jobs posting is not allowed.
>>>> 6) Sharing copyrighted material and their links is not allowed.
>>>>
>>>> NOTE : Don't ever post confidential data in a workbook. Forum owners
>>>> and members are not responsible for any loss.
>>>> ---
>>>> You received this message because you are subscribed to the Google
>>>> Groups "MS EXCEL AND VBA MACROS" group.
>>>> To post to this group, send email to excel-macros@googlegroups.com.
>>>> To unsubscribe from this group, send email to
>>>> excel-macros+unsubscr...@googlegroups.com.
>>>> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>>>>
>>>>
>>>>
>>>
>>>
>>>
>>> --
>>> Regards,
>>> Anoop
>>> Sr. Developer
>>>
>>>  --
>>> Join official Facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES
>>>
>>> 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) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>>> members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To post to this group, send email to excel-macros@googlegroups.com.
>>> To unsubscribe from this group, send email to
>>> excel-macros+unsubscr...@googlegroups.com.
>>> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>>>
>>>
>>>
>>
>>  --
>> Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 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) Job

Re: $$Excel-Macros$$ Extracting Text from Cell

[C.G.Kumar]

Dear Anoop,

Thanks.

But the formula in sector gives errorenous result when the last text are
like  "HYD/DXB/AMS/DXB/HYD"


Sample attached.

Can you advise.





On Thu, Dec 6, 2012 at 2:16 PM, Anoop K Sharma wrote:

> Hi CG,
>
> PFA.
>
> Regards,
> Anoop
>
>
> On Thu, Dec 6, 2012 at 12:59 PM, C.G.Kumar wrote:
>
>>
>> Hi ,
>>
>>
>> I need to extract a relevant portion from Excel cell.
>>
>> Attached example file.
>>
>>
>> Many Regards,
>>
>> C.G.Kumar
>>
>> --
>> Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 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) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> To unsubscribe from this group, send email to
>> excel-macros+unsubscr...@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>>
>>
>>
>
>
>
> --
> Regards,
> Anoop
> Sr. Developer
>
>  --
> Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 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) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>
>
>

-- 
Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.




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

$$Excel-Macros$$ Extracting Text from Cell

[C.G.Kumar]

Hi ,


I need to extract a relevant portion from Excel cell.

Attached example file.


Many Regards,

C.G.Kumar

-- 
Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.




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

$$Excel-Macros$$ Macro to mail using Excel worsheet

[C.G.Kumar]

May i ask to help me in the following scenario;


1.  I have excel work sheet which enlist customer having outstanding dues .
I need to send e mail to these customer on this list twice a day daily .

Attached excel have sample of  records.

Is it possible to do it through macro . That is to Send mail if column I is
"No", to mail recipient (column Q) with mail subject (col M) with mail
message (col N)

If you want any input on the sheet or have any query, please let me know.

Regards,

Kumar

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ 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. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.




Customer follow up.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Basic Macro *: Mail fromExcel Sheet data

[C.G.Kumar]

Thanks  Noorain.

It is very informative and useful. I am trying to learn macro from this.

May i as k to help me in the following scenarion;


1.  I have excel work sheet which enlist customer having outstanding dues .
I need to send e mail to these customer on this list twice a day daily .

Attached excel having all reords.


Is it possible to do it through macro.

If you want any input on the sheet or have any query, please let me know.



On Fri, Sep 28, 2012 at 11:01 AM, NOORAIN ANSARI
wrote:

> Hi Manju,
>
> Please see attached Study material, hope it will help to you.
>
> On Thu, Sep 27, 2012 at 9:01 PM, Manjunath Narayanappa <
> manjunath.narayana...@aon.co.uk> wrote:
>
>>
>>
>>  Dear Experts,
>>
>>
>>
>> I'm keen to learn basic Macro, please send me training guide or manual
>>
>>
>>
>> Thanks
>>
>> Manjunath
>>
>>
>>  --
>>
>>
>> PLEASE CONSIDER THE ENVIRONMENT BEFORE PRINTING THIS E-MAIL
>>
>>
>>
>> For Aon’s standard conditions associated with this e-mail please visit
>> http://www.aon.com/uk/en/email-footer/aon-uk-limited.jsp
>>
>> Aon UK Limited
>>
>> Registered Office: 8 Devonshire Square, London EC2M 4PL
>>
>> Registered in London No. 210725 . VAT Registration No. 480 8401 48
>>
>>
>>
>> Aon UK Limited is authorised and regulated by the Financial Services
>> Authority in respect of insurance mediation activities only.
>>
>> --
>> Join official facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES (1120+ 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.
>>
>> 6) Jobs posting is not allowed.
>>
>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> To unsubscribe from this group, send email to
>> excel-macros+unsubscr...@googlegroups.com.
>>
>>
>>
>> --
>>
>> PLEASE CONSIDER THE ENVIRONMENT BEFORE PRINTING THIS E-MAIL
>>
>>
>>
>> For Aon’s standard conditions associated with this e-mail please visit
>> http://www.aon.com/uk/en/email-footer/aon-uk-limited.jsp
>>
>> Aon UK Limited
>>
>> Registered Office: 8 Devonshire Square, London EC2M 4PL
>>
>> Registered in London No. 210725 . VAT Registration No. 480 8401 48
>>
>>
>>
>> Aon UK Limited is authorised and regulated by the Financial Services
>> Authority in respect of insurance mediation activities only.
>>
>> --
>> Join official facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES (1120+ 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.
>>
>> 6) Jobs posting is not allowed.
>>
>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> To unsubscribe from this group, send email to
>> excel-macros+unsubscr...@googlegroups.com.
>>
>>
>>
>>
>
>
> --
> With Regards,
> Noorain Ansari
> http:// 
> noorainansari.com
> http:// 
> excelvbaclinic.com
>
>
>  --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ 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 

Re: $$Excel-Macros$$ 10 Ways to Use Magical INDIRECT Function

[C.G.Kumar]

Sir,


Could you plz explain how did you got the pic in worksheet 3 from worksheet
4 as the function yields to 0 when pasted in other area.

Regards,


C.G.Kumar

On Mon, Nov 14, 2011 at 11:58 PM, NOORAIN ANSARI
wrote:

> Dear Group,
>
> Please find attached Sheet to use 10 Simple way to use Indirect Function
> example..
>
> if any one have more examples Kindly share with group.
>
> The Excel INDIRECT function takes a text string and converts this into a
> cell reference.
>
> Excel does not understand the text string "B1" to mean a reference to the
> cell B1. Therefore, if you extract or build up a reference to a cell or
> range using text, you will need to use the INDIRECT function to convert
> this into a reference that Excel can understand.
>
> The format of the function is :
> INDIRECT( *Ref_text*, *A1* )
>
> Where the arguments are as follows :
>   *Ref_text* - The text describing the reference  *A1* - An optional
> logical argument that defines the style of the *Ref_text* reference.
> This can be either :
>
>- True - to denote that the reference is in A1 style
>- False - to denote that the reference is in R1C1 style
>
> If this argument is omitted, it takes on the default value "True"
>
> --
> 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

Re: $$Excel-Macros$$ Conditional Lookup or data validation

[C.G.Kumar]

Thanks Daniel.

It really works.


Regards,

C.G.Kumar

On Sat, Aug 27, 2011 at 3:26 PM, Daniel  wrote:

> Hello,
>
> ** **
>
> See attached workbook.
>
> ** **
>
> Daniel
>
> ** **
>
> *De :* excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
> *De la part de* C.G.Kumar
> *Envoyé :* vendredi 26 août 2011 06:14
> *À :* excel-macros@googlegroups.com
> *Objet :* $$Excel-Macros$$ Conditional Lookup or data validation
>
> ** **
>
>
>
>
> Dear All,
>
> ** **
>
> PFA sample file for your kind consideration.****
>
> ** **
>
> ** **
>
> ** **
>
> Regards,
>
> ** **
>
> ** **
>
> C.G.Kumar
>
> ** **
>
> --
>
> --
> 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
>

-- 
--
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$$ Conditional Lookup or data validation

[C.G.Kumar]

Dear All,

PFA sample file for your kind consideration.



Regards,


C.G.Kumar

-- 
--
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


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

$$Excel-Macros$$ Conditional data validation

[C.G.Kumar]

Dear All,

PFA sample file for your kind consideration.



Regards,


AMW-2

-- 
--
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


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

Re: $$Excel-Macros$$ Re: delete workbook if password is not entered

[C.G.Kumar]

Hi Sam,

The reader has sought for code to delete file if Password doesn't matches in
three attempts. You have provided code to delete file without prompting for
password match by oversight.


Hope you will be amend the same.



Regards,

C.G.Kumar

On Thu, May 5, 2011 at 1:58 AM, GoldenLance  wrote:

>With ThisWorkbook
>.ChangeFileAccess xlReadOnly
>Kill .FullName
>.Close 0
>End With
>
> On May 4, 5:35 am, Bob  wrote:
> > Can someone help with the code to delete a workbook if password is not
> > entered within 3 tries. Thanks so much!
>
> --
>
> --
> 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

Re: $$Excel-Macros$$ Outlook 2007 Calendar Meeting Setup to Excel 2007

[C.G.Kumar]

You are correct. But i don't think Import/Export to file of entire
"Description" of the meeting into excel will be much useful as it is limited
to the extent of 255 Characters only and hence data export will be of
limited use.




Is there a way out? If yes, pls share with the group.


Regards,


C.G.Kumar

Is there a way out.

On Tue, May 3, 2011 at 2:24 AM, ChilExcel  wrote:

> see this link , that's what you need
>
>
> http://office.microsoft.com/en-us/outlook-help/export-calendar-data-to-excel-HP001087241.aspx
>
>
> Chilexcel
>
>
>
>
> 2011/4/27 Susan 1 
>
>> Hi,
>> Does anyone know if it is possible to import or export an Outlook calendar
>> template into Excel 2007.
>>
>> See attached of the page I'd like to be able to either iimport into Excel
>> from Excel, or export out of Outlook into Excel.  Or can I somehow save an
>> extension .ics as .xls or .xlsx?
>>
>> Thanks,
>>
>> ~Sunnie
>>
>> --
>>
>> --
>> 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
>>
>
>
>
> --
> Visita ; http://sites.google.com/site/chilexcel/Home
> Visita ; http://www.youtube.com/user/timextag41
>
>  --
>
> --
> 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

Re: $$Excel-Macros$$ SEARCH FUNCTION

[C.G.Kumar]

No file found.


On Mon, Apr 18, 2011 at 7:31 PM, Daniel  wrote:

> Hi,
>
> Please, attach file ;-)
>
> Daniel
>
>
>
> *De :* excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
> *De la part de* C.G.Kumar
> *Envoyé :* lundi 18 avril 2011 10:15
> *À :* excel-macros@googlegroups.com
> *Objet :* $$Excel-Macros$$ SEARCH FUNCTION
>
>
>
> Dear All,
>
>
>
>
>
> I intend to generate list based on search of Text String.Sample file
> attached.
>
>
>
> Regards,
>
>
>
> C.G.Kumar
>
> --
>
> --
> 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
>

-- 
--
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$$ Re: Search Formula

[C.G.Kumar]

Thnaks Ashish.

It is very useful but i am not getting desired output when i copy VBA code
to my actual workbook.Please suggest Where i have to make change.

Regards,

C.G.Kumar



On Mon, Apr 18, 2011 at 6:18 PM, ashish koul  wrote:

> try this see if it helps
>
> On Mon, Apr 18, 2011 at 2:21 PM, C.G.Kumar wrote:
>
>> Hello,
>> I have a very tricky problem. I have got an excel sheet having some
>> columns but more than 5000 rows. In those columns there are some names which
>> may/may not be similar to each other. I want to make a macro which can:
>> 1. Search for the name. e.g. If I have Katie Holmes in 1st row, Sherlock
>> Holmes in 2nd row, Holmes Matt in 3rd row, James Holmes Dammon in 4th row
>> and so onthen if put only Holmes in search criteria then it should get
>> the result for all the 4 rows.
>> 2. Secondly it should display only those 4 rows in the result. Like if we
>> are using a sort function.
>>
>>
>> Regards,
>>
>> C.G.Kumar
>>
>
>
>
> --
> *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

Re: $$Excel-Macros$$ Fwd: SEARCH FUNCTION

[C.G.Kumar]

Thanks .


I have modified the formula to suit my requirement as follows;

SMALL(IF(ISNUMBER(SEARCH((Report!B1),C2:C28,1)),ROW(1:28),ROW(1:28))


Thanks buddy for giving me the direction.


Regards,

C.G.Kumar

On Mon, Apr 18, 2011 at 3:33 PM, STDEV(i)  wrote:

> plese check the attached workbook, and see if it helps.
>
>
> *ARRAY FORMULA*
> =small(if(left(C2:C29,len(F4))=F4,row(1:28)),row(1:28))
>
> FORMULA
> =IF(ISERR($D6),"",OFFSET(A$1,$D6,0))
>
>
>
>
> On Mon, Apr 18, 2011 at 3:16 PM, C.G.Kumar wrote:
>
>> PFA sample File.
>>
>> -- Forwarded message --
>> From: C.G.Kumar 
>> Date: Mon, Apr 18, 2011 at 1:45 PM
>> Subject: SEARCH FUNCTION
>> To: excel-macros@googlegroups.com
>>
>>
>> Dear All,
>>
>> I intend to generate list based on search of Text String.Sample file
>> attached.
>> Regards,
>> C.G.Kumar
>>
>
>  --
>
> --
> 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

Re: $$Excel-Macros$$ Search Formula

[C.G.Kumar]

Thanks Ranjan but I could not use file filter because;

1.Data is required at different place.
2.Filter is not effective when i have to use it more than 50 times in a day.
3.Data captured on the basis of the criteria is further required for
calculation purpose.


Therefore, i intend to use *formula only & not macro.*


Regards,

C.G.Kumar

On Mon, Apr 18, 2011 at 2:43 PM, rajan verma wrote:

> you should apply contain Filter.. i think
>
>
> On Mon, Apr 18, 2011 at 2:21 PM, C.G.Kumar wrote:
>
>> Hello,
>> I have a very tricky problem. I have got an excel sheet having some
>> columns but more than 5000 rows. In those columns there are some names which
>> may/may not be similar to each other. I want to make a macro which can:
>> 1. Search for the name. e.g. If I have Katie Holmes in 1st row, Sherlock
>> Holmes in 2nd row, Holmes Matt in 3rd row, James Holmes Dammon in 4th row
>> and so onthen if put only Holmes in search criteria then it should get
>> the result for all the 4 rows.
>> 2. Secondly it should display only those 4 rows in the result. Like if we
>> are using a sort function.
>>
>>
>> Regards,
>>
>> C.G.Kumar
>>
>> --
>>
>> --
>> 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
> Rajan verma
> +91 9158998701
>
> --
>
> --
> 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$$ Search Formula

[C.G.Kumar]

Hello,
I have a very tricky problem. I have got an excel sheet having some columns
but more than 5000 rows. In those columns there are some names which may/may
not be similar to each other. I want to make a macro which can:
1. Search for the name. e.g. If I have Katie Holmes in 1st row, Sherlock
Holmes in 2nd row, Holmes Matt in 3rd row, James Holmes Dammon in 4th row
and so onthen if put only Holmes in search criteria then it should get
the result for all the 4 rows.
2. Secondly it should display only those 4 rows in the result. Like if we
are using a sort function.


Regards,

C.G.Kumar

-- 
--
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$$ SEARCH FUNCTION

[C.G.Kumar]

Dear All,


I intend to generate list based on search of Text String.Sample file
attached.

Regards,

C.G.Kumar

-- 
--
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: SEARCH FUNCTION

[C.G.Kumar]

PFA sample File.

-- Forwarded message --
From: C.G.Kumar 
Date: Mon, Apr 18, 2011 at 1:45 PM
Subject: SEARCH FUNCTION
To: excel-macros@googlegroups.com


Dear All,


I intend to generate list based on search of Text String.Sample file
attached.

Regards,

C.G.Kumar

-- 
--
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


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

$$Excel-Macros$$ Hyperlink embedded object in excel

[C.G.Kumar]

Sir,


I have 12 picture embedded in Sheet 1 and i intend to create a hyper link in
Sheet 2 for each picture. Is it possible to do without Macro run.
Referencing to nearby cell is not worthy.

Regards,

C.G.Kumar

-- 
--
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$$ MACRO :PASTE SPECIAL

[C.G.Kumar]

Hi All,

Yes. Thank you all for the generosity displayed for me . This is working
now. But, the macro causes loss of formating i.e. Column & row width . Is it
possible to avoid this.


Thanks in Advance.


Regards,

C.G.Kumar

AMW-2

On Wed, Apr 13, 2011 at 1:39 AM, hanumant shinde wrote:

> I think its done. please check and let us know if this is what you wanted
> to do.
>
>
> *From:* C.G.Kumar 
> *To:* excel-macros@googlegroups.com
> *Cc:* schreiner_p...@att.net
> *Sent:* Mon, 11 April, 2011 8:52:17 PM
> *Subject:* Re: $$Excel-Macros$$ MACRO :PASTE SPECIAL
>
> Thanks Paul.
>
> I have amended macro.Pls find attached file with Macro named Paul() .But
> still the function is not working.
>
> Objective is to
>
> 1. Copy each sheet and paste values retaining format in the same sheet
> except Sheet M10701403 in the workbook.
>
>
> Hope u suggest me way out.
>
>
> Regards,
>
> C.G.Kumar
>
>
>
>
> On Mon, Apr 11, 2011 at 6:28 PM, Paul Schreiner wrote:
>
>> I was going to ask what it was doing, or not doingif you stepped through
>> the code.
>>
>> But I think I see your main problem.
>>
>> the statemtent:
>> Select Case "M10701403"
>>
>> means nothing..
>> you're not COMPARING anything!
>>
>> I think what you're wanting is:
>>
>> Select case ws.Name
>>Case "M10701403"
>>'Do Nothing
>>Case Else
>> Cells.Select
>> Selection.Copy
>> Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
>> SkipBlanks _
>> :=False, Transpose:=False
>> Application.CutCopyMode = False
>> End Select
>>
>> Next:
>>
>> ws.UsedRange.Copy
>> should copy the cells that are "used" to the Excel clipboard.
>>
>> Cells.Select
>> Selection.Copy
>> Immeately replaces the clipboard with ALL cells in the worksheet.
>>
>> You should use one or the other... using both is a waste of resources.
>>
>> hope this helps,
>>
>> Paul
>>
>>  --
>> *From:* C.G.Kumar 
>> *To:* excel-macros@googlegroups.com
>> *Sent:* Mon, April 11, 2011 5:47:04 AM
>> *Subject:* $$Excel-Macros$$ MACRO :PASTE SPECIAL
>>
>> Dear all,
>>
>> Following code i am using to select each worksheet (except ) to copy and
>> paste special values in each worksheet in same workbook. But, i am not
>> getting desired output .
>>
>> Could you one help to rectify the following code;
>>
>>
>> Sub ConvertToValues()
>> Dim ws As Worksheet
>> For Each ws In Worksheets
>>  Select Case "M10701403" ' EXCLUDED Sheet M107014031 To DO NOTHING
>>
>> Case Else
>> ws.UsedRange.Copy
>> Cells.Select
>> Selection.Copy
>> Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
>> SkipBlanks _
>> :=False, Transpose:=False
>> Application.CutCopyMode = False
>> End Select
>> Next ws
>> Application.CutCopyMode = False
>> End Sub
>>
>>
>> --
>>
>> --
>> 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
>>
>

$$Excel-Macros$$ MACRO :PASTE SPECIAL

[C.G.Kumar]

Dear all,

Following code i am using to select each worksheet (except ) to copy and
paste special values in each worksheet in same workbook. But, i am not
getting desired output .

Could you one help to rectify the following code;


Sub ConvertToValues()
Dim ws As Worksheet
For Each ws In Worksheets
Select Case "M10701403" ' EXCLUDED Sheet M107014031 To DO NOTHING

Case Else
ws.UsedRange.Copy
Cells.Select
Selection.Copy
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Application.CutCopyMode = False
End Select
Next ws
Application.CutCopyMode = False
End Sub

-- 
--
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$$ Copy Each Worksheet in a workbook and save it to Specific Location with time.

[C.G.Kumar]

Sir,


Thanks for the codes. But it lacks two things;

1. Objective is to create Worksheet with Value,Format & JPEG image attached
in the source worksheet but the Macro copies the worksheet along with
formula and excludes JPEG image .

2. If possible is it possible to ask from user to specify which worksheet he
intend to copy.


Thanks & Regards,

C.G.Kumar





On Mon, Apr 11, 2011 at 6:22 AM, ashish koul  wrote:

> see if it helps
>
> change
>
> pathbk = "C:\Documents and Settings\achamanlalko\Desktop\eforms\eform
> reports\test workbook\" to the destination folder
>
>
>
> Sub createworkbooks()
> Dim i As Long
> Dim a As Workbook
> Dim z As String
> Dim pathbk As String
>
> pathbk = "C:\Documents and Settings\achamanlalko\Desktop\eforms\eform
> reports\test workbook\"
> For i = 1 To ThisWorkbook.Worksheets.Count
> z = ThisWorkbook.Worksheets(i).Name
> ThisWorkbook.Worksheets(i).Select
> ThisWorkbook.Worksheets(i).UsedRange.Copy
> Set a = Workbooks.Add
> a.Sheets(1).Activate
> ActiveSheet.Paste
> a.SaveAs pathbk & z & Application.WorksheetFunction.Text(Now(), "hhmm") &
> ".xls"
> a.Close
>
> ThisWorkbook.Activate
>
> Next i
> End Sub
>
>
>
>
>
> On Sun, Apr 10, 2011 at 3:44 PM, C.G.Kumar wrote:
>
>> Hi,
>>
>>
>> I want a macro to copy each worksheet in a Workbook in specific folder Say
>> "H:\31.03.2011_10.04.2011" with File name as name of the active worksheet &
>> time of generation. For Example: My Workbook contains 35 sheets named
>> (Brazil,India,US etc) and i ran the macro at say 04:00 then it should Save
>> 35 worksheets should be saved in specific folder
>> i.e. "H:\31.03.2011_10.04.2011"  named as Brazil 0400 Hrs,India 0400 Hrs &
>> So on.
>>
>> I surfed the internet and found the following code but i am not able to
>> manipulate to suit my requirement(furnished below). Hope the member of this
>> group could help me out.
>>
>> ---
>>  Sub MakeMultipleXLSfromWB()
>>   'Split worksheets in current workbook into
>>   ' many separate workbooks  D.McRitchie, 2004-06-12
>>   'Close each module  AND the VBE before running to save time
>>   ' provides a means of seeing how big sheets really are
>>   'Hyperlinks and formulas pointing to other worksheets within
>>   ' the original workbook will usually be unuseable in the new workbooks.
>> Dim CurWkbook As Workbook
>> Dim wkSheet As Worksheet
>> Dim newWkbook As Workbook
>> Dim wkSheetName As String
>> Dim shtcnt(3) As Long
>> Dim xpathname As String, dtimestamp As String
>> dtimestamp = Format(Now, "mmdd_hhmmss")
>> xpathname = "H:\31.03.2011_10.04.2011" & dtimestamp & "\"
>> MkDir xpathname
>> Set CurWkbook = Application.ActiveWorkbook
>>
>> shtcnt(2) = ActiveWorkbook.Sheets.Count
>> Application.ScreenUpdating = False
>> Application.Calculation = xlCalculationManual
>> For Each wkSheet In CurWkbook.Worksheets
>>   shtcnt(1) = shtcnt(1) + 1
>>   Application.StatusBar = shtcnt(1) & "/" & shtcnt(2) & _
>>   "  " & wkSheet.Name
>>   wkSheetName = Trim(wkSheet.Name)
>>   If wkSheetName = 
>> Left(Application.ActiveWorkbook.Name<http://application.activeworkbook.name/>,
>> _
>>  
>> Len(Application.ActiveWorkbook.Name<http://application.activeworkbook.name/>)
>> - 4) Then _
>>  wkSheetName = wkSheetName & "_D" & dtimestamp
>>   Workbooks.Add
>>   ActiveWorkbook.SaveAs _
>>  Filename:=xpathname & wkSheetName & ".xls", _
>>  FileFormat:=xlNormal, Password:="", _
>>  WriteResPassword:="", CreateBackup:=False, _
>>  ReadOnlyRecommended:=False
>>   Set newWkbook = ActiveWorkbook
>>
>>   Application.DisplayAlerts = False
>>   newWkbook.Worksheets("sheet1").Delete
>>   On Error Resume Next
>>   newWkbook.Worksheets(wkSheet.Name).Delete
>>   On Error GoTo 0
>>   Application.DisplayAlerts = True
>>
>>   CurWkbook.Worksheets(wkSheet.Name).Copy Before:=newWkbook.Sheets(1)
>>   'no duplicate sheet1 because they begin with "a"
>>  

$$Excel-Macros$$ Copy Each Worksheet in a workbook and save it to Specific Location with time.

[C.G.Kumar]

Hi,


I want a macro to copy each worksheet in a Workbook in specific folder Say
"H:\31.03.2011_10.04.2011" with File name as name of the active worksheet &
time of generation. For Example: My Workbook contains 35 sheets named
(Brazil,India,US etc) and i ran the macro at say 04:00 then it should Save
35 worksheets should be saved in specific folder
i.e. "H:\31.03.2011_10.04.2011"  named as Brazil 0400 Hrs,India 0400 Hrs &
So on.

I surfed the internet and found the following code but i am not able to
manipulate to suit my requirement(furnished below). Hope the member of this
group could help me out.
---
Sub MakeMultipleXLSfromWB()
  'Split worksheets in current workbook into
  ' many separate workbooks  D.McRitchie, 2004-06-12
  'Close each module  AND the VBE before running to save time
  ' provides a means of seeing how big sheets really are
  'Hyperlinks and formulas pointing to other worksheets within
  ' the original workbook will usually be unuseable in the new workbooks.
Dim CurWkbook As Workbook
Dim wkSheet As Worksheet
Dim newWkbook As Workbook
Dim wkSheetName As String
Dim shtcnt(3) As Long
Dim xpathname As String, dtimestamp As String
dtimestamp = Format(Now, "mmdd_hhmmss")
xpathname = "H:\31.03.2011_10.04.2011" & dtimestamp & "\"
MkDir xpathname
Set CurWkbook = Application.ActiveWorkbook

shtcnt(2) = ActiveWorkbook.Sheets.Count
Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual
For Each wkSheet In CurWkbook.Worksheets
  shtcnt(1) = shtcnt(1) + 1
  Application.StatusBar = shtcnt(1) & "/" & shtcnt(2) & _
  "  " & wkSheet.Name
  wkSheetName = Trim(wkSheet.Name)
  If wkSheetName = Left(Application.ActiveWorkbook.Name, _
 Len(Application.ActiveWorkbook.Name) - 4) Then _
 wkSheetName = wkSheetName & "_D" & dtimestamp
  Workbooks.Add
  ActiveWorkbook.SaveAs _
 Filename:=xpathname & wkSheetName & ".xls", _
 FileFormat:=xlNormal, Password:="", _
 WriteResPassword:="", CreateBackup:=False, _
 ReadOnlyRecommended:=False
  Set newWkbook = ActiveWorkbook

  Application.DisplayAlerts = False
  newWkbook.Worksheets("sheet1").Delete
  On Error Resume Next
  newWkbook.Worksheets(wkSheet.Name).Delete
  On Error GoTo 0
  Application.DisplayAlerts = True

  CurWkbook.Worksheets(wkSheet.Name).Copy Before:=newWkbook.Sheets(1)
  'no duplicate sheet1 because they begin with "a"
  ActiveWorkbook.Save
  ActiveWorkbook.Close
Next wkSheet
Application.StatusBar = False  'return control to Excel
Application.Calculation = xlCalculationAutomatic
Application.ScreenUpdating = True
End Sub

---

Regards,

C.G.Kumar

-- 
--
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: Data Chart

[C.G.Kumar]

HI ALL,


I want to draw a chart based on the data attached.Objective is to depict the
implication of Coal Cost on & Other than Coal Cost (Store Cost Water Cost
etc) in Total Cost prominently.

When i select Bar Graph/ other graph, only Coal Cost part is prominent from
distance. Could any one suggest me any alternative manner.

Regards,

C.G.Kumar

-- 
--
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


Book1.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Data Chart

[C.G.Kumar]

HI ALL,


I want to draw a chart based on the data attached.Objective is to depict the
implication of Coal Cost on & Other than Coal Cost (Store Cost Water Cost
etc) in Total Cost prominently.

When i select Bar Graph/ other graph, only Coal Cost part is prominent from
distance. Could any one suggest me any alternative manner.

Regards,

C.G.Kumar

-- 
--
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


Book1.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Re: Can We creat Auto Mailer In Excel.

[C.G.Kumar]

Its awesome.Hats off to Ashish.
Regards,
C.G.Kumar

On Thu, Apr 7, 2011 at 10:35 AM, ashish koul  wrote:

> try this
>
> On Thu, Apr 7, 2011 at 9:10 AM, Harkesh Kumar 
> wrote:
>
>> Hi Experts,
>>
>>
>> We required your help for creat auto mailer in excel. or any other way,
>>
>> I have to send 200 mails with different attachment. can we creat auto
>> mailer in excel thourgh macros.
>>
>> Please help me out.
>>
>> Thanx in Advance .
>>
>>
>> Regards
>> Harkesh
>>
>
>
>
> --
> *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

Re: $$Excel-Macros$$ Countif Problem

[C.G.Kumar]

Hi,

Pls find attached file & let me know if it serve the purpose.



Regards,


C.G.KUMAR


On Sun, Apr 3, 2011 at 1:39 PM, Suryaprasad wrote:

> Hi Team / Ayush,
>
> Need a formula about a countif criteria
>
> See the attachment and please do the need full
>
> Regards
> prasad
>
> --
>
> --
> 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


Example.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Select numbers date wise using a formula

[C.G.Kumar]

Sir,


Is it possible to select two criteria. In the given case Date and Room
number and then sort by date.


Regards,

C.G.Kumar

On Fri, Mar 25, 2011 at 8:55 PM, STDEV(i)  wrote:

> 1.
> formula HELPER
> ( creating list of RowIndex )
> array formula in multi cells
> =IF(ISNUMBER($A5),OFFSET(BILL!$D$1,$A5,0),"")
>
> 2
> lookup the table based on RowIndex
> individual formula in a cell
>
> =IF(ISNUMBER($A5),OFFSET(BILL!$D$1,$A5,0),"")
>
>
>
> On Fri, Mar 25, 2011 at 7:40 PM, Rajesh K R wrote:
>
>> Hi,
>> How can I select bill numbers of a particular date and show it in
>> ascending order using a formula.Kindly check the attachment .
>>
>> Regards
>> Rajesh Kainikkara
>>
>>  --
>
> --
> 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

Re: $$Excel-Macros$$ Re: Identify the room status by color code

[C.G.Kumar]

PFA file. Hope it serve the purpose.


Regards,


C.G.Kumar


On Sun, Mar 27, 2011 at 8:06 AM, STDEV(i)  wrote:

> oops,  the attachment
>
>
>
> On Sun, Mar 27, 2011 at 9:35 AM, STDEV(i) wrote:
>
>> please find attached
>> and see if it helps
>>
>> best regards
>> siti Vi
>>
>>
>> On Sat, Mar 26, 2011 at 9:15 PM, Rajesh K R 
>> wrote:
>>
>>> On 3/26/11, Rajesh K R  wrote:
>>> > Hi Experts
>>> >
>>> >  How to understand the room status, by color code.pls check the
>>> attachment.
>>> >
>>> > Regards
>>> >
>>> > Rajesh Kainikkara
>>> >
>>>
>>> --
>>>
>>> --
>>> 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
>

-- 
--
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


TEST(2) Solved by Kumar.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Unique records

[C.G.Kumar]

Thanks Divakar. Fantastic application of logic to get the output.

Regards,

C.G.Kumar


On Tue, Feb 8, 2011 at 8:14 PM, Divaker Pandey  wrote:

> hi,
>
> Please find this one
>
>
>
> On Tue, Feb 8, 2011 at 10:10 AM, C.G.Kumar wrote:
>
>> Thanks sir,
>>
>> It works.Could you please elaborate the steps in the formula, if possible.
>>
>> Regards,
>>
>> C.G.Kumar
>>
>>
>> On Mon, Feb 7, 2011 at 3:56 PM, Manoj kumar <
>> manoj.vishwakarma...@gmail.com> wrote:
>>
>>> Hi C.G,
>>>
>>> A little complex but hope this might help your needs...
>>>
>>>
>>> Regards,
>>> Manoj Kumar
>>>
>>>
>>> On Mon, Feb 7, 2011 at 2:42 PM, C.G.Kumar wrote:
>>>
>>>> Not getting required result as i have to filter by two criteria ;1.
>>>> staff no and 2. Basic. Same staff no may have different basic over period 
>>>> of
>>>> time. After selecting unique records also, the output so generated is same
>>>> is base records.
>>>>
>>>>
>>>> Further, unique records does not works as two person may have same basic
>>>> and therefore, filter criteria by unique records destroys the objective.
>>>> Objective is to generate file having records as to when basic has changed
>>>> for the concerned over the period of time.
>>>>
>>>>
>>>> Thanks & Regards,
>>>>
>>>> C.G.Kumar
>>>>
>>>>
>>>> On Mon, Feb 7, 2011 at 1:12 PM, ashish koul wrote:
>>>>
>>>>> use advance filter
>>>>>
>>>>> 1 select col a,b , c goto  data- > advance filter
>>>>>
>>>>> select unique records and  click on copy to another loaction and select
>>>>> the destination cell
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> On Mon, Feb 7, 2011 at 11:28 AM, C.G.Kumar >>>> > wrote:
>>>>>
>>>>>> Please find attached file where i intend to extract only unique
>>>>>> records in column C (Basic) provided column B ( Staff No.) remains same. 
>>>>>> In
>>>>>> other words, the objective is to extract "Basic"  of same person for
>>>>>> different periods.
>>>>>>
>>>>>> Sample data file attached.
>>>>>>
>>>>>>
>>>>>> Regards,
>>>>>>
>>>>>> C.G.Kumar
>>>>>>
>>>>>> --
>>>>>>
>>>>>> --
>>>>>> 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 :
>>>>> htt

Re: $$Excel-Macros$$ Unique records

[C.G.Kumar]

Thanks sir,

It works.Could you please elaborate the steps in the formula, if possible.

Regards,

C.G.Kumar


On Mon, Feb 7, 2011 at 3:56 PM, Manoj kumar
wrote:

> Hi C.G,
>
> A little complex but hope this might help your needs...
>
>
> Regards,
> Manoj Kumar
>
>
> On Mon, Feb 7, 2011 at 2:42 PM, C.G.Kumar wrote:
>
>> Not getting required result as i have to filter by two criteria ;1. staff
>> no and 2. Basic. Same staff no may have different basic over period of time.
>> After selecting unique records also, the output so generated is same is base
>> records.
>>
>>
>> Further, unique records does not works as two person may have same basic
>> and therefore, filter criteria by unique records destroys the objective.
>> Objective is to generate file having records as to when basic has changed
>> for the concerned over the period of time.
>>
>>
>> Thanks & Regards,
>>
>> C.G.Kumar
>>
>>
>> On Mon, Feb 7, 2011 at 1:12 PM, ashish koul wrote:
>>
>>> use advance filter
>>>
>>> 1 select col a,b , c goto  data- > advance filter
>>>
>>> select unique records and  click on copy to another loaction and select
>>> the destination cell
>>>
>>>
>>>
>>>
>>> On Mon, Feb 7, 2011 at 11:28 AM, C.G.Kumar 
>>> wrote:
>>>
>>>> Please find attached file where i intend to extract only unique records
>>>> in column C (Basic) provided column B ( Staff No.) remains same. In other
>>>> words, the objective is to extract "Basic"  of same person for different
>>>> periods.
>>>>
>>>> Sample data file attached.
>>>>
>>>>
>>>> Regards,
>>>>
>>>> C.G.Kumar
>>>>
>>>> --
>>>>
>>>> --
>>>> 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 

Re: $$Excel-Macros$$ Unique records

[C.G.Kumar]

Sir,

Thanks for the solution.However, unique records are not as required.This is
due to the fact that you have considered all column e.g. Basic, Ser Wght,
FPI, WRI,DPAY etc, whereas required unique records is for Basic records only
for particular column.


The solution suggested by you is very innovative and i would apply the same.


I once again thanks for the courteous support.


Regards,

C.G.Kumar





On Mon, Feb 7, 2011 at 10:27 PM, rajan verma wrote:

> Hi
> Find attachment
>
> Rajan
>
>
> On Mon, Feb 7, 2011 at 2:26 AM, Manoj kumar <
> manoj.vishwakarma...@gmail.com> wrote:
>
>> Hi C.G,
>>
>> A little complex but hope this might help your needs...
>>
>>
>> Regards,
>> Manoj Kumar
>>
>>
>> On Mon, Feb 7, 2011 at 2:42 PM, C.G.Kumar wrote:
>>
>>> Not getting required result as i have to filter by two criteria ;1. staff
>>> no and 2. Basic. Same staff no may have different basic over period of time.
>>> After selecting unique records also, the output so generated is same is base
>>> records.
>>>
>>>
>>> Further, unique records does not works as two person may have same basic
>>> and therefore, filter criteria by unique records destroys the objective.
>>> Objective is to generate file having records as to when basic has changed
>>> for the concerned over the period of time.
>>>
>>>
>>> Thanks & Regards,
>>>
>>> C.G.Kumar
>>>
>>>
>>> On Mon, Feb 7, 2011 at 1:12 PM, ashish koul wrote:
>>>
>>>> use advance filter
>>>>
>>>> 1 select col a,b , c goto  data- > advance filter
>>>>
>>>> select unique records and  click on copy to another loaction and select
>>>> the destination cell
>>>>
>>>>
>>>>
>>>>
>>>> On Mon, Feb 7, 2011 at 11:28 AM, C.G.Kumar 
>>>> wrote:
>>>>
>>>>> Please find attached file where i intend to extract only unique records
>>>>> in column C (Basic) provided column B ( Staff No.) remains same. In other
>>>>> words, the objective is to extract "Basic"  of same person for different
>>>>> periods.
>>>>>
>>>>> Sample data file attached.
>>>>>
>>>>>
>>>>> Regards,
>>>>>
>>>>> C.G.Kumar
>>>>>
>>>>> --
>>>>>
>>>>> --
>>>>> 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
>&g

Re: $$Excel-Macros$$ Unique records

[C.G.Kumar]

Not getting required result as i have to filter by two criteria ;1. staff no
and 2. Basic. Same staff no may have different basic over period of time.
After selecting unique records also, the output so generated is same is base
records.


Further, unique records does not works as two person may have same basic and
therefore, filter criteria by unique records destroys the objective.
Objective is to generate file having records as to when basic has changed
for the concerned over the period of time.


Thanks & Regards,

C.G.Kumar


On Mon, Feb 7, 2011 at 1:12 PM, ashish koul  wrote:

> use advance filter
>
> 1 select col a,b , c goto  data- > advance filter
>
> select unique records and  click on copy to another loaction and select the
> destination cell
>
>
>
>
> On Mon, Feb 7, 2011 at 11:28 AM, C.G.Kumar wrote:
>
>> Please find attached file where i intend to extract only unique records in
>> column C (Basic) provided column B ( Staff No.) remains same. In other
>> words, the objective is to extract "Basic"  of same person for different
>> periods.
>>
>> Sample data file attached.
>>
>>
>> Regards,
>>
>> C.G.Kumar
>>
>> --
>>
>> --
>> 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

Re: $$Excel-Macros$$ Official launch of Knowledge Portal - discussexcel.com

[C.G.Kumar]

I TOO INTEND TO CONTRIBUTE.

On Wed, Feb 2, 2011 at 9:09 PM, Ayush  wrote:

> Hello everyone,
>
> I am glad to share that I have decided to launch an excel knowledge website
> for this group.The website will be launched on 4th anniversary of this group
> i.e. 17th March 2011.
>
> The designing of the website and development of content has already been
> initiated by me.
> I will need your support time to time on content development & design too.
> Please let me know if you want to volunteer for writing the content or any
> other task in website development.
>
> The discussexcel.com domain will be used for this website. Its a long way
> to go & I am VERY EXCITED about the launch.
> Keep watching this space.
>
> Thanks & Best regards
> Ayush Jain
> Group Manager
>
> --
>
> --
> 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

Re: $$Excel-Macros$$ Array If

[C.G.Kumar]

USE THIS
=IF(A$8$:$A$14="a",1,"")

If u want to use as an array use cntr+shift+enter. It will give u proper
result.


Thanks & Regards,

C.G.Kumar

On Mon, Jan 17, 2011 at 1:03 AM, hanumant shinde
wrote:

> Hi Friends,
>
> I want to use IF condition like i used below but its no working.
> I used below formula.
> ={IF($A$8:$A$14="a",1,"")}
>
>  f  d  s  d  f  g  a .
> .
> .
>  and so on
>
> this is my data which is random.
> i want to write if any of the row in above data has "a" then write 1 else
> 0. if condition will come only once not for all the rows.
> i dont wanna use macro nor OR as data can be large.
>
> Thanks
>
>  --
>
> --
> 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

Re: $$Excel-Macros$$ Re: Run a macro every time excel is opened

[C.G.Kumar]

Paul,

I intend to open file located in specific Folder each time i open a blank
workbook file.This contains Task to be performed and data to be updated each
hour based on customer request. Since there are more than 10 Excel file to
be updated manually (based on request received from customer and Task
completed, in process,yet to start etc, ) i thought a macro would be handy
to accomplish my task.

Regards,

C.G.Kumar




On Mon, Dec 20, 2010 at 7:58 PM, Paul Schreiner wrote:

> For this to work, it must be in EACH Excel file that you wish to open!
>
> It will not work for "ANY Excel file", but only the ones that contain this
> macro.
>
> Can you explain what it is that you're trying to accomplish?
>
> Is it for multiple users? or just yourself?
>
> You could place the file in the XLStart folder
> (Excel opens all files in this folder when Excel is launched)
> Paul
>
>
> *From:* C.G.Kumar 
> *To:* richard.m...@gmail.com
> *Cc:* excel-macros@googlegroups.com
> *Sent:* Mon, December 20, 2010 12:09:29 AM
> *Subject:* Re: $$Excel-Macros$$ Re: Run a macro every time excel is opened
>
> I have used the following code;
>
>  Sub Workbook_Open()
>  Application.DisplayAlerts = False
> On Error Resume Next
> Workbooks.Open Filename:= _
> "E:\Documents and Settings\DRIVE\Desktop\Tasks.xls
>  On Error GoTo 0
> Application.DisplayAlerts = True
>
> End Sub
>
> I have made macro security to low & i require this macro to run whenever i
> open any excel file. but this is not working.Any suggestion.
>
>
> Thanks & Regards,
>
> C.G.Kumar
>
> On Sat, Dec 18, 2010 at 6:53 PM, Richard  wrote:
>
>> Create a sub called "sub workbook_open" in "this workbook" and call
>> your macro.
>>
>> On Dec 18, 3:34 am, "C.G.Kumar"  wrote:
>> > I want a macro to run every time when an excel file is opened.
>>
>> --
>>
>> --
>> 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
>

-- 
--
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$$ Facing calculation issue using Time type in excel

[C.G.Kumar]

Paul,

I must admit that you are genius as the  way of you explained the thing in
such a lucid manner that a naive person like me understood at first
sight... Unbelievable ..Many Many Thanks again to you Paul as you devoted
your precious time for us...




Thanks & Regards,

C.G.Kumar


On Mon, Dec 20, 2010 at 7:36 PM, Paul Schreiner wrote:

> In that case, you're going to have to get a little more "creative" with
> your formula.
>
> As I said, the result in subtracting two date/times is a NUMBER.
> In your example,
> A1 = 10/12/2010  9:00:00 AM  and  B1 = 20/12/2010  10:00:00 AM
> results in:
> 10.04142, or 10 days and .04142 of a day.
>
> To have the cell show "10 Days",
> you need to "extract" the integer portion of the number:
> =INT(ABS(B1-A1))
>
> and append the word "Days":
>
> =INT(ABS(B1-A1)) & " Days"
>
> -
> Next, you need the fractional part of the time difference.
>
> To do that, you can take the difference, and subtract the integer portion:
> ABS(B1-A1) - INT(ABS(B1-A1))
>
> Since this is the "fractional part of a day",
> to convert this to hours, multiply by 24 hours/day:
> (ABS(B1-A1) - INT(ABS(B1-A1))) * 24
>
>  Now, there COULD be some rounding errors.
> In MY case, the result came out to be:
> 0.9941792 hours...
> So, you can use the ROUND() function to round it off to hours, and
> fractional hours.
>
> ROUND((ABS(B1-A1) - INT(ABS(B1-A1)))*24,1)
>
> and then append the string "Hours"
> -
>
> Combining these two techniques, you get a function like:
>
> =INT(ABS(B1-A1)) & " Days, " & ROUND((ABS(B1-A1) - INT(ABS(B1-A1)))*24,1) &
> " Hours"
> which will display as:
>
> 10 Days, 1 Hours
>
> Now, if you're REALLY wanting to make sure that if the number of days is
> (1), then simply say "Day" instead of "Days", and "Hour" instead of "Hours",
> You're going to have to include "IF()" statements, and your function
> becomes:
>
> =INT(ABS(B1-A1))
> & IF(INT(ABS(B1-A1)) = 1," Day, "," Days, ")
> & ROUND((ABS(B1-A1) - INT(ABS(B1-A1)))*24,1)
> & IF(ROUND((ABS(B1-A1) - INT(ABS(B1-A1)))*24,1) =1," Hour", " Hours")
>
>
> Paul
>
>
> *From:* C.G.Kumar 
> *To:* excel-macros@googlegroups.com
> *Cc:* schreiner_p...@att.net
> *Sent:* Mon, December 20, 2010 4:03:07 AM
> *Subject:* Re: $$Excel-Macros$$ Facing calculation issue using Time type
> in excel
>
> Could you please tell what if there is more than 1 day difference. Say A1
> has 10/12/2010 09:00 and B1 is 20/12/2010 10:00, then put Formulae in C1 as
> ABS(B1-A1) in time format it gives result as 10/01/1900  1:00:00 . Actual it
> should be 10 Days and 1 Hours.
>
>
> Any suggestion will be appreciated.
>
>
> Thanks & Regards,
>
> C.G.Kumar
>
>
>
>
> On Sat, Dec 18, 2010 at 10:29 PM, Bharghav Ramdas wrote:
>
>>
>> Thanx Paul.
>>
>>
>>
>> On Thu, Dec 16, 2010 at 1:31 AM, Paul Schreiner 
>> wrote:
>>
>>>  Keep in mind that Excel doesn't know "time".
>>> It knows "numbers".
>>> Time is simply the "fractional part of a day"
>>>
>>> 9:30 is 0.3958333 of a day.
>>> 10:00 is 0.417 of a day.
>>>
>>> so, 9:30 - 10:00 is: -0.0208334
>>> Now really, is 12/15/2010 -01:30 PM a valid time?
>>> Of course not... how can you have a NEGATIVE time of day?
>>>
>>> So, since you're DISPLAYING the cells in a TIME format,
>>> it produces an error with the negative result.
>>>
>>> If you don't CARE about the sign, then you can use:
>>> =ABS(A1-A2)
>>> and format it as "time" to get: 0:30
>>>
>>> If you DO care about the sign, then you need to change the display format
>>> to a numeric format.
>>>
>>> Paul
>>>
>>>
>>> *From:* Bharghav Ramdas 
>>> *To:* excel-macros@googlegroups.com
>>> *Sent:* Wed, December 15, 2010 1:39:36 PM
>>> *Subject:* $$Excel-Macros$$ Facing calculation issue using Time type in
>>> excel
>>>
>>> Hi All,
>>>
>>> When I subtract 9:30 from 10:00 (Data Type :Time),all I get to see is
>>> ###.How do I go about resolving this issue.I require a positive number 0:30
>>> inspite of the result turning out to be nega

Re: $$Excel-Macros$$ Facing calculation issue using Time type in excel

[C.G.Kumar]

Could you please tell what if there is more than 1 day difference. Say A1
has 10/12/2010 09:00 and B1 is 20/12/2010 10:00, then put Formulae in C1 as
ABS(B1-A1) in time format it gives result as 10/01/1900  1:00:00 . Actual it
should be 10 Days and 1 Hours.


Any suggestion will be appreciated.


Thanks & Regards,

C.G.Kumar




On Sat, Dec 18, 2010 at 10:29 PM, Bharghav Ramdas wrote:

>
> Thanx Paul.
>
>
>
> On Thu, Dec 16, 2010 at 1:31 AM, Paul Schreiner wrote:
>
>>  Keep in mind that Excel doesn't know "time".
>> It knows "numbers".
>> Time is simply the "fractional part of a day"
>>
>> 9:30 is 0.3958333 of a day.
>> 10:00 is 0.417 of a day.
>>
>> so, 9:30 - 10:00 is: -0.0208334
>> Now really, is 12/15/2010 -01:30 PM a valid time?
>> Of course not... how can you have a NEGATIVE time of day?
>>
>> So, since you're DISPLAYING the cells in a TIME format,
>> it produces an error with the negative result.
>>
>> If you don't CARE about the sign, then you can use:
>> =ABS(A1-A2)
>> and format it as "time" to get: 0:30
>>
>> If you DO care about the sign, then you need to change the display format
>> to a numeric format.
>>
>> Paul
>>
>>
>> *From:* Bharghav Ramdas 
>> *To:* excel-macros@googlegroups.com
>> *Sent:* Wed, December 15, 2010 1:39:36 PM
>> *Subject:* $$Excel-Macros$$ Facing calculation issue using Time type in
>> excel
>>
>> Hi All,
>>
>> When I subtract 9:30 from 10:00 (Data Type :Time),all I get to see is
>> ###.How do I go about resolving this issue.I require a positive number 0:30
>> inspite of the result turning out to be negative.
>>
>> FYI
>> =(1-2)
>>   Current   Expecting
>> 19:309:30
>> 210:00  10:00
>>      0:30
>>
>> Let me know ur suggestions.
>>
>> Thanks,
>> Bharghav 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
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> 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
>

-- 
--
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$$ Re: Run a macro every time excel is opened

[C.G.Kumar]

I have used the following code;

Sub Workbook_Open()
Application.DisplayAlerts = False
On Error Resume Next
Workbooks.Open Filename:= _
"E:\Documents and Settings\DRIVE\Desktop\Tasks.xls
On Error GoTo 0
Application.DisplayAlerts = True

End Sub

I have made macro security to low & i require this macro to run whenever i
open any excel file. but this is not working.Any suggestion.


Thanks & Regards,

C.G.Kumar

On Sat, Dec 18, 2010 at 6:53 PM, Richard  wrote:

> Create a sub called "sub workbook_open" in "this workbook" and call
> your macro.
>
> On Dec 18, 3:34 am, "C.G.Kumar"  wrote:
> > I want a macro to run every time when an excel file is opened.
>
> --
>
> --
> 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$$ Run a macro every time excel is opened

[C.G.Kumar]

Sir,

I have used the following code;

Sub Workbook_Open()
Application.DisplayAlerts = False
On Error Resume Next
Workbooks.Open Filename:= _
"E:\Documents and Settings\DRIVE\Desktop\Tasks.xls
On Error GoTo 0
Application.DisplayAlerts = True

End Sub

I have made macro security to low & i require this macro o run whenever i
open excel file. but this is not working.Any suggestion.


Thanks & Regards,

C.G.Kumar




On Sat, Dec 18, 2010 at 7:30 PM, ashish koul  wrote:

> write the code in workbook open module
>
>
> On Sat, Dec 18, 2010 at 5:04 PM, C.G.Kumar wrote:
>
>> I want a macro to run every time when an excel file is opened.
>>
>>
>>
>>
>>  --
>>
>> --
>> 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
>>
>
>
>
> --
> *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/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$$ Run a macro every time excel is opened

[C.G.Kumar]

I want a macro to run every time when an excel file is opened.

-- 
--
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$$ Require specific entry in a cell or nothing

[C.G.Kumar]

Use data validation and specify the exact requirement.

On Sat, Dec 18, 2010 at 4:07 AM, Richard  wrote:

> Is is possible to require a specific entry in a cell, or nothing?
>
> If someone makes an entry in a cell, I want it to be ABC (all upper
> case) and nothing else.  It's OK for the cell to be blank.
> How can I do it?
>
> Thanks in advance.
>
> Rich
>
> --
>
> --
> 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$$ New Rupee Symbol

[C.G.Kumar]

THANKS. . BUT IT PREVENTS THE ARITHMETIC CALCULATION ..

On Sat, Dec 18, 2010 at 11:03 AM, manhar prajapati <
prajapati.man...@gmail.com> wrote:

> 1 select font of Ruppee furdine in Excel
>
> 2 Use ` symbol for Ruppee symbol
>
> manhar
>
> On Sat, Dec 18, 2010 at 10:38 AM, C.G.Kumar wrote:
>
>> Dear All,
>>
>>
>> I want to use New Rupee symbol and did the following;
>>
>> 1. Downloaded the font Rupee.ttf or the new version Rupee_Foradian.ttf
>> 2. Installed the font. (Copy and paste in "Fonts" folder in control
>> panel).
>>
>>
>> But , i am not able to use the symbol in excel.
>>
>> Could any one tell me the fallacy.
>>
>>
>>
>> Regards,
>>
>> C.G.Kumar
>>
>>  --
>>
>> --
>> 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$$ New Rupee Symbol

[C.G.Kumar]

Dear All,


I want to use New Rupee symbol and did the following;

1. Downloaded the font Rupee.ttf or the new version Rupee_Foradian.ttf
2. Installed the font. (Copy and paste in "Fonts" folder in control panel).


But , i am not able to use the symbol in excel.

Could any one tell me the fallacy.



Regards,

C.G.Kumar

-- 
--
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$$ Need help to get the collection date with the help of formula

[C.G.Kumar]

No attachment found.

On Fri, Dec 10, 2010 at 3:16 PM, lucky singh  wrote:

>
> 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
>

-- 
--
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$$ if formula help

[C.G.Kumar]

Solved & file Attached. Hope it serves the purpose.

Regards,

C.G.Kumar



On Wed, Dec 8, 2010 at 10:10 AM, Abhidha Dixit wrote:

> Dear All,
>
> please help me with  the formula where in I should get the result
>
> 1 IF left 3 strings is ABH then B2 -200, IF DIX then B2 -400 , IF DEL then
> B2-300, subsequelntly I hve tried but somehow i am not getting the desired
> result
>
> Regards
> Abhidha
>
> --
>
> --
> 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
>



-- 
Regards,

C.G.Kumar

-- 
--
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


PROBLEM.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Fwd: Macro to select particular record based on criteria.

[C.G.Kumar]

Dear all,

Wit reference to my previous mail, i have developed the small code
(furnished below). However, what is the flaw in the code is that it
overwrites my previous data in sheet 2. Is there any way i could make
updation only for fresh data updated today in sheet1 .

Thanks in Advance.


Regards,

C.G.Kumar
AMW-2

Code:
Sub Macro3()
'
' Macro3 Macro
'

'
Range("A2").Select
Range(Selection, Selection.End(xlToRight)).Select
Range(Selection, Selection.End(xlDown)).Select
Selection.AutoFilter
Range("J2").Select
ActiveSheet.Range("$A$2:$L$2927").AutoFilter Field:=10,
Criteria1:="<>1", _
Operator:=xlAnd
Selection.End(xlToLeft).Select
Range("A2").Select
Range(Selection, Selection.End(xlToRight)).Select
Range(Selection, Selection.End(xlDown)).Select
Range("J3").Select
Selection.End(xlDown).Select
Selection.End(xlUp).Select
Range("A2").Select
Range(Selection, Selection.End(xlToRight)).Select
Range(Selection, Selection.End(xlDown)).Select
Selection.SpecialCells(xlCellTypeVisible).Select
Selection.Copy
ActiveCell.SpecialCells(xlLastCell).Select
Sheets("sheet2").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
SkipBlanks _
:=False, Transpose:=False
Columns("A:A").Select
Range("A2").Activate
Application.CutCopyMode = False
Selection.Delete Shift:=xlToLeft
Columns("D:D").Select
Range("D2").Activate
Selection.Delete Shift:=xlToLeft
Selection.Delete Shift:=xlToLeft
Columns("E:E").Select
Range("E4").Activate
Selection.Delete Shift:=xlToLeft
Range("G4").Select
Selection.End(xlUp).Select
Sheets("sheet1").Select
Range("A2").Select
Range(Selection, Selection.End(xlToRight)).Select
Selection.AutoFilter

End Sub
-- Forwarded message --
From: C.G.Kumar 
Date: Mon, Dec 6, 2010 at 10:40 AM
Subject: Macro to select particular record based on criteria.
To: excel-macros@googlegroups.com


Dear All,

I have to maintain two excel file/sheet:

1. For outstanding from Customer :It records sale by various office and
collection from customer . It has 12 column (Sr.No.1 to 12) and around 3500
rows.The same is updated periodically.

2. Cheque collection File: This file contains selected record from above
file i.e. Sr.No. / Col No (2,3,4,7,10,11 & 12) only if there is cheque no
(Other than 1as 1 is for non collection of outstanding).

I have to perform this manually which is very time consuming and prone to
error. Whether it is possible to draft a macro to do so.File attached for
ready reference.

I am an optimist and feel there is way. Hope much experienced people could
show me some light.

Regards,

C.G.Kumar




-- 
Regards,

C.G.Kumar

-- 
--
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


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

$$Excel-Macros$$ Macro to select particular record based on criteria.

[C.G.Kumar]

Dear All,

I have to maintain two excel file/sheet:

1. For outstanding from Customer :It records sale by various office and
collection from customer . It has 12 column (Sr.No.1 to 12) and around 3500
rows.The same is updated periodically.

2. Cheque collection File: This file contains selected record from above
file i.e. Sr.No. / Col No (2,3,4,7,10,11 & 12) only if there is cheque no
(Other than 1as 1 is for non collection of outstanding).

I have to perform this manually which is very time consuming and prone to
error. Whether it is possible to draft a macro to do so.File attached for
ready reference.

I am an optimist and feel there is way. Hope much experienced people could
show me some light.

Regards,

C.G.Kumar

-- 
--
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


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

Re: $$Excel-Macros$$ Zooming of Excel Sheet.

[C.G.Kumar]

Yes. Cool stuff.

Thanks for the help.


Regards,

C.G.Kumar

On Tue, Nov 23, 2010 at 4:03 PM, kiran Kancharla wrote:

> U need to change the options.
>
> Tool  ---> Options -->  General "Zoom on roll with Intellimouse"
>
> This has to Uncheck.
>
>
> please try and let me know.
>
>
>
>
> On Tue, Nov 23, 2010 at 10:42 AM, C.G.Kumar 
> wrote:
> > Is it not possible that MS Excel control has changed.
> >
> >
> > On Tue, Nov 23, 2010 at 10:09 AM, Gangaram.  wrote:
> >>
> >> possibility is Your keyboard control button might be malfunctioning
> >> or  Accidently CTRL key got struck and kept pressed. Check it out.
> >>
> >>
> >> On Nov 22, 11:14 pm, "Ms-Exl-Learner ." 
> >> wrote:
> >> > Check whether your cntrl button is working.
> >> >
> >> > 
> >> > Ms-Exl-Learner
> >> > 
> >> >
> >> > On Mon, Nov 22, 2010 at 10:52 AM, C.G.Kumar
> >> > wrote:
> >> >
> >> >
> >> >
> >> > > Dear All,
> >> >
> >> > > When i am using scroll wheel of mouse my excel sheet gets Zoom In
> >> > > (Moving
> >> > > Forward) & Zoom out ( (Moving Backward). Earlier this function
> worked
> >> > > when i
> >> > > press ctrl+scroll of mouse.
> >> >
> >> > > I prefer earlier control and intend to scroll with my mouse the
> excel
> >> > > sheet
> >> > > instead of ZOOM option. Can any body tell me how to rectify.
> >> >
> >> > > Regards,
> >> >
> >> > > C.G.Kumar
> >> >
> >> > >  --
> >> >
> >> > >
> >> > >
> --
> >> > > 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 athttp://www.excel-macros.blogspot.com
> >> > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> >> > > 5. Excel Tips and Tricks athttp://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&;...
> >> >
> >> > --
> >> > ---
> >> > Ms.Exl.Learner
> >> > ---
> >>
> >> --
> >>
> >>
> --
> >> 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
> >
> >
> >
> > --
> > Regards,
> > C.G.Kumar
> >
> > --
> >
> --
> > 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.qui

Re: $$Excel-Macros$$ Zooming of Excel Sheet.

[C.G.Kumar]

Is it not possible that MS Excel control has changed.



On Tue, Nov 23, 2010 at 10:09 AM, Gangaram.  wrote:

> possibility is Your keyboard control button might be malfunctioning
> or  Accidently CTRL key got struck and kept pressed. Check it out.
>
>
> On Nov 22, 11:14 pm, "Ms-Exl-Learner ." 
> wrote:
> > Check whether your cntrl button is working.
> >
> > 
> > Ms-Exl-Learner
> > ----
> >
> > On Mon, Nov 22, 2010 at 10:52 AM, C.G.Kumar  >wrote:
> >
> >
> >
> > > Dear All,
> >
> > > When i am using scroll wheel of mouse my excel sheet gets Zoom In
> (Moving
> > > Forward) & Zoom out ( (Moving Backward). Earlier this function worked
> when i
> > > press ctrl+scroll of mouse.
> >
> > > I prefer earlier control and intend to scroll with my mouse the excel
> sheet
> > > instead of ZOOM option. Can any body tell me how to rectify.
> >
> > > Regards,
> >
> > > C.G.Kumar
> >
> > >  --
> >
> > >
> --
> > > 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 athttp://www.excel-macros.blogspot.com
> > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> > > 5. Excel Tips and Tricks athttp://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&;.
> ..
> >
> > --
> > ---
> > Ms.Exl.Learner
> > ---
>
> --
>
> --
> 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
>



-- 
Regards,

C.G.Kumar

-- 
--
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$$ Zooming of Excel Sheet.

[C.G.Kumar]

Yes cntrl button is working.

On Mon, Nov 22, 2010 at 11:44 PM, Ms-Exl-Learner .  wrote:

> Check whether your cntrl button is working.
>
> 
> Ms-Exl-Learner
> 
>
>
> On Mon, Nov 22, 2010 at 10:52 AM, C.G.Kumar wrote:
>
>> Dear All,
>>
>>
>> When i am using scroll wheel of mouse my excel sheet gets Zoom In (Moving
>> Forward) & Zoom out ( (Moving Backward). Earlier this function worked when i
>> press ctrl+scroll of mouse.
>>
>> I prefer earlier control and intend to scroll with my mouse the excel
>> sheet instead of ZOOM option. Can any body tell me how to rectify.
>>
>>
>> Regards,
>>
>> C.G.Kumar
>>
>>  --
>>
>> --
>> 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
>>
>
>
>
> --
> ---
> Ms.Exl.Learner
> ---
>
>  --
>
> --
> 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
>



-- 
Regards,

C.G.Kumar

-- 
--
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$$ Zooming of Excel Sheet.

[C.G.Kumar]

Dear All,


When i am using scroll wheel of mouse my excel sheet gets Zoom In (Moving
Forward) & Zoom out ( (Moving Backward). Earlier this function worked when i
press ctrl+scroll of mouse.

I prefer earlier control and intend to scroll with my mouse the excel sheet
instead of ZOOM option. Can any body tell me how to rectify.


Regards,

C.G.Kumar

-- 
--
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$$ VBA Help

[C.G.Kumar]

You can use EDATE if using Excel  2007. Rest you can define in Macro.


Regards,

C.G.Kumar


On Sat, Oct 23, 2010 at 12:07 AM, halpie97 wrote:

> I'm a beginner with VBA and looking for some guidance in how to
> establish what I'm trying to do.
>
> Column A   Column B   Column C   Column D
> 1/15/2010   6/30/2009
> 3/2/2010 4/15/2008
>
> I'm trying to create a VBA formula that will do the following in
> columns C and D:
> Column C should just be one year from Column A and insert the new
> date.
> Column D should be 180 days from Column B only if the date in Column A
> is less than 180 days and column B is greater than Column B.
> (Bascially trying to create a schedule for a date stamp of one year
> from Column A and then 180 dats from Column B but not if Column A
> happened within the 180 days).
>
> I'm looking for the function to insert the calcuated date value in
> both columns C and D for future reference.
>
> Thanks in advance for the help.
>
> --
>
> --
> 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
>



-- 
Regards,

C.G.Kumar

-- 
--
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$$ Stander O/s Format

[C.G.Kumar]

I could not identify whether it is a solution or your query.If this is
solution pls ignore my mail, otherwise you may please explain the objective
and problem.

Thanks & Regards,

C.G.Kumar



On Sat, Oct 9, 2010 at 2:20 PM, SUMIT VYAS  wrote:

> Thanks For all member of  Excel-macros group.
>
> and first thanks Mr. Ayush Jain
>
>
> Dear All,
>
> Please find herewith enclosed stander o/s format/.
>
>
> any query call me any time.
>
>
>
> sumit vyas
>
> +919303861403
>
>  --
>
> --
> 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
>



-- 
Regards,

C.G.Kumar

-- 
--
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$$ Quick help needed to Find duplicate by formula

[C.G.Kumar]

Use the following formulae ; IF(COUNTIF(A$1:A1,A1)=1,"Unique","Dupl")


Hope it serve the purpose.



Thanks & Regards,


C.G.Kumar




On Wed, Oct 13, 2010 at 8:43 PM, vinod rao  wrote:

> HI
>
> I have multipal duplicate numbers and excluding one for others it should
> say duplicate. how do i enter formula in 2003/2007
>
> Thanks
> Vinod
>
> --
>
> --
> 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
>



-- 
Regards,

C.G.Kumar

-- 
--
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$$ Macro to run on specific day.

[C.G.Kumar]

You explained the logic in a precise and logical manner.I really appreciate
your way of explaining.

So nice of you Mr.Paul.


Thanks & Regards,

C.G.Kumar



On Wed, Oct 13, 2010 at 7:48 PM, Paul Schreiner wrote:

> Let's examine what you're asking:
>
> (Now) returns the current date and time.
>
> Day(Now) returns the DAY portion of the current date and time.
>
> So, when I run this today (10/13/2010), Day(Now) returns 13.
>
> So.. the results of Day(Now) can ONLY be 1 to 31 (depending on the month)
> it will NEVER be 0
>
> Therefore,
> If (Day(Now)) = 0
> will NEVER be true...
>
>
> If you want it to run on the 13th day of each month, use:
>
> If (Day(Now) = 13) then
>
> (or change the 13 to whatever day of the month you wish to use)
>
> hope this helps,
>
> Paul
>
>
> *From:* C.G.Kumar 
> *To:* excel-macros@googlegroups.com
> *Cc:* villager.g...@gmail.com
> *Sent:* Wed, October 13, 2010 2:22:17 AM
> *Subject:* Re: $$Excel-Macros$$ Macro to run on specific day.
>
> i want to run this macro for today only , i am using following code but is
> not working
>
>  if (day(now) ) = 0 then
> ' my code
> end if
>
> Looking your comments ...
>
> On Wed, Oct 13, 2010 at 11:41 AM, siti Vi  wrote:
>
>> only work on day 5 to 10  of the month
>>
>>
>> sub blablabla()
>>
>> if day(date) >= 5 and day(date) <=10 then
>>
>> *  *your full macro*
>> *
>> end if
>>
>> end sub
>>
>>
>>
>>
>>
>> On Wed, Oct 13, 2010 at 12:26 PM, C.G.Kumar 
>> wrote:
>> > Dear All,
>> > I want my macro to be executed only for specific day in a month based on
>> system date and it should not run thereafter.
>> > Kindly let me know the code for it.It's urgent.
>> > Regards,
>> > C.G.Kumar
>>
>> --
>>
>> --
>> 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
>>
>
>
>
> --
> Regards,
>
> C.G.Kumar
>
> --
>
> --
> 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
>



-- 
Regards,

C.G.Kumar

-- 
--
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$$ Macro to run on specific day.

[C.G.Kumar]

i want to run this macro for today only , i am using following code but is
not working

if (day(now) ) = 0 then
' my code
end if

Looking your comments ...

On Wed, Oct 13, 2010 at 11:41 AM, siti Vi  wrote:

> only work on day 5 to 10  of the month
>
>
> sub blablabla()
>
> if day(date) >= 5 and day(date) <=10 then
>
> *  *your full macro*
> *
> end if
>
> end sub
>
>
>
>
>
> On Wed, Oct 13, 2010 at 12:26 PM, C.G.Kumar 
> wrote:
> > Dear All,
> > I want my macro to be executed only for specific day in a month based on
> system date and it should not run thereafter.
> > Kindly let me know the code for it.It's urgent.
> > Regards,
> > C.G.Kumar
>
> --
>
> --
> 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
>



-- 
Regards,

C.G.Kumar

-- 
--
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$$ Macro to run on specific day.

[C.G.Kumar]

Dear All,


I want my macro to be executed only for specific day in a month based on
system date and it should not run thereafter.

Kindly let me know the code for it.It's urgent.





Regards,

C.G.Kumar

-- 
--
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$$ Conditional Sum or Sumproduct.

[C.G.Kumar]

THANKS. BUT IT SERVE THE PURPOSE PARTIALLY...IN ADDITION I HAVE TO CONSIDER
ONLY FY 2009-10 WHEREAS FORMULA TAKES BEYOND 31/03/2010.3


IS IT POSSIBLE TO REVISE THE FORMULA.


REGARDS,

C.G.KUMAR

On Fri, Oct 8, 2010 at 2:19 PM, ashish koul  wrote:

> check the atatchment see if it helps
>
>
>
> On Fri, Oct 8, 2010 at 12:18 PM, Chandra Gupt Kumar <
> kumar.bemlmum...@gmail.com> wrote:
>
>>  Objective is to calculate Sale for the financial year 2009-10 (April
>> 2009 – March 2010 )for each staff no. Data are in sheet named ‘DATA’ in
>> different column. It Starts with Staff No. then Start Date, End Date, Sale
>> Type, and Amount (*It is* *Sale per month during start and end period)*.
>>
>>
>>
>> 1.   For example : if we have to calculate sale made by staff no.9465
>> during financial Year 2009-10, we see staff no.9465 and start with
>> identifying April 09 sale is at Row no 8 & monthly sale were 12850.00 (cell
>> E8) for April to June 10. Further, from July 09 to March 10, sale were 29100
>> per month. So, total sale for the financial Year should come : 12850*3(
>> April – June 09)  +29100*9( July – March 10) =300450.00. Output required
>> against this staff no is 300450.00
>>
>> 2.   Next if we calculate for Staff no.17442 , it comes 0 (Zero).
>> Because last data for him is for the period 01/07/2005 to 31/10/2007.
>>
>> 3.   If we proceed to calculate for Staff No.17822, output should be
>> 118200.00 . This is calculated in following manner; he sold for 9750  per
>> month from 01/10/2008 to 30/09/2009 ,since we are determining only for April
>> 09 to March 10, we will consider 9750 for 6 months i.e. April 09- September
>> 09.  Further, sale for the period 01/10/2009 to 31/12/ is/expected to
>> 9950.00. We again have to consider only period for April 09 to March 10, and
>> hence sale is :9950*6 (for October to March 10). Total sale by Staff No.
>> 17822 is 118200.00 {(9750*6(April-Sep09 months)  +9950*6(Sept 09-March 10) =
>> 118200.)
>>
>>
>>
>> Hope it helps you to solve the crux .
>>
>>
>>
>>
>>
>> Regards,
>>
>>
>>
>> C.G.Kumar
>>
>> AMW-2
>>
>>
>>
>> *From:* excel-macros@googlegroups.com [mailto:
>> excel-mac...@googlegroups.com] *On Behalf Of *Aindril De
>> *Sent:* Friday, October 08, 2010 11:35 AM
>> *To:* excel-macros@googlegroups.com
>> *Subject:* Re: $$Excel-Macros$$ Conditional Sum or Sumproduct.
>>
>>
>>
>> Hi C.G.,
>>
>>
>>
>> Could you please elaborate more on what condition you would like to put in
>> here?
>>
>>
>>
>> Regards,
>>
>> Andy
>>
>> On Fri, Oct 8, 2010 at 10:34 AM, C.G.Kumar 
>> wrote:
>>
>> I am looking for conditional sum i.e. sum based on criteria. But neither
>> Sumproduct nor SUMIFS and Pivot serve the purpose.
>>
>> Attached sample file . Hope you will be able to solve the crux.
>>
>>
>>
>>
>> Regards,
>>
>>
>>
>> C.G.Kumar
>>
>>
>>
>>
>>
>> --
>>
>> --
>> 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 g

$$Excel-Macros$$ Conditional Sum or Sumproduct.

[C.G.Kumar]

I am looking for conditional sum i.e. sum based on criteria. But neither
Sumproduct nor SUMIFS and Pivot serve the purpose.

Attached sample file . Hope you will be able to solve the crux.


Regards,

C.G.Kumar

-- 
--
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


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

$$Excel-Macros$$ Conditional Sum or Sumproduct.

[C.G.Kumar]

Attached sample file for the problem. Hope somebody among you will be able
to solve the crux.


Regards,

C.G.Kumar

-- 
--
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


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

$$Excel-Macros$$ Conditional Sum or Sumproduct.

[C.G.Kumar]

Attached sample file for the problem. Hope somebody among you will be able
to solve the crux.


Regards,

C.G.Kumar

-- 
--
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


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

Re: $$Excel-Macros$$ Numer To Text

[C.G.Kumar]

See http://support.microsoft.com/kb/213360


<http://support.microsoft.com/kb/213360>Hope it serve the purpose.

On Mon, Oct 4, 2010 at 9:22 AM, Ankit Agrawal wrote:

> Hello Sir,
>
> Plz tell me any formula that convert number to text like
>
> 1500/-
> one thousand five hundered only
>
> Thanks & Regards,
> Ankit
>
> --
>
> --
> 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
>



-- 
Regards,

C.G.Kumar

-- 
--
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$$ Ayush Jain – Microsoft MVP 20 10

[C.G.Kumar]

Congratulation friend on reaching a milestone. Hope may more to come 

On Sun, Oct 3, 2010 at 3:47 PM, Ayush  wrote:

> Dear Group,
>
> I am proud to announce that I am awarded Microsoft Most Valuable
> Professional MVP on October 01, 2010 for providing technical expertise
> in Excel technical communities for past one year.
>
>
> http://blogs.technet.com/b/southasiamvp/archive/2010/10/01/new-mvps-announced-october-2010.aspx
>
> This is a prestigious award from Microsoft given every Quarter to the
> people who share their deep knowledge, real-world experience, and
> impartial, objective feedback to help people enhance the way they use
> technology.
>
> My deep thanks to each group member for all your support and
> contribution to this group.
>
> Best regards,
> Ayush Jain
> Microsoft MVP
>
> --
>
> --
> 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
>



-- 
Regards,

C.G.Kumar

-- 
--
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$$ What is budget mis

[C.G.Kumar]

1. MIS:http://en.wikipedia.org/wiki/Management_information_system
<http://en.wikipedia.org/wiki/Management_information_system>2. Budget:
http:// <http://en.wikipedia.org/wiki/Management_information_system>
http://en.wikipedia.org/wiki/Budget

<http://en.wikipedia.org/wiki/Budget>For beginner it is sufficient. Further,
in which respect you want to know please brief.




On Sat, Sep 25, 2010 at 9:00 PM, bhavya khanna  wrote:

> Hi Everyone,
>
> Can someone explain what is budget MIS. If some one has knowledge about
> that , please tell me . or send me website .
>
>
> Thanks
>
> --
>
> --
> 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
>



-- 
Regards,

C.G.Kumar

-- 
--
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$$ Excel 97 - Windows 7

[C.G.Kumar]

Dear,

You need not to worry. If you have Office 97 CD, you just install it on your
PC (in case Office 2003/2007 is not provided by the vendor).Office 97 will
work of Windows 7. In addition , if you install office 2007 then also you
will be able to work with office 97 file created earlier.

Regards,


C.G.Kumar


On Mon, Sep 13, 2010 at 12:13 AM, stuartR  wrote:

> Currently running Excel 97 on XP, everything works just fine.
>
> I am about to buy a new computer that will arrive loaded with Windows
> 7
>
> I understand the Office97 / Excel 97 will not work on Windows 7, is
> this correct?
>
> I have no wish or desire to buy office 2007, complete waste of money
> since excel 97 does everything that I need.
>
> If I have to purchase Office 2007. Will all my current Excel workbooks
> (some are very heavy with VBA scripts) work correctly.Excel 97 -
> Windows 7
>
>
> --
>
> --
> 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
>



-- 
Regards,

C.G.Kumar

-- 
--
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

$$Excel-Macros$$ Re: Lookup from date series

[C.G.Kumar]

Hi Kalyan,

Please find enclosed file as modified to suit your requirement.

Hope it serve the purpose.


Regards,


C.G.Kumar



On Thu, Sep 9, 2010 at 3:21 PM, Kal xcel  wrote:

> Hi Kumar,
>
> Please find the attached file.
>
> Thanks in advance
>
> Kalyan
>

-- 
--
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


SOLVED_KUMAR_lookup_from_date_series (1).xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Lookup from date series

[C.G.Kumar]

File attached. Check whether it serve the purpose.


Regards,


C.G.Kumar

On Wed, Sep 8, 2010 at 10:59 AM, Kal xcel  wrote:

> Dear Experts,
>
> I need a help, I want to lookup value from selected dates.
>
> File is attached
>
> Thanks in advance
>
> Kalyan
>
> --
>
> --
> 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


Solved_Kumar_lookup from date series.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Capture DATA>From Web - Portfolio Tracker

[C.G.Kumar]

Kamal,



Thanks for the suggestion but i did not found any shortcut/query for
extracting data directly in Excel.

Regards,

C.G.Kumar

On Tue, Sep 7, 2010 at 7:07 PM, kamal shah  wrote:

> C.G Kumar,
>
> I assume you need realtime Stock prices coming to Excel sheet, is that
> right?
> I have utility with me which you can use and extracts realtime stock prices
> from www.finance.yahoo.com for all BSE and NSE stocks.
>
> Please find it attached.
>
> Cheers
> Kamal
>
> On Tue, Sep 7, 2010 at 7:40 AM, C.G.Kumar wrote:
>
>> Dear All,
>>
>>
>> I need to capture Current Market Price of given scrip in Excel.I have used
>> DATA>From Web. But, it difficulty is that it captures entire data and not
>> only scrip CMP.
>>
>>
>> Thanks & Regards,
>>
>>
>>
>> C.G.Kumar
>>
>> --
>>
>> --
>> 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

$$Excel-Macros$$ Capture DATA>From Web

[C.G.Kumar]

Dear All,


I need to capture Current Market Price of given scrip in Excel.I have used
DATA>From Web. But, it difficulty is that it captures entire data and not
only scrip CMP.


Thanks & Regards,



C.G.Kumar

-- 
--
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$$ Conditional Formating

[C.G.Kumar]

Follow the link;


1.http://www.homeandlearn.co.uk/excel2007/excel2007s6p2.html
2.
http://www.free-training-tutorial.com/conditional-formatting.html





On Mon, Sep 6, 2010 at 8:36 AM, Pankaj Kumar wrote:

> Hi all,
>
> i am new in msexcel wanted to learned use of conditional formating,
> cananyone helped me to learned conditional formatting ,,,for a brief example
>
> --
>  *Warm Regards
> Pankaj kumar
> M: 9899816107
> e-mail: rajputpanka...@gmail.com
>rajputpank...@yahoo.in*
> *   rajputpankaj1...@rediffmail.com*
>
>  --
>
> --
> 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$$ extract only product name

[C.G.Kumar]

ANDY,


Could you please explain the use of "^^" in the formula.


Thanks & Regards,


C.G.Kumar

On Wed, Sep 1, 2010 at 5:53 PM, Aindril De  wrote:

> Hi Kalyan,
>
> You can use the following formula in the cell B2 and then copy it down
>
> =LEFT(A2,LEN(A2)-(LEN(A2)-FIND("^^",SUBSTITUTE(A2," ","^^",LEN(A2)
> -LEN(SUBSTITUTE(A2," ",""))
>
> For more info on the above please check:
>
> http://www.eggheadcafe.com/software/aspnet/28074391/need-to-find-first---from-right.aspx
>
> Cheers
> Andy
>
> On Wed, Sep 1, 2010 at 3:41 PM, Kal xcel  wrote:
>
>> Dear Experts,
>>
>> I need a help. I have a list of alpha-numeric string, (Like : Skin Fruits
>> Instant Fairness Fruit Bleach 14gm), all strings are not equal. I want to
>> extract only product name (like: Skin Fruits Instant Fairness Fruit Bleach)
>> from that string.
>>
>> File is attached.
>>
>> Thanks in advance
>>
>> Kalyan
>>
>> --
>>
>> --
>> 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$$ Top Poster of the month :- Dave Bonallack

[C.G.Kumar]

Congrats Dave. I wish you will continue to do this in coming months too and
enrich our group forum.


Regards,

C.G.Kumar

On Fri, Sep 3, 2010 at 10:31 AM, Ayush  wrote:

> Hi Group,
>
> I am glad to announce that Dave Bonallack has topped in posting for
> the month of Aug'10 with 67 Posts (9% of group posts). He has done it
> repetitively for two months. Thank you , Dave
>
> I encourage you all to make your contribution by sharing tip , tricks
> and solutions. This is your group and you have to make it happening
> group.
>
> Hi Dave ,
> Many Many thanks for all your voluntary contribution and keeping this
> group active and alive by your solutions.
> Keep up the good work.
>
> Thanks again.
>
> Best regards,
> Ayush Jain
> Group Manager.
>
> --
>
> --
> 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$$ IF(OR(ISERROR challenge

[C.G.Kumar]

Kindly attach sample file.

On Wed, Sep 1, 2010 at 12:12 AM, Kurt  wrote:

> Can't seem to get this working.
>
> If A1 is a calculated error (e.g., #NULL) OR If A1 = "--- ", make
> B1 = "NA"
>
> Otherwise: If A1 < Y1, make B1 = "!", otherwise make B1 = "" (i.e.,
> blank).
>
> This is what I have in B1, but it always returns a #NULL error.
>
> =IF(OR(ISERROR(A1),A1="---"),"NA",IF(A1
> I also tried
>
> =IF(ISERROR(A1),"NA",IF(A1="---","NA",IF(A1
> ... but that returns "NA" every time.
>
> Any ideas? Thanks.
>
> --
>
> --
> 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$$ Debit Note Format in Excel

[C.G.Kumar]

On Tue, Aug 31, 2010 at 11:41 AM, C.G.Kumar wrote:

> Dear All,
>
>
> Debit note format in excel is required. If any one has kindly forward.
>
> Thanks & Regards,
>
> C.G.Kumar
>
> --
>
> --
> 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

$$Excel-Macros$$ Debit Note Format in Excel

[C.G.Kumar]

Dear All,


Debit note format in excel is required. If any one has kindly forward.

Thanks & Regards,

C.G.Kumar

-- 
--
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$$ Need help deleted column in excell sheet

[C.G.Kumar]

In my opinion, data lost.

On Fri, Aug 27, 2010 at 6:54 AM, Idhrees Mohamed wrote:

> Dear guys,
>
>
>
>  I have a excel sheet with big data. Its contain one date column
> unfortunately I delete and save it. It’s possible to recover that
> column.
>
>
>
>  Thanks in Advance.
>
>
>
>  Regards,
>
>  Idhrees.
>
> --
> Thanks & Regards,
>
> Mohamed Idhrees. 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
>

-- 
--
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$$ Help in Separate the Num & Alpha in a cell into another two cells

[C.G.Kumar]

Could you please attach sample file.

Thanks & Regards,


C.G.Kumar


On Fri, Aug 27, 2010 at 10:21 AM, Ankit Agrawal
wrote:

> Hello Sir,
>
> I have a data in which a column having the both numeric and alphabetically
> value but i want to separate these value into two column or two cells, is it
> possible in the excel if yes how can it possible? basically it is in the
> Price column and it having unit name also. so i want to separate in unit
> name and the price.
>
> plz consider it and tell me.
>
> Thanks to you all.
>
> Ankit Agrawal
>
> --
>
> --
> 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$$ hi

[C.G.Kumar]

Press F1 Key and see the examples.

On Fri, Aug 27, 2010 at 10:54 AM, Pankaj Kumar wrote:

> Hi,
>
> Can anyone help me to understand what is Vlookup & Hlookup,for a short
> example how to use it ,,
>
> --
> *Warm Regards
> Pankaj kumar
> M: 9899816107
> e-mail: rajputpanka...@gmail.com
>rajputpank...@yahoo.in*
>
>  --
>
> --
> 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