subject:"Re\: $$Excel\-Macros$$ Please help to make my project good."

RE: RE: $$Excel-Macros$$ Please help to make my project good.

2011-06-13 Thread Susan

Thank you!

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of GoldenLance
Sent: Monday, June 13, 2011 7:14 AM
To: excel-macros@googlegroups.com
Subject: Re: RE: $$Excel-Macros$$ Please help to make my project good.

 

=SUM(OFFSET(A5,0,0,MATCH(MAX(A$5:A$999),A$5:A$999,1),1)), copy this to A2,
and then copy across to other cells

-- 

--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com
 
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: RE: $$Excel-Macros$$ Please help to make my project good.

2011-06-13 Thread GoldenLance

=SUM(OFFSET(A5,0,0,MATCH(MAX(A$5:A$999),A$5:A$999,1),1)), copy this to A2, 
and then copy across to other cells

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

RE: $$Excel-Macros$$ Please help to make my project good.

2011-06-12 Thread Susan

Hi,

Please see attached spreadsheet in sheet named Practice OFFSET for my question. 
 Basically, how do you edit the formula to keep summing the column if you skip 
a cell in the column and enter numbers at random cells in the same column.

 

Thanks

~Sunnie

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
Behalf Of §»VIPER«§
Sent: Wednesday, May 11, 2011 10:36 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Please help to make my project good.

 

pfa




On Thu, May 12, 2011 at 12:31 AM, Mahesh parab  wrote:

Hi

 

check whether attach file helps.

On Wed, May 11, 2011 at 3:51 PM, karan 1237  wrote:

Respected Sirs/Mam,

I need your help making my project good.  Please find attachment. I will be 
very obliged if someone can help me as earlier as possible.

--
Basically I have to do that when I click on drop down list & select another 
career i.e. Building and Construction so In sub career list data should comes 
from the Building and construction's sheet and If I select another career i.e. 
Catering and Hospitality so data should comes from its list (Catering and 
Hospitality) and scroll bar should work with the same. I have 16 careers so 
please tell me how can I do this.


Thnx in Advance



ııııllıı ~ ♣ кαяαηη ♣ ~ ııııllıı

 

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com 
<http://www.excel-macros.blogspot.com/> 
4. Learn VBA Macros at http://www.quickvba.blogspot.com 
<http://www.quickvba.blogspot.com/> 
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com 
<http://exceldailytip.blogspot.com/> 

To post to this group, send email to excel-macros@googlegroups.com
 
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

 

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com
 
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel




-- 
Thanks & Regards

Thamu

 

 

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com
 
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


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

Re: $$Excel-Macros$$ Please help to make my project good.

2011-05-14 Thread Fabio Lemos

You also could simplify the formula by inserting the following in the E2
cell:

=OFFSET(INDIRECT("'"&$A$2&"'!$A$1";TRUE);$C$21+ROW(E2)-2;0)

And tham just copy to the other

2011/5/13 Zafar Iqbal 

>  Dear, With due respect to your effort, I tried with a simplified formula
> and got the same result. Please the attached file with both formulas. Thanks
>
>
>
> Regards,
>
> ZAFAR IQBAL
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *§»VIPER«§
> *Sent:* Thursday, May 12, 2011 8:36 AM
>
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Please help to make my project good.
>
>
>
> pfa
>
>  On Thu, May 12, 2011 at 12:31 AM, Mahesh parab 
> wrote:
>
> Hi
>
>
>
> check whether attach file helps.
>
> On Wed, May 11, 2011 at 3:51 PM, karan 1237  wrote:
>
> Respected Sirs/Mam,
>
> I need your help making my project good.  Please find attachment. I will be
> very obliged if someone can help me as earlier as possible.
>
> --
> Basically I have to do that when I click on drop down list & select another
> career i.e. Building and Construction so In sub career list data should
> comes from the Building and construction's sheet and If I select another
> career i.e. Catering and Hospitality so data should comes from its list
> (Catering and Hospitality) and scroll bar should work with the same. I have
> 16 careers so please tell me how can I do this.
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
Fabio Lemos

e-mail: flnle...@gmail.com

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Please help to make my project good.

2011-05-12 Thread §»VIPER«§

pfa



On Thu, May 12, 2011 at 12:31 AM, Mahesh parab  wrote:

> Hi
>
> check whether attach file helps.
>
> On Wed, May 11, 2011 at 3:51 PM, karan 1237  wrote:
>
>> Respected Sirs/Mam,
>>
>> I need your help making my project good.  Please find attachment. I will
>> be very obliged if someone can help me as earlier as possible.
>>
>> --
>> Basically I have to do that when I click on drop down list & select
>> another career i.e. Building and Construction so In sub career list data
>> should comes from the Building and construction's sheet and If I select
>> another career i.e. Catering and Hospitality so data should comes from its
>> list (Catering and Hospitality) and scroll bar should work with the same. I
>> have 16 careers so please tell me how can I do this.
>>
>>
>> Thnx in Advance
>>
>> ııııllıı ~ ♣ кαяαηη ♣ ~ ııııllıı
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>  --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
*Thanks & Regards

Thamu
*

*
*

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


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

RE: $$Excel-Macros$$ Please help to make my project good.

2011-05-12 Thread Anil Bhange

Hi Karan,

Use this formula,

=OFFSET(IF($A$2="Administration, Business and Office Work",'Administration, 
Business and Of'!A1,IF($A$2="Building and Construction",'Building and 
Construction'!B1,'Catering and Hospitality'!A1)),'Building and 
Construction'!$I$2,0)

And copy in all your gray cells

Regards,Anil Bhange
IP Phone - 512320 | Mobile - 90290 32123

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
Behalf Of karan 1237
Sent: Wednesday, May 11, 2011 3:51 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Please help to make my project good.

Respected Sirs/Mam,

I need your help making my project good.  Please find attachment. I will be 
very obliged if someone can help me as earlier as possible.

--
Basically I have to do that when I click on drop down list & select another 
career i.e. Building and Construction so In sub career list data should comes 
from the Building and construction's sheet and If I select another career i.e. 
Catering and Hospitality so data should comes from its list (Catering and 
Hospitality) and scroll bar should work with the same. I have 16 careers so 
please tell me how can I do this.


Thnx in Advance

ııııllıı ~ ♣ кαяαηη ♣ ~ ııııllıı

--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Please help to make my project good.

2011-05-11 Thread Mahesh parab

Hi

check whether attach file helps.

On Wed, May 11, 2011 at 3:51 PM, karan 1237  wrote:

> Respected Sirs/Mam,
>
> I need your help making my project good.  Please find attachment. I will be
> very obliged if someone can help me as earlier as possible.
>
> --
> Basically I have to do that when I click on drop down list & select another
> career i.e. Building and Construction so In sub career list data should
> comes from the Building and construction's sheet and If I select another
> career i.e. Catering and Hospitality so data should comes from its list
> (Catering and Hospitality) and scroll bar should work with the same. I have
> 16 careers so please tell me how can I do this.
>
>
> Thnx in Advance
>
> ııııllıı ~ ♣ кαяαηη ♣ ~ ııııllıı
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


Help_Required_Solution.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Please help to make my project good.

2011-05-11 Thread STDEV(i)

please check the attachment if it helps..

best regards,
STDEV(i)


note:
we need dynamic* Max Value* of ScrollBar
so we use Scroolbar from ActiveX Control, instead of from FORM.
A little macro wil work each time you change the "career"



On Wed, May 11, 2011 at 5:21 PM, karan 1237  wrote:

> Respected Sirs/Mam,
>
> I need your help making my project good.  Please find attachment. I will be
> very obliged if someone can help me as earlier as possible.
>
> --
> Basically I have to do that when I click on drop down list & select another
> career i.e. Building and Construction so In sub career list data should
> comes from the Building and construction's sheet and If I select another
> career i.e. Catering and Hospitality so data should comes from its list
> (Catering and Hospitality) and scroll bar should work with the same. I have
> 16 careers so please tell me how can I do this.
>
>
> Thnx in Advance
>
> ııııllıı ~ ♣ кαяαηη ♣ ~ ııııllıı
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


ctv_Indirect And Address FUNCTION.xlsb
Description: application/vnd.ms-excel.sheet.binary.macroenabled.12

RE: RE: $$Excel-Macros$$ Please help to make my project good.

Re: RE: $$Excel-Macros$$ Please help to make my project good.

RE: $$Excel-Macros$$ Please help to make my project good.

Re: $$Excel-Macros$$ Please help to make my project good.

Re: $$Excel-Macros$$ Please help to make my project good.

RE: $$Excel-Macros$$ Please help to make my project good.

Re: $$Excel-Macros$$ Please help to make my project good.

Re: $$Excel-Macros$$ Please help to make my project good.

8 matches

Site Navigation

Mail list logo

Footer information