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 :

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

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

2011-06-12 Thread Susan
@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 mahes...@gmail.com wrote: Hi

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

2011-05-15 Thread Zafar Iqbal
@googlegroups.com] On Behalf Of Fabio Lemos Sent: Saturday, May 14, 2011 7:03 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Please help to make my project good. You also could simplify the formula by inserting the following in the E2 cell: =OFFSET(INDIRECT('$A$2'!$A$1;TRUE

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

2011-05-15 Thread Zafar Iqbal
-macros@googlegroups.com' Subject: $$Excel-Macros$$ Please help to make my project good. Dear Mr. Fabio Lemos, Thanks for your interest. I tried to apply your below mentioned formula. I am getting error message. Can you please send me sample file with formula. Thanks a lot for this kindness

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

2011-05-13 Thread Zafar Iqbal
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 mahes...@gmail.com wrote: Hi check whether attach file helps. On Wed, May 11, 2011 at 3:51 PM, karan 1237 karan1

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

2011-05-12 Thread Anil Bhange
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

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 mahes...@gmail.com wrote: Hi check whether attach file helps. On Wed, May 11, 2011 at 3:51 PM, karan 1237 karan1...@gmail.com wrote: Respected Sirs/Mam, I need your help making my project good. Please find attachment. I will be very

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

2011-05-11 Thread karan 1237
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

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

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 karan1...@gmail.com 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