Re: $$Excel-Macros$$ Help in Data validation

Hi Rambabu, I was able to derive the result using formula but was unable to do the same through validation. PFA the stop-gap solution. Hope the solution is of some help to you... :) Thanks Vinod On Tue, Mar 1, 2011 at 5:31 PM, Rambabu Mudiraj wrote: > Dear All, > > Can anybody help me on this

Re: $$Excel-Macros$$ 22 days left - Launch of discussexcel.com

Hope i'm not too late in my response... Check out the following: Connoisseur of Excel Virtuoso of Excel... Exceldroit - (Excel + Adroit) > On Tue, Mar 1, 2011 at 7:39 PM, Ayush Jain wrote: > >> Thank you group for all awesome ideas. Though, I was looking for Tagline >> only, you have p

Re: $$Excel-Macros$$ Our NEW Microsoft MVP - Dilip Kumar Pandey

Congratulations!! Dilipji... On Mon, Jan 3, 2011 at 3:31 PM, Ayush wrote: > Dear Group, > > I am very very very very happy to share a good news with you. One of our > dearest group member "Dilip Kumar Pandey" is awarded Microsoft MVP award on > 1st January for his exceptional

Re: $$Excel-Macros$$ lookup function comparing 3 columns

; Srinivasan Ethirajalu, > +919840544295 > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip

Re: $$Excel-Macros$$ Stock Monitoring from Raw data

t; <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 7000 subscribers worldwide and receive many nice notes about > the learn

Re: $$Excel-Macros$$ Help: Date to Days conversion

Hi Janet, Please enter the date in Excel recognizable format i.e., mm/dd/ instead of dd/mm/. Then days can be calculated with the formula you have already entered. Thanks Vinod N On Sat, Sep 18, 2010 at 1:48 PM, janet dickson wrote: > Hi Team, > > I have challenge, see attache

Re: $$Excel-Macros$$ Need help to convert date formate

> Hi vinod, > > > > You are not sending me any attachment please send solve attachment please > > > > > > > > > > > > > > > > > > > > > > > > regards > > Vilas > > On Sat, Aug 28, 2010 at 12:26 PM, Vinod N

Re: $$Excel-Macros$$ Calculation based on changing conditions

t;><><><><><><><><> > HELP US GROW !! > > We reach over 7000 subscribers worldwide and receive many nice notes about > the learning and support from the group.Let friends and co-workers know they > can subscribe to group

Re: $$Excel-Macros$$ Excel

mail to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 7000 subscribers world

Re: $$Excel-Macros$$ hi

In addition to the above, also please check the following link: http://chandoo.org/excel-formulas/vlookup.html <http://chandoo.org/excel-formulas/vlookup.html>Thnx Vinod N On Sat, Aug 28, 2010 at 8:04 PM, rajasekhar praharaju < rajasekhar.prahar...@gmail.com> wrote: > Hi, >

Re: $$Excel-Macros$$ Need help to convert date formate

Oops Missed to attach the file... Now done... On Sun, Aug 29, 2010 at 12:56 AM, Vinod N wrote: > Hi Vilas, > > Please select column A and use Text-to-Columns under Data menu... Next > choose the desired date format from Format--> Cells option.. Solved copy of > your sa

Re: $$Excel-Macros$$ Need help to convert date formate

Hi Vilas, Please select column A and use Text-to-Columns under Data menu... Next choose the desired date format from Format--> Cells option.. Solved copy of your sample file attached... Thanks Vinod N On Sat, Aug 28, 2010 at 7:20 PM, VILAS CHAVAN wrote: > Hi friends, > > Need help

Re: $$Excel-Macros$$ I love excel because.......

witter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blo

Re: $$Excel-Macros$$ Need help in consolidating different excel workbooks in to one work book

el-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><>&

Re: $$Excel-Macros$$ macro or similar

e notes about > the learning and support from the group.Let friends and co-workers know they > can subscribe to group at > http://groups.google.com/group/excel-macros/subscribe > -- Thanks and Regards Vinod N http://cavinod.blogspot.com/ --

Re: Fwd: $$Excel-Macros$$ Macro for Segrating and file creation

Document (File Name - Today's Date in mmddyy format > "sub" and number in Column A. For e.g., 073110 sub 4.xlsx) - *Macro creation pending** - Please HELP* Thanks VInod N On Mon, Aug 9, 2010 at 6:32 AM, pesh wrote: > Hi Vinod, > > This is not the most efficient

$$Excel-Macros$$ Microsoft Most Valuable Professional (MVP)

Hi Team, How about nominating Ayush, Dilip, Ankur and Dave for Microsoft MVP... http://mvp.support.microsoft.com/gp/mvpnominate -- Thanks and Regards Vinod N http://cavinod.blogspot.com/ -- -- Some important

Re: $$Excel-Macros$$ Graph - Question

gt;<><><><><><><><><><> > HELP US GROW !! > > We reach over 7000 subscribers worldwide and receive many nice notes about > the learning and support from the group.Let friends and co-workers know they > can subscribe to group

Re: $$Excel-Macros$$ Interview questions

7000 subscribers worldwide and receive many nice notes about > the learning and support from the group.Let friends and co-workers know they > can subscribe to group at > http://groups.google.com/group/excel-macros/subscribe > -- Thanks and Regards Vinod N http://cavinod.blogspot.

Re: $$Excel-Macros$$ Query - Date Formula

Hi, Please use Data Validation Select the Date option from Allow dropdown and mention the start and end date in that. If you are not satisfied with the above please send a sample data and the group members will reply.. Thanks Vinod N On Sat, Jul 10, 2010 at 2:59 PM, Nikhil Shah wrote

Re: $$Excel-Macros$$ How to get data in Lacs.

) and not 00,000. So relatively for figures are in Lakhs, go to FORMAT CELLS -> Number-> Custom and in "type" field write *0.0,,* (Zero Dot Zero Comma Comma). Even though in the respective cell contains 100,000 it will display as 0.1 only Hope the above solution, fulfills a part of

Re: $$Excel-Macros$$ Do not request or provide copyrighted eBook in group.

-intuitive strategy of giving the whole book away in one download will work fine. Thanks for helping to spread the word about the book! UNQUOTE Moderators: Correct me if i'm wrong Thanks Vinod N On Sun, May 16, 2010 at 1:46 PM, ayush jain wrote: > Thanks Dave for heads up. >

Re: $$Excel-Macros$$ Do No copy excel file or data from that file

ou can download this Windows Right Management Client only if you have a Licensed version. -- Thanks and Regards Vinod N http://cavinod.blogspot.com/ On Sat, May 1, 2010 at 8:05 AM, Vijay Aggarwal wrote: > Hi all, > > Is it possible or not? > > regards, > Vijay > > >

Re: $$Excel-Macros$$ Excel 2007 - Crashing when shared with more than 10 users

l 2007 Compatibility issue, > Please contact or chat with Microsoft Specialist > > > https://support.microsoft.com/oas/default.aspx?gprid=11346&st=1&wfxredirect=1 > > > > > > > > > > > Hope it Will Help > Happy To Help > :) > Prashant Tripa

$$Excel-Macros$$ Excel 2007 - Crashing when shared with more than 10 users

drive as a "Trusted Site" in Excel 3. Re-installed Excel in all the systems... Please help me Thanks and Regards Vinod N http://cavinod.blogspot.com/ -- -- Some important links for excel users: 1. Follow us

Re: $$Excel-Macros$$ Dependent drop down lists

;><><><><><><><> > HELP US GROW !! > > We reach over 6,800 subscribers worldwide and receive many nice notes about > the learning and support from the group.Let friends and co-workers know they > can subscribe to group at > http://groups.google

Re: $$Excel-Macros$$ Help!!!!!!!!!!!!!

Thanks Ankur for your kind words... On Sat, Jan 30, 2010 at 10:40 AM, ankur wrote: > very good approach by vinod > > krishnan , i think your query has been solved , if not plz  explain > more about it > > On 29/01/2010, Vinod N wrote: >> Hi Gopi, >> >> PFA t

Re: $$Excel-Macros$$ VBA MACRO HELP NEEDED

blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > > To post to this group, send email to excel-macros@googlegroups.com > If you find any spam message in the g

Re: $$Excel-Macros$$ Help!!!!!!!!!!!!!

> > We reach over 6,700 subscribers worldwide and receive many nice notes about > the learning and support from the group.Let friends and co-workers know they > can subscribe to group at > http://groups.google.com/group/excel-macros/subscribe > -- Thanks and Regards Vinod

Re: $$Excel-Macros$$ Using IF Condition

;<><><><> > HELP US GROW !! > > We reach over 6,700 subscribers worldwide and receive many nice notes about > the learning and support from the group.Let friends and co-workers know they > can subscribe to group at > http://groups.google.com/group/excel-mac

Re: $$Excel-Macros$$ Delete rows only if the entire row is empty

reply/solve even a single query posted... But I have learnt tonnes of knowledge in the long association with the group... Kudos to the GURUS...!! Love u alll Vinod N On Fri, Jan 22, 2010 at 11:26 AM, Vinod N wrote: > Dear Gurus, > > Macro or any other way in excel where the user sho

$$Excel-Macros$$ Delete rows only if the entire row is empty

Dear Gurus, Macro or any other way in excel where the user should be able to delete rows only if the entire row is empty... Please help... -- Thanks and Regards Vinod N -- -- Some important links for excel users

Re: $$Excel-Macros$$ GetUnique_Collection - to capture numeric values

Read hear as Hurt 2009/12/24 Vinod N > Hi Rf1234, > > I dint mean to hear ur feelings Dave's reply was more appropriate for > my requirement.. i need to check the alternative given by you... > > Anyways.. Thanks a Tonn!!! > > Vinod N > > On Thu, Dec 2

Re: $$Excel-Macros$$ GetUnique_Collection - to capture numeric values

Hi Rf1234, I dint mean to hear ur feelings Dave's reply was more appropriate for my requirement.. i need to check the alternative given by you... Anyways.. Thanks a Tonn!!! Vinod N On Thu, Dec 24, 2009 at 10:51 AM, Dave Bonallack wrote: > Huh? > > ---

Re: $$Excel-Macros$$ GetUnique_Collection - to capture numeric values

m UniqArray(1 To UniqColl.Count) > For i = 1 To UniqColl.Count > UniqArray(i) = UniqColl(i) > Next > 'Optional sort routine can be inserted here > Range("j3").Resize(UniqColl.Count, 1).Value = > WorksheetFunction.Transpose(UniqArray) > End Sub > > -- > Than

$$Excel-Macros$$ GetUnique_Collection - to capture numeric values

UniqColl.Count) For i = 1 To UniqColl.Count UniqArray(i) = UniqColl(i) Next 'Optional sort routine can be inserted here Range("j3").Resize(UniqColl.Count, 1).Value = WorksheetFunction.Transpose(UniqArray)

Re: $$Excel-Macros$$ Need help on Validation

Hi Ankur, When "Tamilnadu" is selected, the Hub validation is not working... all other regions are working fine... Please check and revert.. A new learning about data validation Thanks a lott... Thanks Vinod N On Tue, Dec 22, 2009 at 3:44 PM, ankur wrote: > hi mahesh &

Re: $$Excel-Macros$$ Locking/Freezing a range of cells

; > Thanks & Regards, > > Harmeet Singh > > Sent via BlackBerry Wireless > > > On Sun, Dec 20, 2009 at 9:00 PM, Vinod N wrote: > >> Hi Excel Gurus, >> >> I have an shared excel file saved in the shared folder... >> >> I want to allow users t

$$Excel-Macros$$ Locking/Freezing a range of cells

Vinod N -- -- 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 http://www.excel-macros.blogspot.com 3. Learn VBA

$$Excel-Macros$$ VBA code - required - Printout directly from a folder

gards Vinod N -- -- 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 http://www.excel-macros.blogspot.com 3.

Re: $$Excel-Macros$$ VBA Security - Restrict Users from Editing VBA Macros

option in tool. Remeber some software do not ask for serial keys. :) >> >> Thanks & Best Regards, >> >> -- >> DILIP KUMAR PANDEY >>MBA-HR,B COM(Hons.),BCA >> Mobile: +91 9810929744 >> dilipan...@gmail.com >> dilipan...@yahoo.com >&

Re: $$Excel-Macros$$ VBA Security - Restrict Users from Editing VBA Macros

> DILIP KUMAR PANDEY >MBA-HR,B COM(Hons.),BCA > Mobile: +91 9810929744 > dilipan...@gmail.com > dilipan...@yahoo.com > New Delhi - 110062 > > > On 12/9/09, Vinod N wrote: > >> Hi, >> >> >> Can you suggest any site which will help me in breaki

Re: $$Excel-Macros$$ VBA Security - Restrict Users from Editing VBA Macros

Hi, Can you suggest any site which will help me in breaking/cracking the password ? A year back i had created few macros..but ironically i have forgotten the password and the macros need to be changed with course of time and environment... Thanks Vinod N On Mon, Dec 7, 2009 at 5:34 AM

$$Excel-Macros$$ Re: Calculate 10 working days from a given date

or a day earlier) and the *resultant date** **should not fall on a US federal holidays,Sat or Sun* Thanks in advance Vinod N On Sun, Oct 4, 2009 at 4:10 PM, Dilip Pandey wrote: > Hi Vinod, > > You can use an inbuilt function of Excel viz. "Workday" to achive the > req

$$Excel-Macros$$ Calculate 10 working days from a given date

formula or a Macro.. Your help in this matter is highly appreciated. -- Thanks and Regards Vinod N --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA

$$Excel-Macros$$ Macro - Copy data from one sheet and fill in another sheet with a separate requirement.

files) I need to cater many cities and populating this type of report is really time consuming and i'm ending up stretching in office for about 3-4 hours on a daily basis If possible, please suggest an alternative... -- Thanks and Regards Vi