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

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

Congrats. On Wed, Feb 1, 2012 at 10:11 PM, Ayush Jain jainayus...@gmail.com 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

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

Congrats. On 1/5/12, Venkat CV venkat1@gmail.com wrote: Congrats...Rajan All... -- *Best Regards,* *Venkat * *Chennai* *My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71* * * On Wed, Jan 4, 2012 at 11:29 PM, Ayush Jain jainayus...@gmail.com wrote: Sam,

$$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

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

Of *Subhash Yadav *Sent:* Jan/Tue/2012 07:48 *To:* excel-macros@googlegroups.com *Subject:* $$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

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

Thank u Noorain... On Fri, Nov 25, 2011 at 11:58 AM, jmothilal gjmothi...@gmail.com wrote: THANKS SO MUCH J.MOTHILAL On Fri, Nov 25, 2011 at 11:46 AM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Group, Please find attached some tips to learn Excel. - Thanks regards,

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 dilipan...@gmail.com wrote: Congratulations NOORAIN. sorry for late responss as I was running behind on my email. Regards, DILIPandey On 2 Oct 2011 00:43

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 chatterjee.kolk...@gmail.com wrote: Dear All Please go through the mail and help me. Ragards, sanjib -- Forwarded message -- From: Sanjib Chatterjee

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

Please update... Subhash Yadav On Mon, Jul 25, 2011 at 7:00 PM, Subhash Yadav scy2...@gmail.com 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 want

$$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

$$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 --

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 vasant...@gmail.com 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 = 1050

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 scy2...@gmail.com 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 at 6:16 AM, ashish koul

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

Please help me out. On Tue, Jun 21, 2011 at 10:09 AM, Subhash Yadav scy2...@gmail.com 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 are 300,550,800,1050,1300,1550 etc

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 koul.ash...@gmail.com wrote: @ICWAI Help - subhash has already attached the file. please check the mail trail @subash

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

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

Thanks a lot my friend On Wed, Jun 8, 2011 at 10:01 PM, ashish koul koul.ash...@gmail.com 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 scy2