date:20140512

Re: $$Excel-Macros$$ Macro required

2014-05-12 Thread Vaibhav Joshi

This is really cool...

Cheers!!


On Sun, May 11, 2014 at 10:24 PM, Bé Trần Văn wrote:

> TEAR SHEET: Press the button "Separation sheet and name".
>
> ELIMINATION OF SHEET: Press the button "Delete sheet detached".
>
>
>
>
>
> 2014-05-07 14:12 GMT+07:00 Shrinivas Shevde :
>
>  Very very thanks
>>
>>
>> On Wed, May 7, 2014 at 11:27 AM, Vaibhav Joshi  wrote:
>>
>>> Hi
>>>
>>> Yes you can paste data in master file below the existing data. However
>>> you can test data.
>>>
>>>
>>> Thanks
>>>
>>>
>>> On Wed, May 7, 2014 at 11:25 AM, Shrinivas Shevde <
>>> shrinivas...@gmail.com> wrote:
>>>
  Dear Vaibhav

 Really nice and lots of thanks
 Small query.I will get data on daily basis as i said earlier so shall i
 copy paste data below the current data in data sheet.

 Regards
 Shrinivas



 On Tue, May 6, 2014 at 11:19 PM, Vaibhav Joshi  wrote:

> Hey
>
> Check out this..
>
> Cheers!!
>
>
> On Mon, May 5, 2014 at 3:51 PM, Shrinivas Shevde <
> shrinivas...@gmail.com> wrote:
>
>>
>> Dear all
>>
>> I am getting a data on daily basis.In which there are various items
>> and items code.Item code is changing on daily basis.I have to make 
>> itemwise
>> sheet an dneeds to copy paste the items code.
>> Is it possible to write a code so that wheneve i clicked on a button
>> all items code wil go to corresponding sheet.if the sheet is not 
>> available
>> for particular item then it will create a new sheet.
>> Sample file attached
>> I have items like A,B ,C and having corresponding code
>> For Eg For A item today item code is 1,2,3,9,13,Tomorrow I will get
>> different data and item code may be 27,25
>>
>> --
>> Shrini
>>
>> --
>> 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.
>



 --
 Shrini

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

Re: $$Excel-Macros$$ doc compare vba

2014-05-12 Thread Vaibhav Joshi

which version of MS-Office you are using?


On Sat, May 10, 2014 at 12:32 PM, Arindam Das  wrote:

>
>
> I got stuck at one place.If I compare 2 documents entirely(not page by
> page) how will I get the page numbers where we have the discrepancies.In
> the below mentioned code I want the page number to be return which are not
> matching with each other.I tried it but I failed.
>
> dim temp as string
>
> dim temp1 as string
>
> Set objWord = CreateObject("Word.Application")
> Set objDoc = objWord.Documents.Open("C:\Users\Arindam\Desktop\b.docx")
>
> temp = objDoc.Range(0, objDoc.Range.End)
>
> objWord.Quit
> Dim objword1 As Object
> Set objword1 = CreateObject("Word.Application")
> Set objDoc1 = objword1.Documents.Open("C:\Users\Arindam\Desktop\a.docx")
> temp1 = objDoc1.Range(0, objDoc1.Range.End)
>
> objword1.Quit
> If temp = temp1 Then
> MsgBox "Matched", vbInformation
> Else
> MsgBox "Not Matched", vbInformation
> End If
>
> --
> 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$$ PivotTable_Calculated Field

2014-05-12 Thread Vaibhav Joshi

Hi

Refer: http://www.contextures.com/excel-pivot-table-calculated-field.html

CHeers!!


On Mon, May 12, 2014 at 7:08 PM, Chandra Shekar <
chandrashekarb@gmail.com> wrote:

> Hi,
>
> How to add calculated field in the attached file here I need to calculate
> Grand Total/Y.
>
> Thanks in advance.
>
> Regards,
>
> Chandra
>
> --
> 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.

$$Excel-Macros$$ Hide and Unhide

2014-05-12 Thread googley

I have three similar products with a yes, no list that when anyone of the 
three is yes the following formula changes CELL I9 to yes or no and hides 
or unhides rows on a proposal. Those yes , no cells F15,F23,F31 also hide, 
unhide single row entries that describe those products. This currently does 
not work, I know there's a simpler way of doing this hopefully with VBA.

IN cell I9 I have 
=IF(COUNTIF(F15:F31,"yes")>=1,"yes",IF(COUNTIF(F15:F31,"no")=3,"no",""))

Case "I9"
.Rows("78:84").Hidden = LCase(Target) = "no"
Case "I9"
.Rows("78:84").UnHidden = LCase(Target) = "yes"

Case "F15"
.Rows("53").Hidden = LCase(Target) = "no"
Case "F15"
.Rows("53").UnHidden = LCase(Target) = "yes"
Case "F23"
.Rows("54").Hidden = LCase(Target) = "no"
Case "F23"
.Rows("54").UnHidden = LCase(Target) = "yes"
Case "F31"
.Rows("55").Hidden = LCase(Target) = "no"
Case "F31"
.Rows("55").UnHidden = LCase(Target) = "yes"

-- 
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$$ E book related..

2014-05-12 Thread Renukachari Kasee

Dear Group,


any one please provide the ebook for excel macros

i.e.  101 READY-TO-USE EXCEL MACROS by Michael Alexander , John Walkenbach


(Thanks & Regards´¨)
  ¸ •´ ¸.•*´¨)   ¸.•*¨)
 (¸.•´  (¸.•*  ♥♥♥...♪♪♪RenukaChari. Kasee...♥♥♥...♪♪♪

P Let us do our best to save nature, save water, plant trees, protect
greenery, keep our surroundings clean, reduce usage of plastics, and
use renewable energy sources.

-- 
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$$ PivotTable_Calculated Field

2014-05-12 Thread Amit Desai (MERU)

Hi

Does this also work on column containing Non-Numeric data?

Regards,
Amit
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
Behalf Of Vaibhav Joshi
Sent: 05-Mon-2014 19:43
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ PivotTable_Calculated Field

Hi

Refer: http://www.contextures.com/excel-pivot-table-calculated-field.html

CHeers!!

On Mon, May 12, 2014 at 7:08 PM, Chandra Shekar 
mailto:chandrashekarb@gmail.com>> wrote:
Hi,

How to add calculated field in the attached file here I need to calculate Grand 
Total/Y.

Thanks in advance.

Regards,

Chandra
--
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.
Disclaimer: This message and its attachments contain confidential information 
and may also contain legally privileged information. This message is intended 
solely for the named addressee. If you are not the addressee indicated in this 
message (or authorized to receive for addressee), you may not copy or deliver 
any part of this message or its attachments to anyone or use any part of this 
message or its attachments. Rather, you should permanently delete this message 
and its attachments (and all copies) from your system and kindly notify the 
sender by reply e-mail. Any content of this message and its attachments that 
does not relate to the official business of Meru Cab Company Pvt. Ltd. must be 
taken not to have been sent or endorsed by any of them. Email communications 
are not private and no warranty is made that e-mail communications are timely, 
secure or free from computer virus or other defect.

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

Re: $$Excel-Macros$$ Macro required

Re: $$Excel-Macros$$ doc compare vba

Re: $$Excel-Macros$$ PivotTable_Calculated Field

$$Excel-Macros$$ Hide and Unhide

$$Excel-Macros$$ E book related..

RE: $$Excel-Macros$$ PivotTable_Calculated Field

6 matches

Site Navigation

Mail list logo

Footer information