Fw: $$Excel-Macros$$ unable to use advance vlookup

[LAKSHMAN PRASAD]

To All,
 
 
 
 

- Forwarded Message -
From: Aamir Shahzad 
To: excel-macros@googlegroups.com 
Sent: Wednesday, May 23, 2012 1:42 AM
Subject: Re: $$Excel-Macros$$ unable to use advance vlookup

I don't think so or any other group member can provide solution. 


Regards,


Aamir Shahzad

On Tue, May 22, 2012 at 10:03 AM, LAKSHMAN PRASAD  
wrote: 
Plz see the attached file
>
>
>
>
>
>
>From: Aamir Shahzad To: 
>excel-macros@googlegroups.com Sent: Monday, May 21, 2012 11:27 PM 
>Subject: Re: $$Excel-Macros$$ unable to use advance vlookup
>sorry not understand make it clear, lots of expert here can solve your issue. 
>
>
>
>Aamir Shahzad
>
>On Mon, May 21, 2012 at 11:13 AM, LAKSHMAN PRASAD  
>wrote: 
>Hi Aamir,
>>
>>Thanks
>>
>>Is working, that’s what I exactly want to do.But Its better if we avoid extra 
>>column. I am able to avoid sheet “Subsidiary Ledger Trial Balance” 
>>Helpingcolumn but unable to avoid sheet “Sheet2” Helping column. Can you ………?
>> 
>>=VLOOKUP(A2,Sheet2!$A$2:$C$7493,3,0)
>> 
>>=IFERROR(LEFT(B2,FIND("-",B2)-1)&SUBSTITUTE(RIGHT(B2,LEN(B2)-FIND(" 
>>",B2)),"(2)",""),B2)
>> 
>>=VLOOKUP(IFERROR(LEFT(B2,FIND("-",B2)-1)&SUBSTITUTE(RIGHT(B2,LEN(B2)-FIND(" 
>>",B2)),"(2)",""),B2)
>>,Sheet2!$A$2:$C$7493,3,0)
>> 
>> 
>>Sheet2!$A$2:$C$7493--?
>> 
>> 
>>Thanks & Regards
>>LAKSHMAN
>>
>>
>>
>>
>>From: Aamir Shahzad 
>>To: excel-macros@googlegroups.com 
>>Sent: Sunday, May 20, 2012 8:33 PM 
>>Subject: Re: $$Excel-Macros$$ unable to use advance vlookup
>>As desired by you, see the attached file. 
>>
>>
>>
>>Aamir Shahzad
>>
>>On Sun, May 20, 2012 at 5:17 PM, Seraj Alam  wrote: 
>>Hi,
>>>
>>>
>>>Please try below formula...
>>>
>>>
>>>
>>>
>>>=IFERROR(VLOOKUP("*"&A2&"*",Sheet2!$A$2:$B$3272,2,0),"")
>>>
>>>
>>>On Sat, May 19, 2012 at 12:16 PM, LAKSHMAN PRASAD  
>>>wrote: 
>>>Dear Anil,
I know 

Hi, Anil,
I know that, but as per my condition or requirement, if first five number 
(from left) and first name (in any case upper of lower) should be match.
 subsidary sheet  in A17 is 
10020-16A-BLKC-MR. ANUPAM SARKAR 
 and in sheet2 in A17 is 
10020--BLKC-MR. ANUPAM SARKAR(2) 


 
From: Anil Gawli To: excel-macros@googlegroups.com 
Sent: Friday, May 18, 2012 6:22 PM 
Subject: Re: $$Excel-Macros$$ unable to use advance vlookup
subsidary sheet  in A17 is 
10020-16A-BLKC-MR. ANUPAM SARKAR  and in sheet2 in A17 is 
10020--BLKC-MR. ANUPAM SARKAR(2) 
both are not matching that,s why 
Regards,
 Anil Gawli

On Fri, May 18, 2012 at 6:05 PM, LAKSHMAN PRASAD  
wrote: 
Hi Anil, 
>
>Plz see cell D13 and D17 value or #NA data no coming
>
>
>
>From: Anil Gawli 
>To: excel-macros@googlegroups.com 
>Sent: Friday, May 18, 2012 5:37 PM
>Subject: Re: $$Excel-Macros$$ unable to use advance vlookup
>
>Try this see attached file 
>On Fri, May 18, 2012 at 4:36 PM, LAKSHMAN PRASAD  
>wrote: 
>Dear Expert
>>I m unable to use advance vlookup, plz see the attached file.
>>Regards
>>LAKSHMAN
>>-- 
>>FORUM RULES (986+ members already BANNED for violation)
>> 
>>1) Use concise, accurate thread titles. Poor thread titles, like Please 
>>Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice 
>>will not get quick attention or may not be answered.
>> 
>>2) Don't post a question in the thread of another member.
>> 
>>3) Don't post questions regarding breaking or bypassing any security 
>>measure.
>> 
>>4) Acknowledge the responses you receive, good or bad.
>> 
>>5) Cross-promotion of, or links to, forums competitive to this forum in 
>>signatures are prohibited. 
>> 
>>NOTE : Don't ever post personal or confidential data in a workbook. Forum 
>>owners and members are not responsible for any loss.
>> 
>>--
>>To post to this group, send email to excel-macros@googlegroups.com
>>-- Thanks & Regards,Gawli Anil NarayanSoftware Developer,Abacus Software 
>>Services Pvt Ltd-- FORUM RULES (986+ members already BANNED for 
>>violation) 1) Use concise, accurate thread titles. Poor thread titles, 
>>like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and 
>>Need Advice will not get quick attention or may not be answered. 2) Don't 
>>post a question in the thread of another member. 3) Don't post questions 
>>regarding breaking or bypassing any security measure. 4) Acknowledge the 
>>responses you receive, good or bad. 5) Cross-promotion of, or links to, 
>>forums competitive to this forum in signatures are prohibited.  NOTE : 
>>Don't ever post personal or confidential data in a workbook. Forum owners 
>>and members are not responsible for any 
>>loss. ---

$$Excel-Macros$$ How to create running time in excel sheet

[PRAVESH KUMAR]

Hi Group,

please tell How to create running time in excel sheet??
-- 


*Thanks & Regards*

*Pravesh Kumar*

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

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

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

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

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

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

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

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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ Change in one Cell should lead to change in all related cells

[NOORAIN ANSARI]

Dear Satish,

Please try with ctrl+shift+Enter

=INDEX($N$4:$S$10,MATCH(E$4,$M$4:$M$10,0),MATCH($D7,$N$3:$S$3,0))

See attached sheet..

Thanks & regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com

On Tue, May 22, 2012 at 11:11 PM, satish pn  wrote:

> Mr. Rajan Verma
>
> Please find attached excel file for a small example.
>
>
> On Tue, May 22, 2012 at 9:10 PM, Rajan_Verma wrote:
>
>> Please send some sample data in Excel Worksheet
>>
>> ** **
>>
>> * *
>>
>> *Regards*
>>
>> *Rajan verma*
>>
>> *+91 7838100659 [IM-Gtalk]*
>>
>> ** **
>>
>> *From:* excel-macros@googlegroups.com [mailto:
>> excel-macros@googlegroups.com] *On Behalf Of *satish pn
>> *Sent:* 22 May 2012 8:42
>> *To:* excel-macros@googlegroups.com
>> *Subject:* $$Excel-Macros$$ Change in one Cell should lead to change in
>> all related cells
>>
>> ** **
>>
>> Hello experts, 
>>
>> ** **
>>
>> I am trying to compile the data of various parameters as on every friday.
>> Various parameters will be in rows one below the other and date in column.
>> What i need now is, when  ever i change the date (i want the drop down menu
>> for selecting dates, please note date keeps getting added week after week)
>> all the respective details in rows should change by itself, so that the
>> performance between any two days can be analysed easily. is there any
>> formula or technique for this simple work. 
>>
>> ** **
>>
>> *example *
>>
>>  
>>
>> 
>>
>> date 1,2,3 
>>
>>  here drop down menu should come, (various dates)
>>
>> Parameter 1
>>
>>  
>>
>>  
>>
>>  
>>
>>  
>>
>>  
>>
>>  
>>
>>  
>>
>> parameter 2
>>
>>  
>>
>>  
>>
>>  
>>
>>  
>>
>>  
>>
>>  
>>
>>  
>>
>> Parameter 3
>>
>>  
>>
>>  
>>
>>  
>>
>>  
>>
>>  
>>
>>  
>>
>>  
>>
>> Parameter 4
>>
>>  
>>
>>  
>>
>>  
>>
>>  
>>
>>  
>>
>>  
>>
>>  
>>
>> Parameter 5
>>
>>  
>>
>>  
>>
>>  
>>
>>  
>>
>>  
>>
>>  
>>
>>  
>>
>> Parameter 6
>>
>>  
>>
>>  
>>
>>  
>>
>>  
>>
>>  
>>
>>  
>>
>>  
>>
>>  
>>
>> Please help at the earliest. 
>>
>> ** **
>>
>> Satish P N
>>
>> ** **
>>
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>>
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>>
>
>  --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are n

$$Excel-Macros$$ Merge 2 sets of data

[net user1110]

Please find the file

Hi all,

I have a task that I can achieve up to one point using vlookup but
afterwards I need to manually add rows or columns to update the data with a
new set of data. It is understood the from the first set nothing should be
deleted. Even if one row is empty from the first set is not present in the
second set of data, it should remain as an empty data row (but still with
its identifier).

For example:

1st set

col1   col2   col5   col6

A
B
C
F

2nd set

col1   col2   col6   col7

A
B
D
F
E

should result in

col1  col2  col5  col6   col7

A
B
C
D
E
F

In the result, C is an empty row as it's not in the second set but must
still be present with the letter C but without any data
Col5 will be empty as well as it's only present in the first set.

Please find a workbook with the first set of data in one sheet, the second
set in another and the expected result from it.

Thanks

Johann

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

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

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

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

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

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

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

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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

MergeAndUpdateQuest.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Merge 2 sets of data

[netuser1110]

Hi all,

I have a task that I can achieve up to one point using vlookup but 
afterwards I need to manually add rows or columns to update the data with a 
new set of data. It is understood the from the first set nothing should be 
deleted. Even if one row is empty from the first set is not present in the 
second set of data, it should remain as an empty data row (but still with 
its identifier).

For example:

*1st set*

*col1   col2   col5   col6*

Adata 1
B
C
F

*2nd set*

*col1   col2   col6   col7*

A   data 2
B
D
F
E

*should result in*

*col1  col2  col5  col6   col7*

A   data 2 only
B
C
D
E
F

In the result, C is an empty row as it's not in the second set but must 
still be present with the letter C but without any data
Col5 will be empty as well as it's only present in the first set.

Please find a workbook with the first set of data in one sheet, the second 
set in another and the expected result from it.

Thanks

Johann

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

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

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

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

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

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

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

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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ unable to use advance vlookup

[Aamir Shahzad]

I don't think so or any other group member can provide solution.

Regards,

Aamir Shahzad

On Tue, May 22, 2012 at 10:03 AM, LAKSHMAN PRASAD wrote:

> Plz see the attached file
>
>
>
>
>
>   *From:* Aamir Shahzad 
> *To:* excel-macros@googlegroups.com
> *Sent:* Monday, May 21, 2012 11:27 PM
>
> *Subject:* Re: $$Excel-Macros$$ unable to use advance vlookup
>  sorry not understand make it clear, lots of expert here can solve your
> issue.
>
> Aamir Shahzad
> On Mon, May 21, 2012 at 11:13 AM, LAKSHMAN PRASAD 
> wrote:
>
>  Hi Aamir,
>
> Thanks
>
> Is working, that’s what I exactly want to do. But Its better if we avoid
> extra column. I am able to avoid sheet “Subsidiary Ledger Trial Balance”
> Helping column but unable to avoid sheet “Sheet2” Helping column. Can you
> ………?
>
> =VLOOKUP(A2,Sheet2!$A$2:$C$7493,3,0)
>
> =IFERROR(LEFT(B2,FIND("-",B2)-1)&SUBSTITUTE(RIGHT(B2,LEN(B2)-FIND("
> ",B2)),"(2)",""),B2)
>
> =VLOOKUP(IFERROR(LEFT(B2,FIND("-",B2)-1)&SUBSTITUTE(RIGHT(B2,LEN(B2)-FIND("
> ",B2)),"(2)",""),B2)
> ,Sheet2!$A$2:$C$7493,3,0)
>
>
> Sheet2!$A$2:$C$7493--?
>
>
> Thanks & Regards
> LAKSHMAN
>
>
>  *From:* Aamir Shahzad 
> *To:* excel-macros@googlegroups.com
> *Sent:* Sunday, May 20, 2012 8:33 PM
> *Subject:* Re: $$Excel-Macros$$ unable to use advance vlookup
>   As desired by you, see the attached file.
>
> Aamir Shahzad
>  On Sun, May 20, 2012 at 5:17 PM, Seraj Alam wrote:
>
>  Hi,
>
> Please try below formula...
>
>
> =IFERROR(VLOOKUP("*"&A2&"*",Sheet2!$A$2:$B$3272,2,0),"")
>
> On Sat, May 19, 2012 at 12:16 PM, LAKSHMAN PRASAD 
> wrote:
>
>  Dear Anil,
> I know
>
> Hi, Anil,
>
> I know that, but as per my condition or requirement, if first five number
> (from left) and first name (in any case upper of lower) should be match.
>   subsidary sheet  in A17 is
>10020-16A-BLKC-MR. ANUPAM SARKAR
>   and in sheet2 in A17 is
>10020--BLKC-MR. ANUPAM SARKAR(2)
>
>
>
>   *From:* Anil Gawli *To:*
> excel-macros@googlegroups.com
> *Sent:* Friday, May 18, 2012 6:22 PM
> *Subject:* Re: $$Excel-Macros$$ unable to use advance vlookup
>  subsidary sheet  in A17 is   10020-16A-BLKC-MR. ANUPAM SARKAR  and in
> sheet2 in A17 is   10020--BLKC-MR. ANUPAM SARKAR(2)
> both are not matching that,s why
> Regards,
>  Anil Gawli
>
>  On Fri, May 18, 2012 at 6:05 PM, LAKSHMAN PRASAD 
> wrote:
>
>   Hi Anil,
>
> Plz see cell D13 and D17 value or #NA data no coming
>
>
>
>   *From:* Anil Gawli 
> *To:* excel-macros@googlegroups.com
> *Sent:* Friday, May 18, 2012 5:37 PM
> *Subject:* Re: $$Excel-Macros$$ unable to use advance vlookup
>   Try this see attached file
> On Fri, May 18, 2012 at 4:36 PM, LAKSHMAN PRASAD 
> wrote:
>
>  *Dear 
> Expert
> *
> I m unable to use advance vlookup, plz see the attached file.
> Regards
> LAKSHMAN
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> -- Thanks & Regards,Gawli Anil NarayanSoftware Developer,Abacus Software
> Services Pvt Ltd-- FORUM RULES (986+ members already BANNED for
> violation) 1) Use concise, accurate thread titles. Poor thread titles, like
> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
> Advice will not get quick attention or may not be answered. 2) Don't post a
> question in the thread of another member. 3) Don't post questions regarding
> breaking or bypassing any security measure. 4) Acknowledge the responses
> you receive, good or bad. 5) Cross-promotion of, or links to, forums
> competitive to this forum in signatures are prohibited.  NOTE : Don't ever
> post personal or confidential data in a workbook. Forum owners and members
> are not responsible for any
> loss. 
> --To
> post to this group, send email to excel-macros@googlegroups.com
>  -- FORUM RULES (986+ members already BANNED for violation) 1) Use
> concise, accurate thread titles. Poor thread titles, like Please Help,
> Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not
> get quick attention or may not be answered. 2) Don't post a question in the
> thread of an

Re: $$Excel-Macros$$ Change in one Cell should lead to change in all related cells

[Haseeb A]

Hello Satish,
 
One way is VLOOKUP
 
E5, then copy down & across.
 
=IFERROR(VLOOKUP(E$4,$M$4:$S$10,MATCH($D5,$M$3:$S$3,0),0),"")
 
Regards,
Haseeb

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

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

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

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

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

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

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

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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

RE: $$Excel-Macros$$ Change in one Cell should lead to change in all related cells

[Rajan_Verma]

What output you want ?

 

 

 

Regards

Rajan verma

+91 7838100659 [IM-Gtalk]

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of satish pn
Sent: 22 May 2012 11:19
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Change in one Cell should lead to change in
all related cells

 

No... it didnt work... :-(

On Tue, May 22, 2012 at 11:15 PM, Rajan_Verma 
wrote:

 

 

Try this:

 

=TRANSPOSE(OFFSET(INDEX($K$3:$K$10,MATCH(C4,$K$3:$K$10,0),1),,1,,COUNTA($L$5
:$Q$5)))

 

 

Regards

Rajan verma

+91 7838100659 [IM-Gtalk]

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of satish pn
Sent: 22 May 2012 11:11
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Change in one Cell should lead to change in
all related cells

 

Mr. Rajan Verma

 

Please find attached excel file for a small example.

On Tue, May 22, 2012 at 9:10 PM, Rajan_Verma 
wrote:

Please send some sample data in Excel Worksheet

 

 

Regards

Rajan verma

+91 7838100659 [IM-Gtalk]

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of satish pn
Sent: 22 May 2012 8:42
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Change in one Cell should lead to change in all
related cells

 

Hello experts, 

 

I am trying to compile the data of various parameters as on every friday.
Various parameters will be in rows one below the other and date in column.
What i need now is, when  ever i change the date (i want the drop down menu
for selecting dates, please note date keeps getting added week after week)
all the respective details in rows should change by itself, so that the
performance between any two days can be analysed easily. is there any
formula or technique for this simple work. 

 

example 


 


date 1,2,3 

 here drop down menu should come, (various dates)


Parameter 1

 

 

 

 

 

 

 


parameter 2

 

 

 

 

 

 

 


Parameter 3

 

 

 

 

 

 

 


Parameter 4

 

 

 

 

 

 

 


Parameter 5

 

 

 

 

 

 

 


Parameter 6

 

 

 

 

 

 

 


 



Please help at the earliest. 

 

Satish P N

 

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

--
To post to this group, send email to excel-macros@googlegroups.com
 
To unsubscribe, send a blank email to
excel-macros+unsubscr...@googlegroups.com

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

--
To post to this group, send email to excel-macros@googlegroups.com
 
To unsubscribe, send a blank email to
excel-macros+unsubscr...@googlegroups.com
 

 

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

--
To post to this group,

Re: $$Excel-Macros$$ Change in one Cell should lead to change in all related cells

[satish pn]

No... it didnt work... :-(

On Tue, May 22, 2012 at 11:15 PM, Rajan_Verma wrote:

> ** **
>
> ** **
>
> Try this:
>
> ** **
>
>
> =TRANSPOSE(OFFSET(INDEX($K$3:$K$10,MATCH(C4,$K$3:$K$10,0),1),,1,,COUNTA($L$5:$Q$5)))
> 
>
> ** **
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *satish pn
> *Sent:* 22 May 2012 11:11
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Change in one Cell should lead to change
> in all related cells
>
> ** **
>
> Mr. Rajan Verma
>
> ** **
>
> Please find attached excel file for a small example.
>
> On Tue, May 22, 2012 at 9:10 PM, Rajan_Verma 
> wrote:
>
> Please send some sample data in Excel Worksheet
>
>  
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
>  
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *satish pn
> *Sent:* 22 May 2012 8:42
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Change in one Cell should lead to change in
> all related cells
>
>  
>
> Hello experts, 
>
>  
>
> I am trying to compile the data of various parameters as on every friday.
> Various parameters will be in rows one below the other and date in column.
> What i need now is, when  ever i change the date (i want the drop down menu
> for selecting dates, please note date keeps getting added week after week)
> all the respective details in rows should change by itself, so that the
> performance between any two days can be analysed easily. is there any
> formula or technique for this simple work. 
>
>  
>
> *example *
>
>  
>
> 
>
> date 1,2,3 
>
>  here drop down menu should come, (various dates)
>
> Parameter 1
>
>  
>
>  
>
>  
>
>  
>
>  
>
>  
>
>  
>
> parameter 2
>
>  
>
>  
>
>  
>
>  
>
>  
>
>  
>
>  
>
> Parameter 3
>
>  
>
>  
>
>  
>
>  
>
>  
>
>  
>
>  
>
> Parameter 4
>
>  
>
>  
>
>  
>
>  
>
>  
>
>  
>
>  
>
> Parameter 5
>
>  
>
>  
>
>  
>
>  
>
>  
>
>  
>
>  
>
> Parameter 6
>
>  
>
>  
>
>  
>
>  
>
>  
>
>  
>
>  
>
>  
>
> Please help at the earliest. 
>
>  
>
> Satish P N
>
>  
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>
> ** **
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to

Re: $$Excel-Macros$$ Automatic token numbers

[Haseeb A]

Hello Deba,
 
FYI:
 
If you use "LD000" as constant this will add with each number, means when 
gets 10-99, this will become, LD00010, when gets 100-999 will become 
LD000100.
 
If you want to keep the format, "LD", 1-9 - LD0001, 10-99 - LD0010, 
100-999 - LD0100, 1000- - LD1000, here is one way.
 
A3, then copy down.
 
=IF(B3<>"",TEXT(COUNTA(B$3:B3),"\L\D"),"")
 
Hope this helps,
Haseeb

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

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

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

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

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

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

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

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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

RE: $$Excel-Macros$$ Change in one Cell should lead to change in all related cells

[Rajan_Verma]

 

 

Try this:

 

=TRANSPOSE(OFFSET(INDEX($K$3:$K$10,MATCH(C4,$K$3:$K$10,0),1),,1,,COUNTA($L$5
:$Q$5)))

 

 

Regards

Rajan verma

+91 7838100659 [IM-Gtalk]

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of satish pn
Sent: 22 May 2012 11:11
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Change in one Cell should lead to change in
all related cells

 

Mr. Rajan Verma

 

Please find attached excel file for a small example.

On Tue, May 22, 2012 at 9:10 PM, Rajan_Verma 
wrote:

Please send some sample data in Excel Worksheet

 

 

Regards

Rajan verma

+91 7838100659 [IM-Gtalk]

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of satish pn
Sent: 22 May 2012 8:42
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Change in one Cell should lead to change in all
related cells

 

Hello experts, 

 

I am trying to compile the data of various parameters as on every friday.
Various parameters will be in rows one below the other and date in column.
What i need now is, when  ever i change the date (i want the drop down menu
for selecting dates, please note date keeps getting added week after week)
all the respective details in rows should change by itself, so that the
performance between any two days can be analysed easily. is there any
formula or technique for this simple work. 

 

example 


 


date 1,2,3 

 here drop down menu should come, (various dates)


Parameter 1

 

 

 

 

 

 

 


parameter 2

 

 

 

 

 

 

 


Parameter 3

 

 

 

 

 

 

 


Parameter 4

 

 

 

 

 

 

 


Parameter 5

 

 

 

 

 

 

 


Parameter 6

 

 

 

 

 

 

 


 



Please help at the earliest. 

 

Satish P N

 

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

--
To post to this group, send email to excel-macros@googlegroups.com
 
To unsubscribe, send a blank email to
excel-macros+unsubscr...@googlegroups.com

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

--
To post to this group, send email to excel-macros@googlegroups.com
 
To unsubscribe, send a blank email to
excel-macros+unsubscr...@googlegroups.com
 

 

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

--
To post to this group, send email to excel-macros@googlegroups.com
 
To unsubscribe, send a blank email to
excel-macros+unsubscr...@googlegroups.com

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

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

2) Don't post a question in the

Re: $$Excel-Macros$$ Change in one Cell should lead to change in all related cells

[satish pn]

Mr. Rajan Verma

Please find attached excel file for a small example.

On Tue, May 22, 2012 at 9:10 PM, Rajan_Verma wrote:

> Please send some sample data in Excel Worksheet
>
> ** **
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *satish pn
> *Sent:* 22 May 2012 8:42
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Change in one Cell should lead to change in
> all related cells
>
> ** **
>
> Hello experts, 
>
> ** **
>
> I am trying to compile the data of various parameters as on every friday.
> Various parameters will be in rows one below the other and date in column.
> What i need now is, when  ever i change the date (i want the drop down menu
> for selecting dates, please note date keeps getting added week after week)
> all the respective details in rows should change by itself, so that the
> performance between any two days can be analysed easily. is there any
> formula or technique for this simple work. 
>
> ** **
>
> *example *
>
>  
>
> 
>
> date 1,2,3 
>
>  here drop down menu should come, (various dates)
>
> Parameter 1
>
>  
>
>  
>
>  
>
>  
>
>  
>
>  
>
>  
>
> parameter 2
>
>  
>
>  
>
>  
>
>  
>
>  
>
>  
>
>  
>
> Parameter 3
>
>  
>
>  
>
>  
>
>  
>
>  
>
>  
>
>  
>
> Parameter 4
>
>  
>
>  
>
>  
>
>  
>
>  
>
>  
>
>  
>
> Parameter 5
>
>  
>
>  
>
>  
>
>  
>
>  
>
>  
>
>  
>
> Parameter 6
>
>  
>
>  
>
>  
>
>  
>
>  
>
>  
>
>  
>
>  
>
> Please help at the earliest. 
>
> ** **
>
> Satish P N
>
> ** **
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>

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

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

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

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

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

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

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

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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

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

Re: $$Excel-Macros$$ How to distribute one value into different cells proportionately based on some conditions

[Haseeb A]

Hello Amit,
 
Keep PO Bill & Party Bill on different tab, so can easily update it. See 
the attached.
 
Addition: If you use Table format, formula will automatically insert, when 
you enter a new data. Or use dynamic range to limit calculation range. If 
you wish, you can also create a validation list of Party Bill's then apply 
those in PO Bills column, this way can avoid unnecessary bill numbers.
 
Hope this helps,
Haseeb

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

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

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

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

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

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

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

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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

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

RE: $$Excel-Macros$$ Change in one Cell should lead to change in all related cells

[Rajan_Verma]

Please send some sample data in Excel Worksheet

 

 

Regards

Rajan verma

+91 7838100659 [IM-Gtalk]

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of satish pn
Sent: 22 May 2012 8:42
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Change in one Cell should lead to change in all
related cells

 

Hello experts, 

 

I am trying to compile the data of various parameters as on every friday.
Various parameters will be in rows one below the other and date in column.
What i need now is, when  ever i change the date (i want the drop down menu
for selecting dates, please note date keeps getting added week after week)
all the respective details in rows should change by itself, so that the
performance between any two days can be analysed easily. is there any
formula or technique for this simple work. 

 

example 


 

 
 


date 1,2,3 

 here drop down menu should come, (various dates)


Parameter 1

 

 

 

 

 

 

 


parameter 2

 

 

 

 

 

 

 


Parameter 3

 

 

 

 

 

 

 


Parameter 4

 

 

 

 

 

 

 


Parameter 5

 

 

 

 

 

 

 


Parameter 6

 

 

 

 

 

 

 


 



Please help at the earliest. 

 

Satish P N

 

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

--
To post to this group, send email to excel-macros@googlegroups.com
 
To unsubscribe, send a blank email to
excel-macros+unsubscr...@googlegroups.com

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

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

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

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

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

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

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

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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

$$Excel-Macros$$ Change in one Cell should lead to change in all related cells

[satish pn]

Hello experts,

I am trying to compile the data of various parameters as on every friday.
Various parameters will be in rows one below the other and date in column.
What i need now is, when  ever i change the date (i want the drop down menu
for selecting dates, please note date keeps getting added week after week)
all the respective details in rows should change by itself, so that the
performance between any two days can be analysed easily. is there any
formula or technique for this simple work.

*example *
 date 1,2,3
   here drop down menu should come, (various dates)  Parameter 1
   parameter 2Parameter 3Parameter
4Parameter 5Parameter 6









Please help at the earliest.

Satish P N

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

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

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

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

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

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

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

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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ Double click Bar Charts

[ashish koul]

see if it helps choose product in yellow cell

On Tue, May 22, 2012 at 7:54 AM, pankaj gmail account
wrote:

> Thanks for quick response.
>
> Please find attached data.
>
> I donot want to use pivot table for this.
> this is just a new imagination can we do this in excel. Linked Drill down
> Charts.
>
>
> Thanks and regards,
> Pankaj Michael
>
> On Tue, May 22, 2012 at 7:42 AM, ashish koul wrote:
>
>> can you share the sample data
>>
>>
>> On Tue, May 22, 2012 at 7:40 AM, pankaj gmail account <
>> pankaji...@gmail.com> wrote:
>>
>>> Dear Gurus,
>>>
>>> I want to create a chart with click event or any other option.
>>>
>>> Please suggest :-
>>>
>>> like if i have a bar/pie chart with five products with some sale so i
>>> gets five product bars.
>>> what i wants is when i click on product 2 bar i should get/open product
>>> 2 sales charts linked to it go on further levels also.
>>>
>>>  when i click on product 3 bar i should get/open product 3 sales charts
>>> linked to it go on further levels also.
>>>
>>> Thanks and Regards,
>>>
>>> --
>>> Pankaj Kumar
>>>
>>> --
>>> FORUM RULES (986+ members already BANNED for violation)
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>>
>>> 2) Don't post a question in the thread of another member.
>>>
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>>
>>> 4) Acknowledge the responses you receive, good or bad.
>>>
>>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>>
>>>
>>> --
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> To unsubscribe, send a blank email to
>>> excel-macros+unsubscr...@googlegroups.com
>>
>>
>>
>>
>> --
>> *Regards*
>> * *
>> *Ashish Koul*
>> *http://www.excelvbamacros.com/*
>> *http://www.accessvbamacros.com/* 
>>
>>
>> P Before printing, think about the environment.
>>
>>
>>  --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>>
>
>
>
> --
> Pankaj Kumar
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>



-- 
*Regards*
* *
*Ashish Koul*
*http://www.excelvbamacros.com/*
*http://www.accessvbamacros.com/* 


P Before printing, think about the environment.

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

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

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

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

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

5)  Cross-promotion of

$$Excel-Macros$$ Re: Copy selected grouped object to newslides

[Shah]

I have attached a sample file to show what i mean. I have managed to copy 
the grouped objects from a single slide.
 
However the complication arrises when I have to copy and collate the 
objects when they are on different slides.
i.e. if i want to copy object 1 and 2 from slide 1 and 9 and 10 from slide 
2 and paste them onto a new slide in a new presentation.
 
 

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

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

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

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

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

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

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

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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ How to distribute one value into different cells proportionately based on some conditions

[Amit Gandhi]

Thanks Mr. Anil

You have almost solved my query. But I need it more dynamic. You have made
this formula cell specific and I need the formula which I can copy & paste
across all rows and it will give me result in one instant. Say for example,
if I will add same B/L no again at row 21, i won't get the result. Even if
I will copy the formula of cell J12 to cell J13, it won't work.

Hope you understand my requirement.

I will wait for your expert advise.

Thanks in advance.

Regards

Amit


On Tue, May 22, 2012 at 12:05 PM, Anil Gawli wrote:

> Pls Find Attached file
>
> On Tue, May 22, 2012 at 11:41 AM, Amit Gandhi wrote:
>
>> Hi Experts
>>
>>
>>  I am finding some problem in excel formula, pls help me here. I have a
>> excel data at two locations, 1st is Supplier's Bill details and 2nd is
>> Purchase order details. I need a formula that can distribute the "Party
>> Bill Amount" figure proportionately to "PO Amount" figures based on "B/L#"
>> . You can look into attached Sample File for better understanding. In that
>> file I have shown the result what I want in column "I".
>>
>> Pls help me here.
>>
>> Regards
>>
>> Amit
>>
>>
>>
>>  On Mon, May 21, 2012 at 4:47 PM, Amit Gandhi wrote:
>>
>>> Hi Experts
>>>
>>>
>>>  I am finding some problem in excel formula, pls help me here. I have a
>>> excel data at two locations, 1st is Supplier's Bill details and 2nd is
>>> Purchase order details. I need a formula that can distribute the "Party
>>> Bill Amount" figure proportionately to "PO Amount" figures based on "B/L#"
>>> . You can look into attached Sample File for better understanding. In that
>>> file I have shown the result what I want in column "I".
>>>
>>> Pls help me here.
>>>
>>> Regards
>>>
>>> Amit
>>>
>>> --
>>> FORUM RULES (986+ members already BANNED for violation)
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>>
>>> 2) Don't post a question in the thread of another member.
>>>
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>>
>>> 4) Acknowledge the responses you receive, good or bad.
>>>
>>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>>
>>>
>>> --
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> To unsubscribe, send a blank email to
>>> excel-macros+unsubscr...@googlegroups.com
>>
>>
>>
>>
>>
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>>
>
>
>
> --
> Thanks & Regards,
> Gawli Anil Narayan
> Software Developer,
> Abacus Software Services Pvt Ltd
>
>  --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>



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

Re: $$Excel-Macros$$ Automatic token numbers

[Deba Ranjan]

*Dear Anil and Experts,

  The formula you have given was absolutely correct. Thanks once again for
the same. Thank you very very much.*


Thanks & Regards,
Deba Ranjan P




On Tue, May 22, 2012 at 3:53 PM, hilary lomotey  wrote:

> Just add =if(b3<>"","LD000","")&if(b3<>"",counta(b$3:b3),"")
>
>
> On Tue, May 22, 2012 at 10:10 AM, Deba Ranjan  wrote:
>
>> *
>> *Hi Anil Sir,
>>
>>   Thats fine working, but i need in this look:- LD0001, LD0002,
>> LD0003so on. Can you please do on this !! actually your attached file
>> is fine working in serial numbers. Please i want the serial in LD0001,
>> LD0002so on. Please and thanks Anil sir, and other experts.
>>
>>
>>
>> Thanks & Regards,
>> Deba Ranjan P
>>
>> 
>>
>>
>> On Tue, May 22, 2012 at 2:54 PM, Anil Gawli wrote:
>>
>>> See the attached Sheet.
>>>
>>>
>>> On Tue, May 22, 2012 at 12:32 PM, Deba Ranjan wrote:
>>>
 *Dear Experts and Sir,


 *While on the data entry form in excel, for tracing data in future, i
 am using token numbers. So while filling the data of any person, i use to
 fill token number manually, eg. LD0001, LD0002, LD0003, and so on...Can
 we make by VBA code for automatic token number ?.

Eg. i am filling in the data entry form.

 First person:- devanand
 Mobile:- 124568755
 Town name:- delhi
  Token number:- *LD0001*

If i give summit/ add button, the first person will be added on the
 sheet or traced. If i give another person summit there the token number
 should automatically come as *LD0002, *and so on

   Can you please help me on this experts. Thank you.


 Thanks & Regards,
 Deba Ranjan P

 

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

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

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

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

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

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

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


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

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

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

Re: $$Excel-Macros$$ Automatic token numbers

[hilary lomotey]

Just add =if(b3<>"","LD000","")&if(b3<>"",counta(b$3:b3),"")

On Tue, May 22, 2012 at 10:10 AM, Deba Ranjan  wrote:

> *
> *Hi Anil Sir,
>
>   Thats fine working, but i need in this look:- LD0001, LD0002,
> LD0003so on. Can you please do on this !! actually your attached file
> is fine working in serial numbers. Please i want the serial in LD0001,
> LD0002so on. Please and thanks Anil sir, and other experts.
>
>
>
> Thanks & Regards,
> Deba Ranjan P
>
> 
>
>
> On Tue, May 22, 2012 at 2:54 PM, Anil Gawli wrote:
>
>> See the attached Sheet.
>>
>>
>> On Tue, May 22, 2012 at 12:32 PM, Deba Ranjan wrote:
>>
>>> *Dear Experts and Sir,
>>>
>>>
>>> *While on the data entry form in excel, for tracing data in future, i
>>> am using token numbers. So while filling the data of any person, i use to
>>> fill token number manually, eg. LD0001, LD0002, LD0003, and so on...Can
>>> we make by VBA code for automatic token number ?.
>>>
>>>Eg. i am filling in the data entry form.
>>>
>>> First person:- devanand
>>> Mobile:- 124568755
>>> Town name:- delhi
>>>  Token number:- *LD0001*
>>>
>>>If i give summit/ add button, the first person will be added on the
>>> sheet or traced. If i give another person summit there the token number
>>> should automatically come as *LD0002, *and so on
>>>
>>>   Can you please help me on this experts. Thank you.
>>>
>>>
>>> Thanks & Regards,
>>> Deba Ranjan P
>>>
>>> 
>>>
>>> --
>>> FORUM RULES (986+ members already BANNED for violation)
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>>
>>> 2) Don't post a question in the thread of another member.
>>>
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>>
>>> 4) Acknowledge the responses you receive, good or bad.
>>>
>>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>>
>>>
>>> --
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> To unsubscribe, send a blank email to
>>> excel-macros+unsubscr...@googlegroups.com
>>
>>
>>
>>
>> --
>> Thanks & Regards,
>> Gawli Anil Narayan
>> Software Developer,
>> Abacus Software Services Pvt Ltd
>>
>
>  --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>

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

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

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

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

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

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

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

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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ Automatic token numbers

[Deba Ranjan]

*
*Hi Anil Sir,

  Thats fine working, but i need in this look:- LD0001, LD0002,
LD0003so on. Can you please do on this !! actually your attached file
is fine working in serial numbers. Please i want the serial in LD0001,
LD0002so on. Please and thanks Anil sir, and other experts.


Thanks & Regards,
Deba Ranjan P




On Tue, May 22, 2012 at 2:54 PM, Anil Gawli  wrote:

> See the attached Sheet.
>
>
> On Tue, May 22, 2012 at 12:32 PM, Deba Ranjan  wrote:
>
>> *Dear Experts and Sir,
>>
>>
>> *While on the data entry form in excel, for tracing data in future, i am
>> using token numbers. So while filling the data of any person, i use to fill
>> token number manually, eg. LD0001, LD0002, LD0003, and so on...Can we
>> make by VBA code for automatic token number ?.
>>
>>Eg. i am filling in the data entry form.
>>
>> First person:- devanand
>> Mobile:- 124568755
>> Town name:- delhi
>>  Token number:- *LD0001*
>>
>>If i give summit/ add button, the first person will be added on the
>> sheet or traced. If i give another person summit there the token number
>> should automatically come as *LD0002, *and so on
>>
>>   Can you please help me on this experts. Thank you.
>>
>>
>> Thanks & Regards,
>> Deba Ranjan P
>>
>> 
>>
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>
>
>
>
> --
> Thanks & Regards,
> Gawli Anil Narayan
> Software Developer,
> Abacus Software Services Pvt Ltd
>

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

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

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

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

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

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

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

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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com