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: 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://t

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 wrote: Hi check whether

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

2011-05-14 Thread Fabio Lemos
y 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. &

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

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 R

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

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