Re: $$Excel-Macros$$ Please help on the data validation

2012-05-29 Thread Naresh V
Smitha, Using developer tab Insert Combo box from Activex controls. Then right click on the combo box, select properties. Now write the source opposit to "Listfillrange". It works Thanks, Naresh V On Tue, May 29, 2012 at 10:04 AM, Bé Trần Văn wrote: > > > 2012

Re: $$Excel-Macros$$ Time Difference

2012-05-16 Thread Naresh V
On Wed, May 16, 2012 at 8:04 AM, Mangesh Dayne wrote: > Hi Friends, > > Please help me on this issue. > > Please refer the attached file. > > In file, I need time at other countries depending on the time in Mumbai. > Time difference is mentioned in the sheet. > Please help me by providing answer/

Re: $$Excel-Macros$$ IF Function

2012-05-16 Thread Naresh V
Hi Smitha, Can you please send sample file. So that we can help you. In If function you can add any function. Thanks, Naresh V On Wed, May 16, 2012 at 7:11 AM, Smitha S R wrote: > How can we add so many conditions in IF function? > > -- > FORUM RULES (986+ mem

$$Excel-Macros$$ copy data from excel to Notepad using VBA code

2012-03-21 Thread Naresh V
Team, I have data in excel sheet column E, this data should paste in new notepad after that column E copymode must be normal. (Cutcopymode=false) can you please provide code for this Thanks in advance... Regards, Naresh V -- FORUM RULES (986+ members already BANNED for

$$Excel-Macros$$ Need Vba code to count no.of values in a column

2012-03-15 Thread Naresh V
Group, Can you please provide the vba code for count no.of values in a column. Ex: *A clumn B column* 1 23 44 55 12 71 I want code to count A column Regards, Naresh V -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like

$$Excel-Macros$$ how to consalidate from more sheets to one sheet

2011-09-14 Thread naresh v
attached excel. Thanks and Regards, Naresh V, -- -- 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

$$Excel-Macros$$ vba help

2011-09-09 Thread naresh v
, naresh v -- -- 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://www.linkedin.com/groups?gid=1871310 3

$$Excel-Macros$$ Like pivot table function

2011-08-11 Thread naresh v
Hi friends, I have attached one excel, can you please help me .. Regards, Naresh V -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2

$$Excel-Macros$$ Can you please help regd. lists

2011-08-10 Thread naresh v
t; it should show the "Maharastra", "UP" like that can you please help me... Regards, Naresh V -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http:/

$$Excel-Macros$$ Need Institue in Hyd

2011-05-10 Thread naresh v
Hi Group, I want to learn Excel VBA, Can you please provide any coaching center in Hyderabad.. Please do the needful, Naresh V Analyst -- -- Some important links for excel users: 1. Follow us on TWITTER for tips

$$Excel-Macros$$ how to insert a new row using relative reference in excel 2003

2011-05-10 Thread naresh v
Hello Group, I need to insert a new row and column with relative reference. can you please provide visual basic code for this... PLease put two command buttons Main objective is: Iam having sheet with few records of data. I want to insert a row and column wher

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

2011-03-01 Thread naresh v
Hi Rambabu, please find the solution.. Regards, Naresh V, Analyst Hyderabad. On Wed, Mar 2, 2011 at 3:08 AM, Vinod N wrote: > 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. &

Re: $$Excel-Macros$$ regd: drop down button

2011-02-28 Thread naresh v
ilip Pandey wrote: >> >> Hi Naresh, >> >> Please check the attached file for required solution. >> >> I have used Name definition manager, data validation with V-lookup >> option to achieve the desired result. >> >> Thanks &

$$Excel-Macros$$ regd: drop down button

2011-02-25 Thread naresh v
Hi Experts, I need some help regarding drop downs. Please find the attached sheet for your reference. Please help me in this regard. Thanks and Regards, Naresh V -- -- Some

$$Excel-Macros$$ Need VBA code

2010-04-21 Thread naresh v
Hi, I am good in excel. But i want to learn vba coding. please provide any vba coding related books. Thanking you all. Regards, Naresh V -- -- Some important links for excel users: 1. Follow us on TWITTER for