RE: [bulk] $$Excel-Macros$$ Query related to subtotal and condition

[Siraj Momin (BTG)]

 

PFA

 

Best Regards

 

 

Momin Siraj Ahmad

 

From: excel-macros@googlegroups.com
[mailto:excel-macros@googlegroups.com] On Behalf Of L.K. Modi
Sent: 12 November 2011 10:39 AM
To: excel-macros@googlegroups.com
Subject: [bulk] $$Excel-Macros$$ Query related to subtotal and condition
Importance: Low

 

Dear All members,

I am attaching herewith a file regarding tds and the requirement is
mention in that file related to subtotal and conditions. Please solve my
problem . Thanks to all in advance


Regards
LKModi
9309243685

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


TDS 2011-12.xlsx
Description: TDS 2011-12.xlsx

Re: $$Excel-Macros$$ Query related to subtotal and condition

[Aindril De]

Dear Mr. Modi,

Attached is the soln. pl chk if this is ok.

Regards,
Andy

On Sat, Nov 12, 2011 at 12:09 PM, L.K. Modi  wrote:

> Dear All members,
>
> I am attaching herewith a file regarding tds and the requirement is
> mention in that file related to subtotal and conditions. Please solve my
> problem . Thanks to all in advance
>
>
> Regards
> LKModi
> 9309243685
>
>  --
> 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
>



-- 

Warm Regards,
Aindril De
Ph: 9811300157

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


TDS 2011-12-Modi.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

$$Excel-Macros$$ Query related to subtotal and condition

[L.K. Modi]

Dear All members,

I am attaching herewith a file regarding tds and the requirement is mention
in that file related to subtotal and conditions. Please solve my problem .
Thanks to all in advance


Regards
LKModi
9309243685

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


TDS 2011-12.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

$$Excel-Macros$$ Links do not work anymore..

[J]

Hi,

What happended to the links in these summary mails with excellent q&a's.
Like "...more" that used to contain those links???

Regards, Jørgen Bugge, Norway

Sent from my iPad

-- 
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$$ SUM Reg.

[Sourabh Salgotra]

plz tell me that what's the meaning of* -- *in fourmula

=SUMPRODUCT(*--*($D$2:$D$21=D22)*($E$2:$E$21))



On Sat, Nov 12, 2011 at 10:11 AM, jmothilal  wrote:

> THANKS SO MUCH , ITS WORKING FINE  GET THE RESULTS.
>
> THANKS WITH
>
> MOTHILAL.J
>
> On Fri, Nov 11, 2011 at 10:31 PM, NOORAIN ANSARI  > wrote:
>
>> Dear Mothilal,
>>
>> try this one..
>> =SUMPRODUCT(--($D$2:$D$21=D22)*($E$2:$E$21))
>> On Fri, Nov 11, 2011 at 8:23 PM, jmothilal  wrote:
>>
>>> DEAR EXCEL MEMBERS ,
>>>
>>> I WANT TO SUM OF  SPECIFIED ROWS , HERE WITH I ATTACHED FILES.  I.E
>>> STOCK , SALES.
>>>
>>> THANKS WITH
>>>
>>>
>>>
>>> --
>>> J.Mohilal
>>> Universal Computer Systems
>>> # 16, Brindavan Complex
>>> Otteri, Vellore-2
>>>
>>> --
>>> FORUM RULES (934+ members already BANNED for violation)
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>>
>>> 2) Don't post a question in the thread of another member.
>>>
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>>
>>> 4) Acknowledge the responses you receive, good or bad.
>>>
>>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>>
>>>
>>> --
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>
>>
>>
>> --
>> Thanks & regards,
>> Noorain Ansari
>>  *http://excelmacroworld.blogspot.com/*
>> *http://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
>>
>
>
>
> --
> J.Mohilal
> Universal Computer Systems
> # 16, Brindavan Complex
> Otteri, Vellore-2
>
> --
> 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
>



-- 
mujhay dukh is baat ka nahin kay meri zaat ko
muntashir karny walay haath tairy thy
mujhay dukh faqt is baat ka hay meri raiza raiza zaat ko
samaitnay walay haath tairy na thy





Thanks & Regards
Sourabh
Contact Numbers: +91-94630-49202
Website:http://adhurapyaar.co.cc

-- 
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$$ SUM Reg.

[jmothilal]

THANKS SO MUCH , ITS WORKING FINE  GET THE RESULTS.

THANKS WITH

MOTHILAL.J

On Fri, Nov 11, 2011 at 10:31 PM, NOORAIN ANSARI
wrote:

> Dear Mothilal,
>
> try this one..
> =SUMPRODUCT(--($D$2:$D$21=D22)*($E$2:$E$21))
> On Fri, Nov 11, 2011 at 8:23 PM, jmothilal  wrote:
>
>> DEAR EXCEL MEMBERS ,
>>
>> I WANT TO SUM OF  SPECIFIED ROWS , HERE WITH I ATTACHED FILES.  I.E STOCK
>> , SALES.
>>
>> THANKS WITH
>>
>>
>>
>> --
>> J.Mohilal
>> Universal Computer Systems
>> # 16, Brindavan Complex
>> Otteri, Vellore-2
>>
>> --
>> FORUM RULES (934+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>
>
> --
> Thanks & regards,
> Noorain Ansari
>  *http://excelmacroworld.blogspot.com/*
> *http://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
>



-- 
J.Mohilal
Universal Computer Systems
# 16, Brindavan Complex
Otteri, Vellore-2

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

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

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

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

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

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

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

$$Excel-Macros$$ Re: Help on Indirect Formula

[Haseeb Avarakkan]

Hello JP, Please do not post multiple thread for the same query.
 
In Summary B4, copy down & across.
 
=LOOKUP(9E+300,INDIRECT("'"&$A4&"'!B1:"&ADDRESS(2^20,COLUMNS($A4:B4
 
__
HTH
Haseeb

-- 
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$$ Help Required.xlsx

[Haseeb Avarakkan]

Hello Noorie & Sam;
 
Good ones, but as you know, If a site has LARGE date more than 1 (*not sure 
does the OP have this situation or not*), this wouldn't work as 
expected. I think the attached would work.
 
__
HTH
Haseeb

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


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

Re: $$Excel-Macros$$ Help Required.xlsx

[Sam Mathai Chacko]

Can be done without CSE formula

Here's an example

Regards,
Sam

On Fri, Nov 11, 2011 at 6:52 PM, dguillett1  wrote:

>   In this particular sample you can simply filter by date. However, that
> may not be what you need in all cases??
>
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
>
>  *From:* NOORAIN ANSARI 
> *Sent:* Friday, November 11, 2011 4:04 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Help Required.xlsx
>
>  Dear Neeraj,
>
> Please try through below formula, See attached sheet..
>
>
> =OFFSET($D$1,SMALL(IF($B$2:$B$24=$I2,ROW($D$2:$D$24),""),COUNTIF($I$2:$I2,$I2))-1,0)
> Press ctrl+shift+enter
>
> --
> Thanks & regards,
> Noorain Ansari
>  *http://excelmacroworld.blogspot.com/*
> *http://noorain-ansari.blogspot.com/*
>
> On Fri, Nov 11, 2011 at 2:12 PM, Neeraj Chauhan <
> neerajchauhan...@gmail.com> wrote:
>
>>  Dear Experts,
>>
>> 
>>
>> Kindly find the attached sheet.
>>
>> I want to only last date qty and stock in three sites.
>> --
>> FORUM RULES (934+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>
>
> --
> FORUM RULES (934+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> --
> FORUM RULES (934+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
Sam Mathai Chacko

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


Help Required(Solved).xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Indirect Formula - Need Advise

[Haseeb Avarakkan]

Hello JP,
 
In Summary B4, copy down & across.
 
=LOOKUP(9E+300,INDIRECT("'"&$A4&"'!B1:"&ADDRESS(2^20,COLUMNS($A4:B4
 
__
HTH
Haseeb

-- 
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$$ SUM Reg.

[NOORAIN ANSARI]

Dear Mothilal,

try this one..
=SUMPRODUCT(--($D$2:$D$21=D22)*($E$2:$E$21))
On Fri, Nov 11, 2011 at 8:23 PM, jmothilal  wrote:

> DEAR EXCEL MEMBERS ,
>
> I WANT TO SUM OF  SPECIFIED ROWS , HERE WITH I ATTACHED FILES.  I.E STOCK
> , SALES.
>
> THANKS WITH
>
>
>
> --
> J.Mohilal
> Universal Computer Systems
> # 16, Brindavan Complex
> Otteri, Vellore-2
>
> --
> FORUM RULES (934+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
Thanks & regards,
Noorain Ansari
 *http://excelmacroworld.blogspot.com/*
*http://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


Book2(Solved).xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Calling multiple type subroutines

[Sam Mathai Chacko]

Jack, but you wouldn't need the calculate routine, would you. The change
routine would take care of both the hiding or rows, as well as the picture
being visible...

I would however tentatively add a line in there

Private Sub Worksheet_Change(ByVal Target As Range)

Dim oPic As Picture

Application.EnableEvents=False
If Target.Address = "B3" Then
Select Case Target.Value
Case Is = "DSL-Cleaner"
Rows("1:156").Hidden = False
Rows("157:208").Hidden = True
Rows("209:256").Hidden = False
Case Is = "DSN-DSL Cleaner"
Rows("1:256").Hidden = False
End Select

Me.Pictures.Visible = False
With Target

For Each oPic In Me.Pictures
If oPic.Name = .Text Then
oPic.Visible = True
oPic.Top = .Top
oPic.Left = .Left
Exit For
End If
Next oPic
End With

End If
Application.EnableEvents=True
End Sub

Sam Mathai Chacko

On Fri, Nov 11, 2011 at 9:46 PM, Sam Mathai Chacko wrote:

> I believe you can merge it like this
>
>
> Private Sub Worksheet_Change(ByVal Target As Range)
>
> Dim oPic As Picture
>
>
> If Target.Address = "B3" Then
> Select Case Target.Value
> Case Is = "DSL-Cleaner"
> Rows("1:156").Hidden = False
> Rows("157:208").Hidden = True
> Rows("209:256").Hidden = False
> Case Is = "DSN-DSL Cleaner"
> Rows("1:256").Hidden = False
> End Select
>
> Me.Pictures.Visible = False
> With Target
>
> For Each oPic In Me.Pictures
> If oPic.Name = .Text Then
> oPic.Visible = True
> oPic.Top = .Top
> oPic.Left = .Left
> Exit For
> End If
> Next oPic
> End With
>
> End If
>
> End Sub
>
> Regards,
>
> Sam Mathai Chacko
>
>
> On Fri, Nov 11, 2011 at 1:57 PM, Asa Rossoff  wrote:
>
>> Hi Jack,
>>
>> ** **
>>
>> Does cell B3 contain a formula or are you entering a value directly?
>>
>> ** **
>>
>> The Worksheet_Change event is triggered by changes that result from
>> direct entry.
>>
>> The Worksheet_Calculate event is triggered by worksheet calculation.  If
>> there is a formula in B3, it will never be the "Target" in a
>> Worksheet_Change event, although any time it's resultant value changes (and
>> even more often than that, most likely), you would get a
>> Worksheet_Calculate event.
>>
>> ** **
>>
>> Also, in your original post, the Worksheet_Change event you posted had a
>> couple of potential problems that I noticed:
>>
>> ** **
>>
>> (1) The subroutine declaration was commented out with a single
>> apostrophe.   The event would be disabled like that, and the VBA code
>> without a Sub or Function declaration, and especially with an End Sub at
>> the end, would most likely confuse VBA.
>>
>> ** **
>>
>> (2) You have the statement:
>>
>> If Target.Address = "B3" Then 
>>
>> ** **
>>
>> Since more than one cell can change at one time (copy/paste, fill, ?),
>> the Address property will refer to all of the changed cells.  Also, The
>> .Address property will never = "B3".  It could = "$B$3" though.
>>
>> ** **
>>
>> The usual way of checking if a particular cell was changed in the
>> Worksheet_Change event is to see if the cell intersects with Target:
>>
>> If Not Application.Intersect(Range("B3"), Target) Is Nothing Then ***
>> *
>>
>> ** **
>>
>> (3) You have the statement:
>>
>> Select Case Target.Value
>>
>> Case Is = "DSL-Cleaner"
>>
>> 
>>
>> ** **
>>
>> If Target is a range of more than one cell, comparing Target.Value to a
>> string will result in a type mismatch error, since Target.Value will be an
>> array of values in that case.  Admittedly this is inside your If
>> Target.Address="B3" block, which if you changed to ="$B$3" would run
>> your code if ONLY cell B3 was changed, and with only one cell changed, and
>> your Select statement inside that If block it will never execute under
>> other circumstances, and you would avoid an error.  I recommend the
>> Intersect method though.  In which case, you might get a type mismatch, and
>> also you would be checking the value of who knows what other cells you
>> aren't interested in, too.
>>
>> ** **
>>
>> You could use:
>>
>> Select Case Range("B3").Value
>>
>> 
>>
>> ** **
>>
>> Asa
>>
>> ** **
>>
>> ** **
>>
>> ** **
>>
>> -Original Message-
>> From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
>> On Behalf Of Jack
>> Sent: Thursday, November 10, 2011 12:12 PM
>> To: MS EXCEL AND VBA MACROS
>> Subject: Re: $$Excel-Macros$$ Calling multiple type subroutines
>>
>> ** **
>>
>> I apologize for the lack of c

Re: $$Excel-Macros$$ Calling multiple type subroutines

[Jack]

Thanks for the replying guys.

Asa
I'm still slightly confused on how to deploy the Select Case Range
option that you suggested.

Sam
Great effort. However, due the fact that the picture subroutine was
written in a Worksheet_Change routine, the Worksheet Calculate negates
it ability to change the pictures. So none of my pictures appeared. Am
I missing anything else to make this execute?

Regards,
Jack

On Nov 11, 10:16 am, Sam Mathai Chacko  wrote:
> I believe you can merge it like this
>
> Private Sub Worksheet_Change(ByVal Target As Range)
>
>     Dim oPic As Picture
>
>     If Target.Address = "B3" Then
>         Select Case Target.Value
>             Case Is = "DSL-Cleaner"
>                 Rows("1:156").Hidden = False
>                 Rows("157:208").Hidden = True
>                 Rows("209:256").Hidden = False
>             Case Is = "DSN-DSL Cleaner"
>                 Rows("1:256").Hidden = False
>         End Select
>
>         Me.Pictures.Visible = False
>         With Target
>             For Each oPic In Me.Pictures
>                 If oPic.Name = .Text Then
>                     oPic.Visible = True
>                     oPic.Top = .Top
>                     oPic.Left = .Left
>                     Exit For
>                 End If
>             Next oPic
>         End With
>
>     End If
>
> End Sub
>
> Regards,
>
> Sam Mathai Chacko
>
>
>
>
>
>
>
> On Fri, Nov 11, 2011 at 1:57 PM, Asa Rossoff  wrote:
> > Hi Jack,
>
> > ** **
>
> > Does cell B3 contain a formula or are you entering a value directly?
>
> > ** **
>
> > The Worksheet_Change event is triggered by changes that result from direct
> > entry.
>
> > The Worksheet_Calculate event is triggered by worksheet calculation.  If
> > there is a formula in B3, it will never be the "Target" in a
> > Worksheet_Change event, although any time it's resultant value changes (and
> > even more often than that, most likely), you would get a
> > Worksheet_Calculate event.
>
> > ** **
>
> > Also, in your original post, the Worksheet_Change event you posted had a
> > couple of potential problems that I noticed:
>
> > ** **
>
> > (1) The subroutine declaration was commented out with a single
> > apostrophe.   The event would be disabled like that, and the VBA code
> > without a Sub or Function declaration, and especially with an End Sub at
> > the end, would most likely confuse VBA.
>
> > ** **
>
> > (2) You have the statement:
>
> > If Target.Address = "B3" Then 
>
> > ** **
>
> > Since more than one cell can change at one time (copy/paste, fill, ?), the
> > Address property will refer to all of the changed cells.  Also, The
> > .Address property will never = "B3".  It could = "$B$3" though.
>
> > ** **
>
> > The usual way of checking if a particular cell was changed in the
> > Worksheet_Change event is to see if the cell intersects with Target:
>
> > If Not Application.Intersect(Range("B3"), Target) Is Nothing Then 
>
> > ** **
>
> > (3) You have the statement:
>
> > Select Case Target.Value
>
> >     Case Is = "DSL-Cleaner"
>
> > 
>
> > ** **
>
> > If Target is a range of more than one cell, comparing Target.Value to a
> > string will result in a type mismatch error, since Target.Value will be an
> > array of values in that case.  Admittedly this is inside your If
> > Target.Address="B3" block, which if you changed to ="$B$3" would run your
> > code if ONLY cell B3 was changed, and with only one cell changed, and your
> > Select statement inside that If block it will never execute under other
> > circumstances, and you would avoid an error.  I recommend the Intersect
> > method though.  In which case, you might get a type mismatch, and also you
> > would be checking the value of who knows what other cells you aren't
> > interested in, too.
>
> > ** **
>
> > You could use:
>
> > Select Case Range("B3").Value
>
> > 
>
> > ** **
>
> > Asa
>
> > ** **
>
> > ** **
>
> > ** **
>
> > -Original Message-
> > From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
> > On Behalf Of Jack
> > Sent: Thursday, November 10, 2011 12:12 PM
> > To: MS EXCEL AND VBA MACROS
> > Subject: Re: $$Excel-Macros$$ Calling multiple type subroutines
>
> > ** **
>
> > I apologize for the lack of clarity. I blame it on being new to macros
>
> > still, lol.
>
> > ** **
>
> > The first routine is a:
>
> > ** **
>
> > Private Sub Worksheet_Calculate()
>
> > ** **
>
> > Dim oPic As Picture
>
> > Me.Pictures.Visible = False
>
> > With Range("B3")
>
> >     For Each oPic In Me.Pictures
>
> >         If oPic.Name = .Text Then
>
> >             oPic.Visible = True
>
> >             oPic.Top = .Top
>
> >             oPic.Left = .Left
>
> >             Exit For
>
> >         End If
>
> >             Next oPic
>
> > End With
>
> > End Sub
>
> > ** **
>
> > I forgot to mention that I pulled this rout

Re: $$Excel-Macros$$ Indirect Formula - Need Advise

[NOORAIN ANSARI]

Dear JP,

Please find attached sheet, I hope it will help to u..
try..

=VLOOKUP($A2,INDIRECT($G$3&"!A:D"),MATCH(B$1,AN!$A$1:$D$1,0),0)
-- 
Thanks & regards,
Noorain Ansari
 *http://excelmacroworld.blogspot.com/*
*http://noorain-ansari.blogspot.com/* 
On Fri, Nov 11, 2011 at 2:32 PM, Jayaprakash S
wrote:

> Dear Experts,
>
> To make a Summary, i'm using indirect formula and need your help &
> advise to complete the same..
>
> Here with enclosed the example along with the issue.
>
> thank you.
>
> Jp
>
> --
> 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


INDIRECT FUNCTION - EXAMPLE(Solved).xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Calling multiple type subroutines

[Sam Mathai Chacko]

I believe you can merge it like this

Private Sub Worksheet_Change(ByVal Target As Range)

Dim oPic As Picture

If Target.Address = "B3" Then
Select Case Target.Value
Case Is = "DSL-Cleaner"
Rows("1:156").Hidden = False
Rows("157:208").Hidden = True
Rows("209:256").Hidden = False
Case Is = "DSN-DSL Cleaner"
Rows("1:256").Hidden = False
End Select

Me.Pictures.Visible = False
With Target
For Each oPic In Me.Pictures
If oPic.Name = .Text Then
oPic.Visible = True
oPic.Top = .Top
oPic.Left = .Left
Exit For
End If
Next oPic
End With

End If

End Sub

Regards,

Sam Mathai Chacko

On Fri, Nov 11, 2011 at 1:57 PM, Asa Rossoff  wrote:

> Hi Jack,
>
> ** **
>
> Does cell B3 contain a formula or are you entering a value directly?
>
> ** **
>
> The Worksheet_Change event is triggered by changes that result from direct
> entry.
>
> The Worksheet_Calculate event is triggered by worksheet calculation.  If
> there is a formula in B3, it will never be the "Target" in a
> Worksheet_Change event, although any time it's resultant value changes (and
> even more often than that, most likely), you would get a
> Worksheet_Calculate event.
>
> ** **
>
> Also, in your original post, the Worksheet_Change event you posted had a
> couple of potential problems that I noticed:
>
> ** **
>
> (1) The subroutine declaration was commented out with a single
> apostrophe.   The event would be disabled like that, and the VBA code
> without a Sub or Function declaration, and especially with an End Sub at
> the end, would most likely confuse VBA.
>
> ** **
>
> (2) You have the statement:
>
> If Target.Address = "B3" Then 
>
> ** **
>
> Since more than one cell can change at one time (copy/paste, fill, ?), the
> Address property will refer to all of the changed cells.  Also, The
> .Address property will never = "B3".  It could = "$B$3" though.
>
> ** **
>
> The usual way of checking if a particular cell was changed in the
> Worksheet_Change event is to see if the cell intersects with Target:
>
> If Not Application.Intersect(Range("B3"), Target) Is Nothing Then 
>
> ** **
>
> (3) You have the statement:
>
> Select Case Target.Value
>
> Case Is = "DSL-Cleaner"
>
> 
>
> ** **
>
> If Target is a range of more than one cell, comparing Target.Value to a
> string will result in a type mismatch error, since Target.Value will be an
> array of values in that case.  Admittedly this is inside your If
> Target.Address="B3" block, which if you changed to ="$B$3" would run your
> code if ONLY cell B3 was changed, and with only one cell changed, and your
> Select statement inside that If block it will never execute under other
> circumstances, and you would avoid an error.  I recommend the Intersect
> method though.  In which case, you might get a type mismatch, and also you
> would be checking the value of who knows what other cells you aren't
> interested in, too.
>
> ** **
>
> You could use:
>
> Select Case Range("B3").Value
>
> 
>
> ** **
>
> Asa
>
> ** **
>
> ** **
>
> ** **
>
> -Original Message-
> From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
> On Behalf Of Jack
> Sent: Thursday, November 10, 2011 12:12 PM
> To: MS EXCEL AND VBA MACROS
> Subject: Re: $$Excel-Macros$$ Calling multiple type subroutines
>
> ** **
>
> I apologize for the lack of clarity. I blame it on being new to macros
>
> still, lol.
>
> ** **
>
> The first routine is a:
>
> ** **
>
> Private Sub Worksheet_Calculate()
>
> ** **
>
> Dim oPic As Picture
>
> Me.Pictures.Visible = False
>
> With Range("B3")
>
> For Each oPic In Me.Pictures
>
> If oPic.Name = .Text Then
>
> oPic.Visible = True
>
> oPic.Top = .Top
>
> oPic.Left = .Left
>
> Exit For
>
> End If
>
> Next oPic
>
> End With
>
> End Sub
>
> ** **
>
> I forgot to mention that I pulled this routine from a web example.
>
> ** **
>
> The problem I'm having is that when whichever routine I put first,
>
> gets priority and it works. However the 2nd one does not. Putting the
>
> picture change routine first, it does change the pictures. However,
>
> the 2nd routine to hide rows does not work. I would just like to know
>
> how to get them both to work since they are independent routines being
>
> that they are 2 different types of sub routines
>
> ** **
>
> Private Sub Worksheet_Calculate()
>
> Private Sub Worksheet_Change(ByVal Target As Range)
>
> ** **
>
> I'm not sure how to work it to where both work simultaneously.
>
> ** **
>
> Jack
>

$$Excel-Macros$$ Indirect Formula - Need Advise

[Jayaprakash S]

Dear Experts,

To make a Summary, i'm using indirect formula and need your help &
advise to complete the same..

Here with enclosed the example along with the issue.

thank you.

Jp

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


INDIRECT FUNCTION - EXAMPLE.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

$$Excel-Macros$$ Help on Indirect Formula

[Jayaprakash S]

Dear Experts,

I need your valuable advise on Indirect formula for the attached problem...

Also explain me about the Indirect formula.

Thanks in advance!!
JP

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


INDIRECT FUNCTION - EXAMPLE.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ SUM Reg.

[dguillett1]

Look in the help index for SUMIF

=SUMIF($D$2:$D$21,"stock",$G$2:$G$21)

Don Guillett
SalesAid Software
dguille...@gmail.com

From: jmothilal 
Sent: Friday, November 11, 2011 8:53 AM
To: excel-macros@googlegroups.com 
Subject: $$Excel-Macros$$ SUM Reg.

DEAR EXCEL MEMBERS , 

I WANT TO SUM OF  SPECIFIED ROWS , HERE WITH I ATTACHED FILES.  I.E STOCK , 
SALES.

THANKS WITH




-- 
J.Mohilal
Universal Computer Systems
# 16, Brindavan Complex
Otteri, Vellore-2

-- 
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$$ SUM Reg.

[dguillett1]

You may ? like this structure better

Stock Sales 
  S.NO SHOP NO AREA SNJ10K HVB SNJ10K HVB 
  1 2571   12 5 12 5 
  2 2574   
Total 12 5 12 5 



Don Guillett
SalesAid Software
dguille...@gmail.com

From: jmothilal 
Sent: Friday, November 11, 2011 8:53 AM
To: excel-macros@googlegroups.com 
Subject: $$Excel-Macros$$ SUM Reg.

DEAR EXCEL MEMBERS , 

I WANT TO SUM OF  SPECIFIED ROWS , HERE WITH I ATTACHED FILES.  I.E STOCK , 
SALES.

THANKS WITH




-- 
J.Mohilal
Universal Computer Systems
# 16, Brindavan Complex
Otteri, Vellore-2

-- 
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$$ SUM Reg.

[jmothilal]

Thanks for sending immediate answer. Thanks , Thanks ...


Mothilal.J

On Fri, Nov 11, 2011 at 8:30 PM, dguillett1  wrote:

>   Look in the help index for SUMIF
>
> =SUMIF($D$2:$D$21,"stock",$G$2:$G$21)
>
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
>
>  *From:* jmothilal 
> *Sent:* Friday, November 11, 2011 8:53 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ SUM Reg.
>
> DEAR EXCEL MEMBERS ,
>
> I WANT TO SUM OF  SPECIFIED ROWS , HERE WITH I ATTACHED FILES.  I.E STOCK
> , SALES.
>
> THANKS WITH
>
>
>
> --
> J.Mohilal
> Universal Computer Systems
> # 16, Brindavan Complex
> Otteri, Vellore-2
> --
> 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
>



-- 
J.Mohilal
Universal Computer Systems
# 16, Brindavan Complex
Otteri, Vellore-2

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

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

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

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

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

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

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

$$Excel-Macros$$ SUM Reg.

[jmothilal]

DEAR EXCEL MEMBERS ,

I WANT TO SUM OF  SPECIFIED ROWS , HERE WITH I ATTACHED FILES.  I.E STOCK ,
SALES.

THANKS WITH



-- 
J.Mohilal
Universal Computer Systems
# 16, Brindavan Complex
Otteri, Vellore-2

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


Book2.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Combine data from multiple sheets, multiple hits

[dguillett1]

Should do it ALL. See attached

Don Guillett
SalesAid Software
dguille...@gmail.com

From: Urghhh 
Sent: Friday, November 11, 2011 4:43 AM
To: excel-macros@googlegroups.com 
Subject: Re: $$Excel-Macros$$ Combine data from multiple sheets, multiple hits

Yes that's the thing :) 

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


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

Re: $$Excel-Macros$$ help me

[vijayajith VA]

Hi sam,

I Can use vlookup but i am having  morethan 6000 blank rows if i use
vlookup up while dragging

some other rows data will change rite ?

Thanks


On Thu, Nov 10, 2011 at 10:44 PM, Sam Mathai Chacko wrote:

> Not sure why you don't want a vlookup. Suggest using that, or using a
> macro, given that all cells are the same order.
>
> Sub GetMissingData()
>
> Dim lngLoop As Long
>
> For lngLoop = Cells(Rows.Count, 1).End(xlUp).Row To 2 Step -1
> If IsEmpty(Cells(lngLoop, 2)) Then
> Cells(lngLoop, 2).Value = Worksheets("Sheet2").Cells(lngLoop,
> 2).Value
> End If
> Next lngLoop
>
> End Sub
>
> Regards,
>
> Sam Mathai Chacko
>
>
> On Thu, Nov 10, 2011 at 7:42 PM, vijayajith VA wrote:
>
>> hi
>>
>> I have tried using pastespecial its NOT WORKING
>> its copying only two cells
>>
>> can you help me  please ?
>>
>> Pleas find the attachment
>>
>> Thank you
>>
>>
>> On Thu, Nov 10, 2011 at 7:41 PM, vijayajith VA 
>> wrote:
>>
>>>
>>> hi
>>>
>>> I have tried using pastespecial but its  not working
>>>
>>> its copying only two cells
>>>
>>> can you help me  please ?
>>>
>>> Pleas find the attachment
>>>
>>> Thank you
>>>
>>> On Thu, Nov 10, 2011 at 7:01 PM,  wrote:
>>>
 Copy in a filter mode the desired data then use paste special (alt e s
 v ) and select skip blank option.
 Hope fully it will solve ur queries.

 Sandeep Chhajer.
 Sent on my BlackBerryŽ from Vodafone
 --
 *From: * "dguillett1" 
 *Sender: * excel-macros@googlegroups.com
 *Date: *Thu, 10 Nov 2011 07:25:57 -0600
 *To: *
 *ReplyTo: * excel-macros@googlegroups.com
 *Subject: *Re: $$Excel-Macros$$ help me

  Post your file

 Don Guillett
 SalesAid Software
 dguille...@gmail.com

  *From:* vijayajith VA 
 *Sent:* Thursday, November 10, 2011 6:11 AM
 *To:* excel-macros@googlegroups.com
 *Subject:* $$Excel-Macros$$ help me

  HI


 I have some datas in tab with coloumns(code and name)

 in one more tab with same datas but some names are missing ..

 so i need to filter  the and paste the data.

 but if i paste the datas it will  not paste completely .why

 i dont want to use vlookup is thr any shortcuts


 Thanks

 --
 FORUM RULES (934+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

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

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

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

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

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


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

 --
 FORUM RULES (934+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

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

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

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

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

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


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

 --
 FORUM RULES (934+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

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

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

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

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

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

Re: $$Excel-Macros$$ help me

[vijayajith VA]

HI


Thanks Its Working thank you very much

On Fri, Nov 11, 2011 at 12:03 AM,  wrote:

> **
> Please after copy, paste special it in un filtered data...(Use shortcut
> alt d f s and then alt e s v tick @ skip blank)
>
> Sandeep Chhajer.
> Sent on my BlackBerry® from Vodafone
> --
> *From: * vijayajith VA 
> *Sender: * excel-macros@googlegroups.com
> *Date: *Thu, 10 Nov 2011 19:41:37 +0530
> *To: *
> *ReplyTo: * excel-macros@googlegroups.com
> *Subject: *Re: $$Excel-Macros$$ help me
>
>
> hi
>
> I have tried using pastespecial but its working
>
> its copying only two cells
>
> can you help me ?
>
> Pleas find the attachment
>
> Thank you
>
> On Thu, Nov 10, 2011 at 7:01 PM,  wrote:
>
>> Copy in a filter mode the desired data then use paste special (alt e s v
>> ) and select skip blank option.
>> Hope fully it will solve ur queries.
>>
>> Sandeep Chhajer.
>> Sent on my BlackBerryŽ from Vodafone
>> --
>> *From: * "dguillett1" 
>> *Sender: * excel-macros@googlegroups.com
>> *Date: *Thu, 10 Nov 2011 07:25:57 -0600
>> *To: *
>> *ReplyTo: * excel-macros@googlegroups.com
>> *Subject: *Re: $$Excel-Macros$$ help me
>>
>>  Post your file
>>
>> Don Guillett
>> SalesAid Software
>> dguille...@gmail.com
>>
>>  *From:* vijayajith VA 
>> *Sent:* Thursday, November 10, 2011 6:11 AM
>> *To:* excel-macros@googlegroups.com
>> *Subject:* $$Excel-Macros$$ help me
>>
>>  HI
>>
>>
>> I have some datas in tab with coloumns(code and name)
>>
>> in one more tab with same datas but some names are missing ..
>>
>> so i need to filter  the and paste the data.
>>
>> but if i paste the datas it will  not paste completely .why
>>
>> i dont want to use vlookup is thr any shortcuts
>>
>>
>> Thanks
>>
>> --
>> FORUM RULES (934+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> --
>> FORUM RULES (934+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> --
>> FORUM RULES (934+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>  --
> 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,

Re: $$Excel-Macros$$ Help Required.xlsx

[dguillett1]

In this particular sample you can simply filter by date. However, that may not 
be what you need in all cases??

Don Guillett
SalesAid Software
dguille...@gmail.com

From: NOORAIN ANSARI 
Sent: Friday, November 11, 2011 4:04 AM
To: excel-macros@googlegroups.com 
Subject: Re: $$Excel-Macros$$ Help Required.xlsx

Dear Neeraj,

Please try through below formula, See attached sheet..

=OFFSET($D$1,SMALL(IF($B$2:$B$24=$I2,ROW($D$2:$D$24),""),COUNTIF($I$2:$I2,$I2))-1,0)
Press ctrl+shift+enter

-- 

Thanks & regards,
Noorain Ansari
http://excelmacroworld.blogspot.com/
http://noorain-ansari.blogspot.com/

On Fri, Nov 11, 2011 at 2:12 PM, Neeraj Chauhan  
wrote:

  Dear Experts,



  Kindly find the attached sheet.

  I want to only last date qty and stock in three sites.

  -- 
  FORUM RULES (934+ members already BANNED for violation)
   
  1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
   
  2) Don't post a question in the thread of another member.
   
  3) Don't post questions regarding breaking or bypassing any security measure.
   
  4) Acknowledge the responses you receive, good or bad.
   
  5) Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 
   
  NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
   
  
--
  To post to this group, send email to excel-macros@googlegroups.com




-- 
FORUM RULES (934+ members already BANNED for violation)
 
1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
 
--
To post to this group, send email to excel-macros@googlegroups.com

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

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

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

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

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

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

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

Re: $$Excel-Macros$$ Modify code to lock multiple sheets in a spreadsheet.

[rajan verma]

You can try Allow User To Edit Range Option.. Hope it will help..

On Fri, Nov 11, 2011 at 2:01 AM, dguillett1  wrote:

> I should have been clearer. I meant to suggest they each have their own
> FILE and then you have a macro to combine. If all in the same folder its
> fairly easy to combine the files, if desired.
>
>
>
>
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
> -Original Message- From: Dave
> Sent: Thursday, November 10, 2011 2:18 PM
>
> To: MS EXCEL AND VBA MACROS
> Subject: Re: $$Excel-Macros$$ Modify code to lock multiple sheets in a
> spreadsheet.
>
>
> That what they have now ...without the macro to combine them and they
> have to roll it up by hand.
> Can I use the Macro recorder in Excel to do this task?
>
> On Nov 10, 2:15 pm, "dguillett1"  wrote:
>
>> Why not give each their own sheet and then you combine with a macro.
>>
>> Don Guillett
>> SalesAid Software
>> dguille...@gmail.com
>>
>>
>>
>> -Original Message-
>> From: Dave
>> Sent: Thursday, November 10, 2011 2:09 PM
>> To: MS EXCEL AND VBA MACROS
>> Subject: $$Excel-Macros$$ Modify code to lock multiple sheets in a
>> spreadsheet.
>>
>> Hi,
>>
>> I have an Excel 2010 Workbook with 17 Worksheets, Sheet1... Sheet17. I
>> have this workbook shared on the network. Employees open this workbook
>> and they enter their daily work log into it individual work sheets.
>> The problem I am having is that "No one knows who did it" syndrome
>> where either accidently or intentionally employees are subtracting the
>> work done by other employees   or deleting data.
>>
>> So I am looking for a solution where I can restrict each employee to
>> their own worksheet. All suggestions are welcome.
>>
>> I came across the following code this works great  for sheet1 but I
>> need it to be modified for 17 sheets. As I am not a programmer I have
>> not been able to implement it across my 17 sheets. Can you guys fix it
>> so that I can use it across my 17 sheets.
>>
>> This is the code:  
>> http://www.ozgrid.com/VBA/**stop-worksheet-viewing.htm
>>
>> thanks to all
>>
>> --
>> 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- Hide
>> quoted text -
>>
>> - Show quoted text -
>>
>
> --
> 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
>



-- 
Regards
Rajan verma
+91 9158998701

-- 
FORUM RULES (934+ members already BANNED for 

Re: $$Excel-Macros$$ Combine data from multiple sheets, multiple hits

[Urghhh]

Yes that's the thing :)

Kim

-- 
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$$ Help Required.xlsx

[Aindril De]

Good one Noorain..
Can you help how this array works please..
Cheers,
Andy

On Fri, Nov 11, 2011 at 3:34 PM, NOORAIN ANSARI wrote:

> Dear Neeraj,
>
> Please try through below formula, See attached sheet..
>
>
> =OFFSET($D$1,SMALL(IF($B$2:$B$24=$I2,ROW($D$2:$D$24),""),COUNTIF($I$2:$I2,$I2))-1,0)
> Press ctrl+shift+enter
>
> --
> Thanks & regards,
> Noorain Ansari
>  *http://excelmacroworld.blogspot.com/*
> *http://noorain-ansari.blogspot.com/*
>
> On Fri, Nov 11, 2011 at 2:12 PM, Neeraj Chauhan <
> neerajchauhan...@gmail.com> wrote:
>
>>  Dear Experts,
>>
>> ** **
>>
>> Kindly find the attached sheet.
>>
>> I want to only last date qty and stock in three sites.
>>
>> --
>> 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
>



-- 

Warm Regards,
Aindril De
Ph: 9811300157

-- 
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$$ Help Required.xlsx

[NOORAIN ANSARI]

Dear Neeraj,

Please try through below formula, See attached sheet..

=OFFSET($D$1,SMALL(IF($B$2:$B$24=$I2,ROW($D$2:$D$24),""),COUNTIF($I$2:$I2,$I2))-1,0)
Press ctrl+shift+enter

-- 
Thanks & regards,
Noorain Ansari
 *http://excelmacroworld.blogspot.com/*
*http://noorain-ansari.blogspot.com/* 

On Fri, Nov 11, 2011 at 2:12 PM, Neeraj Chauhan
wrote:

>  Dear Experts,
>
> ** **
>
> Kindly find the attached sheet.
>
> I want to only last date qty and stock in three sites.
>
> --
> 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


Help Required(Solved).xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Help Required.xlsx

[Aindril De]

Hi Neeraj,

This can be achieved with the use of Pivots.
Attached is the Solution.
Please let me know if you need any clarification.

Cheers,
Andy

On Fri, Nov 11, 2011 at 2:12 PM, Neeraj Chauhan
wrote:

>  Dear Experts,
>
> ** **
>
> Kindly find the attached sheet.
>
> I want to only last date qty and stock in three sites.
>
> --
> 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
>



-- 

Warm Regards,
Aindril De
Ph: 9811300157

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


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

RE: $$Excel-Macros$$ Plz do the needfull

[Asa Rossoff]

Either of these:

(1) Right-click, remove hyperlink in each cell.

(2) Highlight all cells, Copy (ctrl-c); then in another column, Paste
Special, Values (alt-e,s,v)

 

To prevent emails, URLs and UNC paths from automatically becoming hyperlinks
when entered/edited, change the AutoCorrect options:

For Excel 2007/2010, File > Options > Proofing > AutoCorrect Options >
AutoFormat As You Type, uncheck hyperlinks.

For Excel 2003, Tools > AutoCorrect > AutoFormat As You Type, uncheck
hyperlinks.

 

Asa

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Anil Saxena
Sent: Thursday, November 10, 2011 11:32 PM
To: Dilip Pandey
Cc: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Plz do the needfull

 

Hi All,

How can we remove the hyperlink only short key not formula.

 

 

-- 
FORUM RULES (934+ members already BANNED for violation)
 
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security
measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
 

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

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

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

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

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

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

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

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

$$Excel-Macros$$ Help Required.xlsx

[Neeraj Chauhan]

Dear Experts,

 

Kindly find the attached sheet.

I want to only last date qty and stock in three sites.

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


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

Re: $$Excel-Macros$$ excel vba If IsEmpty(Range) code problem

[Seba]

Hi guys,

thank you very much for your help.
You solved my problem and thank you for different posibilities from
which I can learn.

Best regards,

seba

On 10 nov., 18:21, Sam Mathai Chacko  wrote:
> Two options try
>
>     If Not IsEmpty(Range("A1")) Then
>         Range("B5").Value = 8
>     Else
>         Exit Sub
>     End If
>
> *OR*
>
>     If Len(Trim(Range("A1"))) Then
>         Range("B5").Value = 8
>     Else
>         Exit Sub
>     End If
>
> Regards
>
> Sam Mathai Chacko
>
>
>
>
>
>
>
>
>
> On Thu, Nov 10, 2011 at 10:13 PM, dguillett1  wrote:
> > you forgot RANGE but to make sure try
>
> > If len(application.trim(range("**A1")))<1 Then
>
> > Don Guillett
> > SalesAid Software
> > dguille...@gmail.com
> > -Original Message- From: Seba
> > Sent: Thursday, November 10, 2011 9:48 AM
> > To: MS EXCEL AND VBA MACROS
> > Subject: $$Excel-Macros$$ excel vba If IsEmpty(Range) code problem
>
> > Hi,
>
> > I am testing this fairly simple code for some other purposes but I
> > always get the value 8 regardless of value in A1:
>
> > --**--**
> > Sub testPogoja()
> > If IsEmpty("A1") Then
> > Exit Sub
> > Else
> > Range("B5").Value = 8
> > End If
> > End Sub
> > --**--**
>
> > I also tried
>
> > Sub testPogoja()
> > If IsEmpty("A1") = True Then
> > Exit Sub
> > Else
> > Range("B5").Value = 8
> > End If
> > End Sub
> > --**--**
> > 
>
> > and no luck.
> > What am I doing wrong?
>
> > regards
> > seba
>
> > --
> > 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
>
> --
> Sam Mathai Chacko

-- 
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$$ Calling multiple type subroutines

[Asa Rossoff]

Hi Jack,

 

Does cell B3 contain a formula or are you entering a value directly?

 

The Worksheet_Change event is triggered by changes that result from direct
entry.

The Worksheet_Calculate event is triggered by worksheet calculation.  If
there is a formula in B3, it will never be the "Target" in a
Worksheet_Change event, although any time it's resultant value changes (and
even more often than that, most likely), you would get a Worksheet_Calculate
event.

 

Also, in your original post, the Worksheet_Change event you posted had a
couple of potential problems that I noticed:

 

(1) The subroutine declaration was commented out with a single apostrophe.
The event would be disabled like that, and the VBA code without a Sub or
Function declaration, and especially with an End Sub at the end, would most
likely confuse VBA.

 

(2) You have the statement:

If Target.Address = "B3" Then 

 

Since more than one cell can change at one time (copy/paste, fill, ?), the
Address property will refer to all of the changed cells.  Also, The .Address
property will never = "B3".  It could = "$B$3" though.

 

The usual way of checking if a particular cell was changed in the
Worksheet_Change event is to see if the cell intersects with Target:

If Not Application.Intersect(Range("B3"), Target) Is Nothing Then 

 

(3) You have the statement:

Select Case Target.Value

Case Is = "DSL-Cleaner"



 

If Target is a range of more than one cell, comparing Target.Value to a
string will result in a type mismatch error, since Target.Value will be an
array of values in that case.  Admittedly this is inside your If
Target.Address="B3" block, which if you changed to ="$B$3" would run your
code if ONLY cell B3 was changed, and with only one cell changed, and your
Select statement inside that If block it will never execute under other
circumstances, and you would avoid an error.  I recommend the Intersect
method though.  In which case, you might get a type mismatch, and also you
would be checking the value of who knows what other cells you aren't
interested in, too.

 

You could use:

Select Case Range("B3").Value



 

Asa

 

 

 

-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Jack
Sent: Thursday, November 10, 2011 12:12 PM
To: MS EXCEL AND VBA MACROS
Subject: Re: $$Excel-Macros$$ Calling multiple type subroutines

 

I apologize for the lack of clarity. I blame it on being new to macros

still, lol.

 

The first routine is a:

 

Private Sub Worksheet_Calculate()

 

Dim oPic As Picture

Me.Pictures.Visible = False

With Range("B3")

For Each oPic In Me.Pictures

If oPic.Name = .Text Then

oPic.Visible = True

oPic.Top = .Top

oPic.Left = .Left

Exit For

End If

Next oPic

End With

End Sub

 

I forgot to mention that I pulled this routine from a web example.

 

The problem I'm having is that when whichever routine I put first,

gets priority and it works. However the 2nd one does not. Putting the

picture change routine first, it does change the pictures. However,

the 2nd routine to hide rows does not work. I would just like to know

how to get them both to work since they are independent routines being

that they are 2 different types of sub routines

 

Private Sub Worksheet_Calculate()

Private Sub Worksheet_Change(ByVal Target As Range)

 

I'm not sure how to work it to where both work simultaneously.

 

Jack

 

On Nov 10, 11:28 am, Sam Mathai Chacko  wrote:

> The Worksheet change routine is automatically triggered when there is a

> change (change in value/modification of value etc) in 1 or more cells

> within THAT sheet. So you don't really CALL it, it GETS called, in other

> words, TRIGGERED.

> 

> For the first routine, the context is not clear enough to judge when and

> how it has to be called, so a bit more clarity may help

> 

> Regards,

> Sam

> 

> 

> 

> 

> 

> 

> 

> 

> 

> On Thu, Nov 10, 2011 at 8:53 PM, Jack  wrote:

> > I am new to macros. I tried searching the internet for the answer but

> > the limited experience didn't quite help me find my answer. I hope you

> > guys can figure it out.

> 

> > I have 2 sub routines. 1 that pulls a photo and another that hides

> > rows based on a value from cell B3. I tried to the Call option but

> > wasn't quite sure how to pull it together. Below are my 2 routines:

> 

> > Dim oPic As Picture

> > Me.Pictures.Visible = False

> > With Range("B3")

> >For Each oPic In Me.Pictures

> >If oPic.Name = .Text Then

> >oPic.Visible = True

> >oPic.Top = .Top

> >oPic.Left = .Left

> >Exit For

> >End If

> >Next oPic

> > End With

> > End Sub

> 

> >

--

> > 'Private Sub Worksheet_Change(ByVal Target As Range)

> 

> > If Target.Addre

Re: $$Excel-Macros$$ Seeking help small letters to capital letters

[NOORAIN ANSARI]

Dear Kiran,

You can use in VBA Version for Selection Range,

*Sub uppercase()
Dim abc As Range
For Each abc In Selection
abc.Value = VBA.UCase(abc)
Next
End Sub
*
-- 
Thanks & regards,
Noorain Ansari
 *http://excelmacroworld.blogspot.com/*
*http://noorain-ansari.blogspot.com/* 


2011/11/10 ♥.•:*¨¨*:•.♥.•:V.Kiran Kumar :•.♥.•:*¨¨*:•.♥ <
vadnalaki...@gmail.com>

> Hi
>
> Anybody can help me out
> how to make small letter to capital letter in Ms excel
>
> V.Kiran
>
>
> --
> 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