date:20130114

$$Excel-Macros$$ GETTING MINIMUM NO HIGHLIGHTED

2013-01-14 Thread Amit Gandhi

-- Forwarded message --
From: Amit Gandhi 
Date: Tue, Jan 15, 2013 at 1:07 PM
Subject: $$Excel-Macros$$
To: excel-macros@googlegroups.com

Hi Experts

I have some data and I have get minimum no out of that by MIN formula. Now
I want a formula or VBA macro to do following.

1. Minimum of column D, H, L  gets highlighted as shown above.
2. Minimum's name is mentioned against each cell in column O.

Pls see sample file attached.

Pls help me here.

Regards

Amit

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

-- 
'Expecting the world to treat u fairly coz u r a good person is like
expecting the lion not to attack u coz u r a vegetarian.
Think about it.'

Take care

Amit

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

GETTING MINIMUM NO.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

$$Excel-Macros$$ Re: Need Formula

2013-01-14 Thread Prince

Hi Prabhakar,

paste the following formula.

=SUMIFS(C2:C10,A2:A10,"Fax",B2:B10,"Brown")

Regards
Prince

On Tuesday, January 15, 2013 12:40:13 PM UTC+5:30, Prabhakar S H wrote:
>
> Dear Team,
>  
> I need to get formula for attached file. Pls help.
>  
> Rgds,
> Prabhakar
>

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

$$Excel-Macros$$

2013-01-14 Thread Amit Gandhi

Hi Experts

I have some data and I have get minimum no out of that by MIN formula. Now
I want a formula or VBA macro to do following.

1. Minimum of column D, H, L  gets highlighted as shown above.
2. Minimum's name is mentioned against each cell in column O.

Pls see sample file attached.

Pls help me here.

Regards

Amit

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




GETTING MINIMUM NO.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Re: Mandatory Cell Entry

2013-01-14 Thread pankaj gmail account

Dear Gurus

Please help.

Regards,
Pnkaj

On Thu, Jan 10, 2013 at 5:10 PM, Prince  wrote:

> Ok Pankaj
> i can only reply in evening.
>
> regards
> Prince
>
>
> On Thursday, January 10, 2013 5:02:06 PM UTC+5:30, Pankaj wrote:
>
>>  Don't use differnt mails.
>>
>> REgards,
>> Pankaj
>>
>>  On Thu, Jan 10, 2013 at 2:22 PM, Prabhakar S H wrote:
>>
>>>  Hi Prince,
>>>
>>> Its not working.
>>>
>>> Can you send me example with this formula.
>>>
>>> Rgds,
>>> Prabhakar
>>>
>>> On Sunday, January 6, 2013 9:33:55 AM UTC+5:30, Prince wrote:
>>>
 yes it is possible, pleas follow the following steps.

 1:DATA Tab->Data validation->Data validation->Select *Custom *in allow
 section-> In formula box Write *=A1<>"" *->Select *Error alert tab* on
 same popup
 ->in Style select *stop*->in error message option give your message->
 And at last* OK*


 That's All

 Regards
 Prince

 On Saturday, January 5, 2013 9:10:29 AM UTC+5:30, Pankaj wrote:
>
> Dear Gurus
>
> I want to make a excel data entry form in which i want some cells to
> be mandatory and some can be left out. But with sequence
>
> Like
>
> Name (Mandatory)
> Address (Mandatory)
> Phone ( not mandatory)
>
> *first field entry should be name, he cannot move to phone directly
> until name is filled. is it possible in Excel?
> *--
>
> Thanks
> Pankaj Kumar
> 9910075248
>
 --
>>> 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-...@googlegroups.com.
>>> To unsubscribe from this group, send email to excel-macros...@**
>>> googlegroups.com.
>>>
>>> Visit this group at 
>>> http://groups.google.com/**group/excel-macros?hl=en
>>> .
>>>
>>>
>>>
>>
>>
>>
>> --
>>
>> Thanks
>> Pankaj Kumar
>> 9910075248
>>
>  --
> 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.
>
>
>



-- 

Thanks
Pankaj Kumar
9910075248

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

$$Excel-Macros$$ Need Formula

2013-01-14 Thread Prabhakar S H

Dear Team,
 
I need to get formula for attached file. Pls help.
 
Rgds,
Prabhakar

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




Formula Require.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Re: Excel Query

2013-01-14 Thread ravinder negi

Hi, 
Please check Auto correct option in Excel, you can find ti in 
"File-->Options-->Proofing-->AutoCorrrect Option
you will get 125 replaced with 255, delete that using delete tab (click).
Please advise if this solve you query.
thanks & RegardsRavinder Negi

--- On Tue, 1/15/13, venus  wrote:

From: venus 
Subject: Re: $$Excel-Macros$$ Re: Excel Query
To: excel-macros@googlegroups.com
Date: Tuesday, January 15, 2013, 4:34 AM

Hi,
We are facing problem only when we input 125 and result is showing as 225.
And for other values there is no such issues we have faced yet.
And this issue is arising only on excel application and on all workbooks that 
are being opened on particular system.

Regards,
Vikram Ahuja

On Mon, Jan 14, 2013 at 1:10 AM, David Grugeon  wrote:

Hi Vikram
Is it only the particular value 125 that gets changed?  For example if you put 
124, does that become 224?

Does this problem arise on every workbook on the system?

Does it arise in other program's or only in excel?

On Monday, 14 January 2013, venus  wrote:


Hi,
I am not getting this error with any particular error but this is happening on 
particular system.
Regards,
Vikram

On Sun, Jan 13, 2013 at 6:20 PM, Prince  wrote:



Hi Vikram,
Please Share your workbook.
RegardsPrince

On Saturday, January 12, 2013 9:30:45 PM UTC+5:30, vic kumar wrote:


Hi,
I need some information regarding excel where in one of the instance whenever 
we input 125 and press enter we are getting 225 as result.
We have tried a lot to identify reason for this query but not able get 
resolution.




As a result user is not able to input 125 whenever required on excel sheet and 
we have tried to open new workbook as well but not able to clear with this 
query yet.
Kindly help in this regard.





-- 
Regards,

Vikram Ahuja





-- 

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,

Vikram Ahuja




-- 

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.

 

 



-- 
RegardsDavid Grugeon




-- 

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...@googleg

$$Excel-Macros$$ Re: Parts search with filters using a macro

2013-01-14 Thread Prince

Hi Dan,

Try below mentioned code may if it can help you. replace your "searchpart" 
macro with one that i have provided.

 
Sub searchparts()
'
' searchparts Macro
'
' Keyboard Shortcut: Ctrl+s
'
Columns("A:A").Select
Selection.AutoFilter
Selection.AutoFilter
strname = InputBox("enter text", "search collector")
ActiveSheet.Range("$A$1:$A$4411").AutoFilter Field:=1, Criteria1:="*" & 
strname & "*"
End Sub


Regards
Prince



On Tuesday, January 15, 2013 1:15:44 AM UTC+5:30, Dan Nichols wrote:
>
> I am using the following macro to search a parts list
> I have 3 columns.
>  
> Column A is the description
> Column B is the Part location 
> Column C is the Part #
>  
> If I use the manual method to filter my parts by any given description in 
> column A. Lets say "bearing" by using the sort filter button,and then "text 
> filters" I get a very long list of items matching the word "bearing" within 
> the description column A
> If I use the macro that I created that is listed below and use the word 
> "bearing" in the input box I only get maybe 3 or 4 items that match the 
> word "bearing" in the description in column A
> If anyone can help me sort this Out I would appreciate it greatly.
> Below is my Macro.
>  
>  
>  
> Sub searchparts()
> '
> ' searchparts Macro
> '
> ' Keyboard Shortcut: Ctrl+s
> '
> Columns("A:A").Select
> Selection.AutoFilter
> Selection.AutoFilter
> strname = InputBox("enter text", "search collector")
> ActiveSheet.Range("$A$1:$A$4411").AutoFilter Field:=1, 
> Criteria1:=strname
> End Sub
>

-- 
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$$ Parts search with filters using a macro

2013-01-14 Thread koul . ashish

Are you selecting contains option manually?

Regards
Ashish 
Sent on my BlackBerry® from Vodafone

-Original Message-
From: Dan Nichols 
Sender: excel-macros@googlegroups.com
Date: Mon, 14 Jan 2013 11:45:44 
To: 
Reply-To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Parts search with filters using a macro

I am using the following macro to search a parts list
I have 3 columns.

Column A is the description
Column B is the Part location 
Column C is the Part #

If I use the manual method to filter my parts by any given description in 
column A. Lets say "bearing" by using the sort filter button,and then "text 
filters" I get a very long list of items matching the word "bearing" within 
the description column A
If I use the macro that I created that is listed below and use the word 
"bearing" in the input box I only get maybe 3 or 4 items that match the 
word "bearing" in the description in column A
If anyone can help me sort this Out I would appreciate it greatly.
Below is my Macro.

Sub searchparts()
'
' searchparts Macro
'
' Keyboard Shortcut: Ctrl+s
'
Columns("A:A").Select
Selection.AutoFilter
Selection.AutoFilter
strname = InputBox("enter text", "search collector")
ActiveSheet.Range("$A$1:$A$4411").AutoFilter Field:=1, 
Criteria1:=strname
End Sub

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

Re: $$Excel-Macros$$ Re: Excel Query

2013-01-14 Thread venus

Hi,

We are facing problem only when we input 125 and result is showing as 225.

And for other values there is no such issues we have faced yet.

And this issue is arising only on excel application and on all workbooks
that are being opened on particular system.

Regards,

Vikram Ahuja

On Mon, Jan 14, 2013 at 1:10 AM, David Grugeon  wrote:

> Hi Vikram
>
> Is it only the particular value 125 that gets changed?  For example if you
> put 124, does that become 224?
>
> Does this problem arise on every workbook on the system?
>
> Does it arise in other program's or only in excel?
>
>
> On Monday, 14 January 2013, venus wrote:
>
>> Hi,
>>
>> I am not getting this error with any particular error but this is
>> happening on particular system.
>>
>> Regards,
>>
>> Vikram
>>
>> On Sun, Jan 13, 2013 at 6:20 PM, Prince  wrote:
>>
>>> Hi Vikram,
>>>
>>> Please Share your workbook.
>>>
>>> Regards
>>> Prince
>>>
>>> On Saturday, January 12, 2013 9:30:45 PM UTC+5:30, vic kumar wrote:

 Hi,

 I need some information regarding excel where in one of the
 instance whenever we input 125 and press enter we are getting 225 as 
 result.

 We have tried a lot to identify reason for this query but not able get
 resolution.

 As a result user is not able to input 125 whenever required on excel
 sheet and we have tried to open new workbook as well but not able to clear
 with this query yet.

 Kindly help in this regard.

 --
 Regards,

 Vikram Ahuja

>>>  --
>>> 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,
>>
>> Vikram Ahuja
>>
>> --
>> 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
> David Grugeon
>
>  --
> 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,

Vik

$$Excel-Macros$$ Parts search with filters using a macro

2013-01-14 Thread Dan Nichols

I am using the following macro to search a parts list
I have 3 columns.
 
Column A is the description
Column B is the Part location 
Column C is the Part #
 
If I use the manual method to filter my parts by any given description in 
column A. Lets say "bearing" by using the sort filter button,and then "text 
filters" I get a very long list of items matching the word "bearing" within 
the description column A
If I use the macro that I created that is listed below and use the word 
"bearing" in the input box I only get maybe 3 or 4 items that match the 
word "bearing" in the description in column A
If anyone can help me sort this Out I would appreciate it greatly.
Below is my Macro.
 
 
 
Sub searchparts()
'
' searchparts Macro
'
' Keyboard Shortcut: Ctrl+s
'
Columns("A:A").Select
Selection.AutoFilter
Selection.AutoFilter
strname = InputBox("enter text", "search collector")
ActiveSheet.Range("$A$1:$A$4411").AutoFilter Field:=1, 
Criteria1:=strname
End Sub

-- 
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$$ Macros Cartograms

2013-01-14 Thread Sri Jai

Thank you so much

On Mon, Jan 14, 2013 at 1:22 PM, Anoop K Sharma wrote:

> Hi Jai,
>
> Please find attached file. Look at sheet2, select the country name from
> combo box at upper left corner, use spin button to change the size of shape.
>
> Regards,
> Anoop
>
>
> On Thu, Jan 10, 2013 at 3:57 PM, Sri Jai  wrote:
>
>> Hi Team,
>>
>> I need to write a macro on the attached template Cartogram where I can
>> adjust a value and the size of countries in a map of the world changes (but
>> their vague position stays the same)...
>>
>>
>> Thanks a ton for the help!
>>
>>
>> Sri
>>
>> --
>> 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.

$$Excel-Macros$$ Re: Reposition the cursor in an Excel macro

2013-01-14 Thread andrew . clabon


On Thursday, January 10, 2013 6:33:12 PM UTC, andrew...@tiscali.co.uk 
wrote: 
>
> Swapnil,
>  
> I have been pottering around with the spreadhseet you started for me.  
> I've added a few bits in readiness for passing onto those who would be 
> doing the time recording at the various checkpoints.  I've attached a c 
> copy.   I have passed it onto two friends were who as equally as impressed 
> as I so thank you.
>  
> What is puzzling us is how it works.
> We can't find any macros and we don't have to select anything for the time 
> to appear on sheet 2.
> Without spending too much time can I be really cheeky and ask you how it 
> works?
>  
> We did notice one error mind.  Did you know it exists?
> If you select entrant number 1 his time appears on sheet 2 against entrant 
> number 10.
>  
> Cheers,
>  
> Ollyolly
>  
>  
>  
>  
>  
>
> On Monday, December 17, 2012 10:32:16 AM UTC, ollyolly wrote:
>
>> Swapnil,
>>  
>> Fantastic, just what I needed.  Thank you very much.
>>  
>> Prince, thanks for your efforts, now sorted as you can see.
>>  
>> Cheers,
>>  
>> Ollyolly
>>  
>>  
>>  
>>
>> On Monday, December 17, 2012 9:02:21 AM UTC, ollyolly wrote:
>>
>>> I am looking to write a macro in excel.
>>> I wish to position the cursor on worksheet 2 to automatically enter some 
>>> data.  The row number of the new position is dependant on the value of a 
>>> cell in worksheet 1.
>>> Can anyone tell me how to do this?
>>> Thank you.
>>>
>>

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

$$Excel-Macros$$ Re: Need formula based on 3 condition

2013-01-14 Thread Suyog Kulkarni

Sam,

You understood my problem correctly. I think rather using IF, I think we 
should try for scenario. I don't know much about this.
My conditions are as follows.

1) PL are applicable after 1yr service.
2) Whoever already completed 1yr he/she will get full PL
3) If somebody finishing his 12months between the leave card duration 
should get PL with request to Pro-rata basis

Regards,
Suyog   

On Sunday, 13 January 2013 12:11:20 UTC+5:30, SamJesseK wrote:
>
> Suyog,
>
> It seems that multiple conditions can be met based on certain dates. Can 
> you double check the variables? The conditions must be independent of each 
> other for a multiple IF statement to be valid.
>
> On Sunday, January 13, 2013 1:17:56 AM UTC-5, Suyog Kulkarni wrote:
>>
>> Hello All, 
>>
>> Requesting to help again. I.ve tried IF condition to solve this problem 
>> but failed. I don.t know how to create conditions with multiple If. 
>>
>> With Regards,
>> Suyog
>>
>>

-- 
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$$ formula required

2013-01-14 Thread ravinder negi

Hi Prashant,
Please receive the file with solution, please revert back if you want something 
else.
Thanks

--- On Mon, 1/14/13, Prashant Pawle  wrote:

From: Prashant Pawle 
Subject: $$Excel-Macros$$ formula required
To: excel-macros@googlegroups.com
Date: Monday, January 14, 2013, 12:19 PM

Dear Team,
Need a formula to look up a filed & give sum of figure , sample file attached
Regards,
Prashant

-- 

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.

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

Re: $$Excel-Macros$$ Hey how to recover source data from pivot table .

2013-01-14 Thread अनिल नारायण गवली

dear anoop,

Still the same problem persist. but thanks to reply my query.


Warm Regards,
Gawli Anil

On Mon, Jan 14, 2013 at 3:48 PM, Anoop K Sharma wrote:

> Without refreshing pivot, remove all the filters from the pivot and do the
> same which I had told you earlier.
> If this doesn't work then there is no hope to retrieve all the data.
>
> Good luck
>
>
>
> On Mon, Jan 14, 2013 at 2:16 PM, अनिल नारायण गवली  > wrote:
>
>> dear ,
>> But it only shows that much data the field which i have clicked .  I want
>> all the data.
>>
>> Warm Regards,
>> Gawli Anil
>>
>> On Mon, Jan 14, 2013 at 12:19 PM, Anoop K Sharma 
>> wrote:
>>
>>> If you have pivot table existed there then double click on the grand
>>> total value. You can extract the pivot cache data from there.
>>>
>>> Regards,
>>> Anoop
>>>
>>>
>>> On Mon, Jan 14, 2013 at 12:05 PM, अनिल नारायण गवली <
>>> gawlianil8...@gmail.com> wrote:
>>>
 Dear All,

 actually my bro has deleted the source data. befor he has deleted i had
 made a pivot table after that he deleted the souce data.
 Now i want that data back .  is there any solutions.



 --
 Thanks & Regards,
 Gawli Anil Narayan
 Software Developer,
 Abacus Software Services Pvt Ltd

 --
 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.
>>>
>>>
>>>
>>
>>
>>
>> --
>> Thanks & Regards,
>> Gawli Anil Narayan
>> Software Developer,
>> Abacus Software Services Pvt Ltd
>>
>> --
>> 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.

Re: $$Excel-Macros$$ Hey how to recover source data from pivot table .

2013-01-14 Thread Anoop K Sharma

Without refreshing pivot, remove all the filters from the pivot and do the
same which I had told you earlier.
If this doesn't work then there is no hope to retrieve all the data.

Good luck



On Mon, Jan 14, 2013 at 2:16 PM, अनिल नारायण गवली
wrote:

> dear ,
> But it only shows that much data the field which i have clicked .  I want
> all the data.
>
> Warm Regards,
> Gawli Anil
>
> On Mon, Jan 14, 2013 at 12:19 PM, Anoop K Sharma 
> wrote:
>
>> If you have pivot table existed there then double click on the grand
>> total value. You can extract the pivot cache data from there.
>>
>> Regards,
>> Anoop
>>
>>
>> On Mon, Jan 14, 2013 at 12:05 PM, अनिल नारायण गवली <
>> gawlianil8...@gmail.com> wrote:
>>
>>> Dear All,
>>>
>>> actually my bro has deleted the source data. befor he has deleted i had
>>> made a pivot table after that he deleted the souce data.
>>> Now i want that data back .  is there any solutions.
>>>
>>>
>>>
>>> --
>>> Thanks & Regards,
>>> Gawli Anil Narayan
>>> Software Developer,
>>> Abacus Software Services Pvt Ltd
>>>
>>> --
>>> 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.
>>
>>
>>
>
>
>
> --
> Thanks & Regards,
> Gawli Anil Narayan
> Software Developer,
> Abacus Software Services Pvt Ltd
>
> --
> 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 regard

Re: $$Excel-Macros$$ Hey how to recover source data from pivot table .

2013-01-14 Thread अनिल नारायण गवली

dear ,
But it only shows that much data the field which i have clicked .  I want
all the data.

Warm Regards,
Gawli Anil

On Mon, Jan 14, 2013 at 12:19 PM, Anoop K Sharma wrote:

> If you have pivot table existed there then double click on the grand total
> value. You can extract the pivot cache data from there.
>
> Regards,
> Anoop
>
>
> On Mon, Jan 14, 2013 at 12:05 PM, अनिल नारायण गवली <
> gawlianil8...@gmail.com> wrote:
>
>> Dear All,
>>
>> actually my bro has deleted the source data. befor he has deleted i had
>> made a pivot table after that he deleted the souce data.
>> Now i want that data back .  is there any solutions.
>>
>>
>>
>> --
>> Thanks & Regards,
>> Gawli Anil Narayan
>> Software Developer,
>> Abacus Software Services Pvt Ltd
>>
>> --
>> 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.
>
>
>



-- 
Thanks & Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd

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

$$Excel-Macros$$ GETTING MINIMUM NO HIGHLIGHTED

$$Excel-Macros$$ Re: Need Formula

$$Excel-Macros$$

Re: $$Excel-Macros$$ Re: Mandatory Cell Entry

$$Excel-Macros$$ Need Formula

Re: $$Excel-Macros$$ Re: Excel Query

$$Excel-Macros$$ Re: Parts search with filters using a macro

Re: $$Excel-Macros$$ Parts search with filters using a macro

Re: $$Excel-Macros$$ Re: Excel Query

$$Excel-Macros$$ Parts search with filters using a macro

Re: $$Excel-Macros$$ Macros Cartograms

$$Excel-Macros$$ Re: Reposition the cursor in an Excel macro

$$Excel-Macros$$ Re: Need formula based on 3 condition

Re: $$Excel-Macros$$ formula required

Re: $$Excel-Macros$$ Hey how to recover source data from pivot table .

Re: $$Excel-Macros$$ Hey how to recover source data from pivot table .

Re: $$Excel-Macros$$ Hey how to recover source data from pivot table .

17 matches

Site Navigation

Mail list logo

Footer information