$$Excel-Macros$$ Re: Help on formula

2009-09-01 Thread Dilip Pandey
Hi Vidyut, Attached workbook has the solution for your query. Thanks. -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Tue, Sep 1, 2009 at 12:15 PM, vidyut more wrote: > Hi, > Dilip I have another query for

$$Excel-Macros$$ Require tabs to be seen.

2009-09-01 Thread raghavendra br
Hello Group, Good Afternoon!! Kindly help me on this query- "I need to get column tabs such as (a,b) & row tabs (1,2) when i take a print of an excel sheet". Thanking you in advance. -- With Luv Rags!!! --~--~-~--~~~---~--~~ -

$$Excel-Macros$$ Help Please

2009-09-01 Thread prashant
Dear All, Please help as per attachment Thx in advance Regards, Prashant --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Vide

$$Excel-Macros$$ Help on formula

2009-09-01 Thread vidyut more
Hi, Dilip I have another query for you. I am attaching excel sheet. in that sheet i want formula that will look last PC No. of quality no and add last pc no +1 in new entry. I know it can done by VBA. but iwant to know can it possible in excel.Thanks in advance. --~--~-~--~~---

$$Excel-Macros$$ Re: help pc mo formula

2009-09-01 Thread Dilip Pandey
Hi Vidyut, Attached below is the revised solution as per your change request. Thanks -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Tue, Sep 1, 2009 at 3:19 PM, vidyut more wrote: > Hi thank for quick rep

$$Excel-Macros$$ Re: Require tabs to be seen.

2009-09-01 Thread Dave Bonallack
Hi, In XL2003 and 2000: FILE > PAGE SETUP > SHEET tab, tick 'Row and Column Headings' Regards - Dave. Date: Tue, 1 Sep 2009 13:30:18 +0530 Subject: $$Excel-Macros$$ Require tabs to be seen. From: br.raghaven...@gmail.com To: excel-macros@googlegroups.com Hello Group, Good Afternoon!! Kindly he

$$Excel-Macros$$ Re: Auto complete list popup windo in excel

2009-09-01 Thread Prashanth Banneni
Hello Dilip Sir, If there is data in the same column above then Press Alt+ Down Arrow. This will show the list of the unique values above. As i am a beginner in excel Let me know if this is a valid sugestion. Thanks Prashanth On Tue, Sep 1, 2009 at 10:36 AM, Dilip Pandey wrote: > Hi Vidyut

$$Excel-Macros$$ Re: Require tabs to be seen.

2009-09-01 Thread Amitabh Bose
Hi Rag, You can print with the row and column headings by: 1. Going to print preview 2. Page Set-up 3. Choose the 'sheet' tab 4. Select the 'Row and Column headings' option. Thanks, Amitabh Date: Tue, 1 Sep 2009 13:30:18 +0530 Subject: $$Excel-Macros$$ Require tabs to be see

$$Excel-Macros$$ Re: Help on formula

2009-09-01 Thread vijay Kumar
Use max formulae On Tue, Sep 1, 2009 at 12:15 PM, vidyut more wrote: > Hi, > Dilip I have another query for you. I am attx aching excel sheet. in > that sheet i want formula that will look last PC No. of quality no and > add last pc no +1 in new entry. I know it can done by VBA. but iwant > t

$$Excel-Macros$$ Re: How i can arrange data in Random manner

2009-09-01 Thread Umakant Hale
Dear friends, but in output i require same value in Random Manner wahtever mentioned in first column pls help will you help On Wed, Aug 26, 2009 at 9:50 PM, Harmeet Singh wrote: > see attached file > > On Wed, Aug 26, 2009 at 8:23 PM, Dilip Pandey wrote: > >> Hi Umakant, >> >> Attached sheet has

$$Excel-Macros$$ Re: Auto complete list popup windo in excel

2009-09-01 Thread Dilip Pandey
Hi Prashanth, Off-Course it is a valid suggestion.!!! -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Tue, Sep 1, 2009 at 5:59 PM, Prashanth Banneni wrote: > Hello Dilip Sir, > > If there is data in the same

$$Excel-Macros$$ Vlookup Value

2009-09-01 Thread Ashwin Gopinath
--~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at htt

$$Excel-Macros$$ Re: Ignore my previous mail

2009-09-01 Thread Dilip Pandey
You are always welcome...!!! Let me know if you need any further help from my side. -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 9/1/09, vidyut more wrote: > > Hi. > Dilip plz ignore my previous mail. i

$$Excel-Macros$$ Re: Vlookup Value

2009-09-01 Thread Dilip Pandey
Hi Ashwin, I believe you need multiple values based on single criteria across the data range. Same is done and attached herewith. Thanks -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 9/2/09, Ashwin Gopin

$$Excel-Macros$$ Macro for Retrieve Messages of Outlook mails

2009-09-01 Thread Deepak Rawat
Hi All I have to Retrieve messages of Outlook mails of selected folders. could it be done by macro, please help!! Regards, Deepak --~--~-~--~~~---~--~~ -- Some important links for excel

$$Excel-Macros$$ Re: Ignore my previous mail

2009-09-01 Thread MOKSH..........
Hi Mr Dilip moksh this side i need ur help actualy i need to know about the class module in vba 2009/9/2 Dilip Pandey > You are always welcome...!!! > > Let me know if you need any further help from my side. > -- > DILIP KUMAR PANDEY >MBA-HR,B COM(Hons.),BCA > Mobile: +91 9810929744 > dilip