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 rambabu1...@gmail.comwrote: Dear All, Can

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

Vinod N http://cavinod.blogspot.com/ -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http

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 janetdicks...@gmail.comwrote: Hi Team, I have challenge

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

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.com

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

attachment please regards Vilas On Sat, Aug 28, 2010 at 12:26 PM, Vinod N nvino...@gmail.com 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

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

://groups.google.com/group/excel-macros/subscribe -- Thanks and Regards Vinod N http://cavinod.blogspot.com/ -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http

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 nvino...@gmail.com 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 sample file

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.htmlThnx Vinod N On Sat, Aug 28, 2010 at 8:04 PM, rajasekhar praharaju rajasekhar.prahar...@gmail.com wrote: Hi, Adding

Re: $$Excel-Macros$$ Excel

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.com

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

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 at http://groups.google.com/group/excel-macros/subscribe -- Thanks and Regards Vinod N http

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

!! 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 at http://groups.google.com/group/excel-macros/subscribe -- Thanks and Regards Vinod N http

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

., 073110 sub 4.xlsx) - *Macro creation pending** - Please HELP* Thanks VInod N On Mon, Aug 9, 2010 at 6:32 AM, pesh alpes...@gmail.com wrote: Hi Vinod, This is not the most efficient way, however I did not have enough time to make it ideal. I have re-used code found on the web in certain

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

subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- Thanks and Regards Vinod N http://cavinod.blogspot.com/ -- -- Some important links for excel users: 1. Follow us on TWITTER for tips

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

Re: $$Excel-Macros$$ Interview questions

@googlegroups.com 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 at http://groups.google.com/group/excel-macros/subscribe -- Thanks and Regards Vinod

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

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 jainayus...@gmail.com wrote: Thanks Dave for heads up

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

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 your query. Thanks Vinod N On Tue, May

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

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 vjaggarwal2...@gmail.comwrote: Hi all, Is it possible or not? regards, Vijay On Tue, Apr 27, 2010

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

This is excel 2007 Compatibility issue, Please contact or chat with Microsoft Specialist https://support.microsoft.com/oas/default.aspx?gprid=11346st=1wfxredirect=1 Hope it Will Help Happy To Help :) Prashant Tripathi On Fri, Apr 9, 2010 at 5:21 AM, Vinod N nvino...@gmail.com wrote

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

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 on TWITTER for tips tricks

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

Vinod N -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 3

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

they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- Thanks and Regards Vinod N -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links

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

Thanks Ankur for your kind words... On Sat, Jan 30, 2010 at 10:40 AM, ankur ankurpande...@gmail.com 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 nvino...@gmail.com wrote: Hi Gopi, PFA

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

-macros/subscribe -- Thanks and Regards Vinod N -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video

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

Vinod N -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http

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

/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 nvino...@gmail.com wrote: Dear Gurus, Macro or any other way in excel where the user

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

(UniqColl.Count, 1).Value = WorksheetFunction.Transpose(UniqArray) End Sub -- Thanks and Regards Vinod N -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins

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 davebonall...@hotmail.comwrote: Huh

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

Read hear as Hurt 2009/12/24 Vinod N nvino...@gmail.com 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

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

Wireless On Sun, Dec 20, 2009 at 9:00 PM, Vinod N nvino...@gmail.com wrote: Hi Excel Gurus, I have an shared excel file saved in the shared folder... I want to allow users to use from Range A21:K3020. I tried protecting the worksheet but there are many limitation. Is there other way of locking

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 ankurpande...@gmail.com wrote: hi mahesh

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

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 -- Thanks and Regards Vinod N

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

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

MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 12/9/09, Vinod N nvino...@gmail.com wrote: Hi, Can you suggest any site which will help me in breaking/cracking the password ? A year back i had created few macros

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

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

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

MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 12/9/09, Vinod N nvino...@gmail.com wrote: Hi, Can you suggest any site which will help me in breaking/cracking the password ? A year back i had created few macros

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 dilipan...@gmail.com wrote: Hi Vinod, You can use an inbuilt function of Excel viz. Workday to achive the required

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

a 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 Vinod N