$$Excel-Macros$$ Solution required

Dear Members, I wnat one solution for switch between sheet. 1. I am having on file containing 12 sheets and i have to work between the two sheets (sheet 2 & sheet 11) alternatively. If any shorcut key is there to switch between sheets. Sheets are no adjuscent othewise I can use ctrl+page up, down

Re: $$Excel-Macros$$ Most Helpful Member Feb'12 - Noorain Ansari

Congrats Noorain Keep it up On Thu, Mar 15, 2012 at 4:19 AM, Ayush Jain wrote: > Hello Everyone, > > Noorain Ansari has been selected as 'Most Helpful Member' for the month of > Feb'12 > He has posted 156 posts in Feb'12 and helped many people through his > expertise. He has been consistent

Re: $$Excel-Macros$$ Most Helpful Member Jan'12 - Noorain Ansari

Congrats. On Wed, Feb 1, 2012 at 10:11 PM, Ayush Jain wrote: > Hello Everyone, > > Noorain Ansari has been selected as 'Most Helpful Member' for the month of > Jan'12 > He has posted 175 posts in Jan'12 and helped many people through his > expertise. He has been consistent contributor t

Re: $$Excel-Macros$$ Rajan verma : Most Helpful Member- Dec'2011

Congrats. On 1/5/12, Venkat CV wrote: > Congrats...Rajan& All... > > -- > *Best Regards,* > *Venkat * > *Chennai* > *My Linked in profile * > * > * > > On Wed, Jan 4, 2012 at 11:29 PM, Ayush Jain wrote: > >> Sam, Welcome back to the group.

Re: $$Excel-Macros$$ Book to learn Access 2007

thanks a lot.. On Tue, Jan 3, 2012 at 8:09 PM, Rajan_Verma wrote: > Download this book: > > http://www.4shared.com/office/kSyv-Z27/MS_Access_2007_Data_Analysis.html** > ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Beh

$$Excel-Macros$$ Book to learn Access 2007

Can any body provide book to learn MS Access 2007? Thanks, Subhash -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick att

Re: $$Excel-Macros$$ Excel learning Institute

Thank u Noorain... On Fri, Nov 25, 2011 at 11:58 AM, jmothilal wrote: > THANKS SO MUCH > > J.MOTHILAL > > > On Fri, Nov 25, 2011 at 11:46 AM, NOORAIN ANSARI > wrote: > >> Dear Group, >> >> Please find attached some tips to learn Excel. >> >> - >> Thanks & regards, >> Noorain Ansari >> *http:/

Re: $$Excel-Macros$$ Most Helpful Member Sep'11 - Noorain Ansari

Congratulations Noorain... Thanks for your helps provided.. Regards, Subhash Yadav On Thu, Oct 13, 2011 at 8:51 PM, Dilip Pandey wrote: > Congratulations NOORAIN. > > sorry for late responss as I was running behind on my email. > > Regards, > DILIPandey > On 2 Oct 20

Re: $$Excel-Macros$$ Fwd: date format help

You can select the date format as dd-mmm- format cell option. On 30 Sep 2011 13:19, "Sanjib Chatterjee" wrote: > Dear All > > Please go through the mail and help me. > > Ragards, > > sanjib > > -- Forwarded message -- > From: Sanjib Chatterjee > Date: Fri, Sep 30, 2011 at 12:1

Re: $$Excel-Macros$$ Help for combo box

Please update... Subhash Yadav On Mon, Jul 25, 2011 at 7:00 PM, Subhash Yadav wrote: > Dear friends > > I require some help regarding Vlookup function conunction with Combo Box. > > I want vlookup in the combobox with respect to selected value in another > combo box. Also wa

$$Excel-Macros$$ Vlookup against the value generated from formula

When I m trying to use to formula VLOOKUP against any formula generated value, there is error. Please suggest suitable method for the same, as I have to take many of the value based n these types of conditions. Sample file attached. -- Subhash Chand Yadav -- -

$$Excel-Macros$$ Help for combo box

Dear friends I require some help regarding Vlookup function conunction with Combo Box. I want vlookup in the combobox with respect to selected value in another combo box. Also want to put value in any cell against the value selected in combo box. Sample file is attached. -- Subhash Chand Yad

Re: $$Excel-Macros$$ Solution required for preparing Schedule

Can you please help me in workbook.. Regards, Subhash yadav On Tue, Jun 28, 2011 at 2:02 PM, Vasant wrote: > Sorry...correction. > > use this. > > Public Function CalculateType(Rng As Range) > If Rng.Value = 300 Or Rng.Value = 550 Or Rng.Value = 800 Or Rng.Value > = 105

Re: $$Excel-Macros$$ Solution required for preparing Schedule

Please help me out. On Tue, Jun 21, 2011 at 10:09 AM, Subhash Yadav wrote: > Dear Experts, > > Please refer my attached file for which i want solution. > > My queries are: > > 1. In the "type" column - Value is "previous type+50". but if the values

Re: $$Excel-Macros$$ solution to put data automtically

Please help me out. Regards, Subhash Yadav On Wed, Jun 22, 2011 at 2:11 PM, Subhash Yadav wrote: > No, this is daily entry sheet for fuel issued to equipments. This will > continue for years. > > > Regards, > > > Subhash Yadav > > On Wed, Jun 22, 2011

Re: $$Excel-Macros$$ solution to put data automtically

No, this is daily entry sheet for fuel issued to equipments. This will continue for years. Regards, Subhash Yadav On Wed, Jun 22, 2011 at 6:16 AM, ashish koul wrote: > @ICWAI Help - subhash has already attached the file. please check the > mail trail > > @subash - is there any

Re: $$Excel-Macros$$ solution to put data automtically

Dear friend, One more doubt. If we forget to put for any perticular date and we put later on the date shoud come against the latest date and the asset code. Sample is attached for your reference. Regards, Subhash Yadav On Wed, Jun 8, 2011 at 10:01 PM, ashish koul wrote: > issue = IN

Re: $$Excel-Macros$$ solution to put data automtically

Thanks a lot my friend On Wed, Jun 8, 2011 at 10:01 PM, ashish koul wrote: > issue = INDEX(E:E,SUMPRODUCT(MAX(($A$4:A10=A11)*ROW($A$4:A10))),0) > > reading =INDEX(F:F,SUMPRODUCT(MAX(($A$4:A10=A11)*ROW($A$4:A10))),0) > > > On Wed, Jun 8, 2011 at 7:03 PM, Subhash Yadav

$$Excel-Macros$$ solution to put data automtically

Dear friends, I am having one sheet containing data for fuel issue. I want, if i put any asset code previous issue and previous reading should come from the latest present issue and present reading of same asset. In the attached sheet yellow cell date should come in yellow cell and magenta cell