$$Excel-Macros$$ hlep me

how to use function show all location by country name pfa Regards, Anil Kumar Maurya -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use

$$Excel-Macros$$ Help Vlookup function duplicate

Hi friends, pfa please help me only  vlookup function use find duplicate value.  Regards,Anil Kumar Maurya -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Re: split text by pipe sign

Hi Sanjay use this function =IF(COLUMN()-2=0,IFERROR(LEFT($A18,FIND(|,$A18)-1),$A18),IFERROR(MID($A18,FIND(~,SUBSTITUTE($A18,|,~,COLUMN()-2))+1,IFERROR(FIND(~,SUBSTITUTE($A18,|,~,COLUMN()-1))-1,LEN($A18))-FIND(~,SUBSTITUTE($A18,|,~,COLUMN()-2))),)) Regards, Anil Kumar Maurya

Re: $$Excel-Macros$$ How to Get Data of 527 employees from One Excel Sheet to another Sheet on given proforma

Hi pfa Regards, Anil Kumar Maurya On Tuesday, 4 November 2014 4:50 PM, M.Rafique MRU imrafiqu...@gmail.com wrote: Dear Excel Experts! Hi, Once again I need your help regarding subject matter, mentioned above. I need Data of 527 employees data on other sheet

$$Excel-Macros$$ MIS Executive

Hi All i am search job for Sr. MIS Executive any jop please sent me. anilmaurya...@gmail.com Thanks Regards Anil Kumar Maurya Mob. 8882545343 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https

Re: $$Excel-Macros$$ how to retrieve already applied conditional formatting on a cell

Hi Dear Please find attachment file. On Thursday, 20 March 2014 6:12 PM, Vabs v...@vabs.in wrote: Hi What exactly you are looking for in VBA. Thx On Thu, Mar 20, 2014 at 2:04 PM, Divaker Pandey divake...@gmail.com wrote: Hi Expert, can any one please share code to retrieve already

$$Excel-Macros$$ excel deta formate change vertical to horizontal?

Hi plz help me I have a set of data (about 3000 records) that are in the following format: Name: name1 Address: address1 City: city1 Name: name2 Address: address2 City: city2 I want the records to look like the following: Name Address City Name1 Address1 City1 Name2 Address2 City2

Re: $$Excel-Macros$$ Total of values

Hi Pfa Anil Kumar Maurya From: Smitha S R sperdwo...@gmail.com To: excel-macros@googlegroups.com Sent: Thursday, 18 July 2013 12:57 PM Subject: $$Excel-Macros$$ Total of values Hi Team, PFA the work book, I have to get the total values in all

Re: $$Excel-Macros$$ Help Required

Hi pfa Anil Kumar From: Neeraj Chauhan neerajchauhan...@gmail.com To: excel-macros@googlegroups.com Sent: Wednesday, 17 July 2013 3:41 PM Subject: $$Excel-Macros$$ Help Required Dear experts,   How to subtract time in hours and minute   10:30 AM

Re: $$Excel-Macros$$ need formula please

Hi pfa From: raghunandan rallapalli raghunandan.rallapa...@gmail.com To: excel-macros@googlegroups.com Sent: Tuesday, 11 December 2012 5:59 PM Subject: $$Excel-Macros$$ need formula please sir, I need a formula for total sum of each account no wise as

Re: $$Excel-Macros$$ Stock Query

Hi pfa From: SAJID MEMON sajidwi...@hotmail.com To: Sundarvelan Natarajan excel-macros@googlegroups.com Sent: Saturday, 13 July 2013 6:24 PM Subject: $$Excel-Macros$$ Stock Query Dear Experts, Plz give me some suggestion in challenging query of my part

Re: $$Excel-Macros$$ I want to merge two text cell

Hi pfa From: Dhaval Shah todhavals...@gmail.com To: excel-macros@googlegroups.com Sent: Wednesday, 6 March 2013 5:21 PM Subject: $$Excel-Macros$$ I want to merge two text cell dear friends i want to merge two text cell in one pls refer the sheet

Re: $$Excel-Macros$$ Simple formula required

From: amar takale amartak...@gmail.com To: excel-macros@googlegroups.com Sent: Tuesday, 4 September 2012 2:01 PM Subject: $$Excel-Macros$$ Simple formula required -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel  

$$Excel-Macros$$ plz count extra space

Hi Please Help me attachment file. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles,

Re: $$Excel-Macros$$ required Result on Conditions

From: Rakesh Kumar Sharma rakeshks@gmail.com To: MS EXCEL AND VBA MACROS excel-macros@googlegroups.com Sent: Thursday, 4 July 2013 11:42 AM Subject: $$Excel-Macros$$ required Result on Conditions Dear Experts, I want Result on  conditions. Pls find

Re: $$Excel-Macros$$ Formula require

From: Prabhakar S H prabakar.k...@gmail.com To: excel-macros@googlegroups.com Sent: Tuesday, 4 June 2013 4:49 PM Subject: $$Excel-Macros$$ Formula require Hi Team,   i want to get formula to find Total value of cars with black color only. pls help.  

Re: Message Recall Failure: Recall: $$Excel-Macros$$ Re: Subtract dates

file is not open From: Chandra Gupta Maurya cgmaury...@gmail.com To: excel-macros@googlegroups.com Sent: Thursday, 4 July 2013 2:33 PM Subject: Message Recall Failure: Recall: $$Excel-Macros$$ Re: Subtract dates -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in

Re: $$Excel-Macros$$ Error in Excel Report

From: Manoj Kumar manoj.11...@gmail.com To: excel-macros@googlegroups.com Sent: Thursday, 4 July 2013 4:49 PM Subject: Re: $$Excel-Macros$$ Error in Excel Report On Thu, Jul 4, 2013 at 4:47 PM, Manoj Kumar manoj.11...@gmail.com wrote: Dear

Re: $$Excel-Macros$$ required Result on Conditions

From: Rakesh Kumar Sharma rakeshks@gmail.com To: MS EXCEL AND VBA MACROS excel-macros@googlegroups.com Sent: Thursday, 4 July 2013 11:42 AM Subject: $$Excel-Macros$$ required Result on Conditions Dear Experts, I want Result on  conditions. Pls find

Re: $$Excel-Macros$$ Error in Excel Report

From: Manoj Kumar manoj.11...@gmail.com To: excel-macros@googlegroups.com Sent: Thursday, 4 July 2013 4:47 PM Subject: $$Excel-Macros$$ Error in Excel Report Dear Expert, Please help to sove my Quiry file attached in mail. i need fill all data with p

Re: $$Excel-Macros$$ Value paste the real time data

Hello friend, you have a circular Reference in D6 check it. than try. anil -- -- FORUM RULES (986+ 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

Re: $$Excel-Macros$$ Extract Comma separated Data

Hello friends, after reples all commond plz explen. Thanks Anil -- FORUM RULES (986+ 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

$$Excel-Macros$$ can we round figer any amount.

Hello everybody, I have a queary. can we round figer any amount. exp. Amount Round figer 975567.65 10.00 732530.60 8.00 595328.81 457717.00 405543.09 323739.86 317619.89 317311.64 290630.55 270986.07 Regards

Re: $$Excel-Macros$$ can we round figer any amount.

thanks both of u it's work fine Regards Anil -- FORUM RULES (986+ 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 attention or may not be

Re: $$Excel-Macros$$ How to collect only numeric value from a particular cell

Hello anil, I will try your formula but i could not get same result. how it work plz discraibe. Regards same here -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem,

$$Excel-Macros$$ queary

Hello friends, I have a queary plz find attahcment. Thanks Regards Anil -- FORUM RULES (986+ 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

Re: $$Excel-Macros$$ queary

sorry sir, lack of time i could not explen. I gat data in 901+k 903+a 901+p 905+i 902+l I have to change 901+k=a, 901+a=b, k=a a=b p=c i=d l=e -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent,

Re: $$Excel-Macros$$ Re: Hi friends, I want to know

I exprot data from busy in 5 workbook. and now i open 1 workbook wnat to copy other 4 workbook data in open workbook -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code

Re: $$Excel-Macros$$ Re: Hi friends, I want to know

Hello sir, How r u, there is no need of sample sheet, simply u have 4-5 workbook of any data. and now u have to copy all data from 4-5 workbook. than we have to open 1 by 1 workbook and copy in 1 sheet. now i want to know that can i open 1 sheet from that 4-5 workbook copy all data in 1 sheet.

Re: $$Excel-Macros$$ Re: Hi friends, I want to know

Hello sir, First of all thanks, secondly I don't know vba so can't use it. is excel have any formula. plz tell me. Thanks Regards Anil -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need

$$Excel-Macros$$ Hi friends, I want to know

Hello friends, I have 5 workbook in excel and i want to copy in 1 sheet without open any excel or 1 workbook. is that possible. Thanks Regards Anil -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help,

$$Excel-Macros$$ subscribe to msaccess google groups....

Dear Friends, Can anyone give me the link to Subscribe Msaccess group. Anyone's help is most welcome! Rgds, Anu. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula

Re: $$Excel-Macros$$ subscribe to msaccess google groups....

cannot reach those people for help. Rgds, Anu. On 4/27/12, Anil Kumar anusrikumar...@gmail.com wrote: Dear Friends, Can anyone give me the link to Subscribe Msaccess group. Anyone's help is most welcome! Rgds, Anu. -- FORUM RULES (986+ members already BANNED

$$Excel-Macros$$ NEED SOME ATT.

Hi Friends, can anybody solve this problem. sample file attached. Thanks Regards Anil -- FORUM RULES (986+ 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

Re: $$Excel-Macros$$ NEED SOME ATT.

On Sat, Apr 7, 2012 at 10:50 AM, anil kumar kmr7a...@gmail.com wrote: Hi Friends, can anybody solve this problem. sample file attached. Thanks Regards Anil -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like

Re: $$Excel-Macros$$ NEED SOME ATT.

Thanks rajan and viper I will try Anil -- FORUM RULES (986+ 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 attention or may not be

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

Dear Noorain, thanks for u r help always. Rgrds, Anu. On 3/15/12, 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

$$Excel-Macros$$

-- FORUM RULES (986+ 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 attention or may not be answered. 2) Don't post a question in the

$$Excel-Macros$$ Basics of excel vba -plz send

Hi Dear members, I am new to this group. thnx in adv. -- FORUM RULES (986+ 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 attention or

$$Excel-Macros$$ reqment of greater than formula

Hello friends, I want to a formula of gareter than. any body tell me. Anil -- FORUM RULES (986+ 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

Re: $$Excel-Macros$$ reqment of greater than formula

Hello sir, Thanks for response, I attach file. anil -- FORUM RULES (986+ 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 attention or may

Re: $$Excel-Macros$$ reqment of greater than formula

sorry sir, but i want to know what is use of 1 in large formula. and my second queary can solve anil -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem,

Re: $$Excel-Macros$$ reqment of greater than formula

Thanks sir, I will follow this formula than i give u msg Thanks again Anil -- FORUM RULES (986+ 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

$$Excel-Macros$$ queary about translate

Hi Friends, I have a excel file which have data in hindi, I have to translate in english, there is any softwear or way to solve my problem plz tell me. Thanks Regards Anil -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread

Re: $$Excel-Macros$$ query about translate

Hello group, there is other way to translate. Anil -- FORUM RULES (986+ 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 attention or may

$$Excel-Macros$$ query about translate

hello group, How r all of u, I have a excel file in hindi has some name and add etc. I have to translate them in english, can we do that plz tell me. file attahced Anil -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles,

Re: $$Excel-Macros$$ query about translate

Yes sir, this same file, How can i do plz tell me. I have to translate that data in english Anil -- FORUM RULES (986+ 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

Re: $$Excel-Macros$$ query about translate

I want to translate all name and add. in english anil -- FORUM RULES (986+ 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 attention or

$$Excel-Macros$$ queary about filter

Hello group members, I have a excel file which have data in hindi, I have to short by add. can I use filter or any other way plz tell me. Anil -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent,

Re: $$Excel-Macros$$ queary about filter

Hello sir, fist of all thanks, were can i gat hindi verson of excel. anil -- FORUM RULES (986+ 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

$$Excel-Macros$$ hindi version of excel

Hello friends, any body tell me were i can gat hindi version of excel. plz tell me link anil -- FORUM RULES (986+ 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

Re: $$Excel-Macros$$ hindi version of excel

Hello sir, I have already load hindi font, when i go filter than data change in diffrent lenguge. anil -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem,

$$Excel-Macros$$ anil kumar wants to chat

--- anil kumar wants to stay in better touch using some of Google's coolest new products. If you already have Gmail or Google Talk, visit: http://mail.google.com/mail/b-ed00186c8a-bc205b15b0-HJTs17g9CL5Q2gFJLre8IdRWfjo You'll

Re: $$Excel-Macros$$ convert jpj in excel

Hello sir, Thanks for u r respons. I have tryed but same result. -- 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

$$Excel-Macros$$ anil kumar wants to chat

--- anil kumar wants to stay in better touch using some of Google's coolest new products. If you already have Gmail or Google Talk, visit: http://mail.google.com/mail/b-ed00186c8a-9a18705217-KDNPrlJxRbc1K4HvUzHAJzozFCI You'll

$$Excel-Macros$$ anil kumar wants to chat

--- anil kumar wants to stay in better touch using some of Google's coolest new products. If you already have Gmail or Google Talk, visit: http://mail.google.com/mail/b-ed00186c8a-2c9d1a2514-jUDbAQxFqhloVHQgXkh0spN44cU You'll

$$Excel-Macros$$ I have a queary

Hi experts, I have a queary I have 10 branches in differents citys. and I gate report daily in excel about their daily work. so I want to know that is it possible that every staff make their reports and in one time i will gate all reports in one file. If it is possible plz help me. Thanks

Re: $$Excel-Macros$$ I have a queary

Hi vijay, there is no need to attc. file. because as you know that I have 10 branches in other stations and i have to check e-mail, of their details, if i not found their mail than i have to call them. so i want to that i open my file and press a key and all 10 reports marge in my file as sheet

Re: $$Excel-Macros$$ Job- Required Excel Expert

Hi Mukesh, Plz send any mail ID -- -- 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 @

Re: $$Excel-Macros$$ queary about a jpg file into excel or pdf file

Hi karan and ashis, Thanks for your soon reply. Anil -- -- 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 @

Re: $$Excel-Macros$$ queary about a jpg file into excel or pdf file

Hi Karan, first of all thanks. you have solved my problem. but how i can -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our

$$Excel-Macros$$ can we change hard copy in excel

Hi frineds, can we change a hard copy of data in excel by scanner. Regards Thanks Anil -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links :

Re: $$Excel-Macros$$ can we change hard copy in excel

Hi sam, fist of all thanks for response. I have some data in trems of hard copy like add. mob. no. etc. and i have to type in excel. so i think that frist i scan that hard copy and than change in excel file by any sofware. I hope you will understand now. Anil --

$$Excel-Macros$$ can I unprotect a sheet

Hello everybody, I have a excel file in which i use protect op. but I have forgot password. becoz i use this file some time not daily. If we can unprotect sheet than tell soon. Anil -- -- Some important links for

Re: $$Excel-Macros$$ find doubling

Hi suman, I have a address software in which data enterd by other opprters and I think some data is double so i want to export data from there in excel short out double data than i will remove that data from software. so i wanted to printout that double address. Anil --

Re: $$Excel-Macros$$ find doubling

Dear dguillett and noorani, I don't want to remove double I want show that and copy in other sheet. for removing I use Alt +AM Thanks Regards Anil -- -- Some important links for excel users: 1. Follow us

Re: $$Excel-Macros$$ find doubling

Hello suman, thanks for reply, it works and fulfill my needs. but not that way I want. If you have better Idia plz send me. Thanks Regards Anil -- -- Some important links for excel users: 1. Follow us on

Re: $$Excel-Macros$$ Fwd: date format help

Hello Dear, I think It's work use this key Shift+Ctrl+3. -- -- 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

$$Excel-Macros$$ find doubling

Hi everybody, I have a file in which some data is double i want to find that data. I used short key Alt + AM but it is remove double data insted of show data i want to copy that data. Thanks Regards Anil --

Re: $$Excel-Macros$$ find doubling

Hello sir, frist of all thanks for reply. I used your formula but it is not work according to my data. I have attched that file. plz see that. Thanks Regards Anil -- -- Some important links for excel users:

$$Excel-Macros$$ urgent

Dear all, I am attach. a file in this file some add. and i want to change all add. in single column. I have given exp. in this sheet. Thanks Regards Anil -- -- Some important links for excel users: 1. Follow

$$Excel-Macros$$ How can i fix my heading

Dear friends, I want to know that How can i fix first row colam whenever we go down but heading in first row should be not moved. Thanks Anil -- -- Some important links for excel users: 1. Follow us on

Re: $$Excel-Macros$$ Re: The Most Accurate PDF-to-Excel Converter

2011/8/20 Venkat CV venkat1@gmail.com You are welcome *Best Regards,* *Venkat * *Chennai* * * On Sat, Aug 20, 2011 at 3:52 PM, bé trần văn betnmtdongna...@gmail.comwrote: Thank venkat1@gmail.com has provided me the software conversion from PDF to Excel, very useful information.

$$Excel-Macros$$ how to change a pdf file in to excel

plz anybody tell me that how to change a pdf file in to excel for modifiy. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our

$$Excel-Macros$$ Re: Migrating Add-ins to Office 2007

Hello JM The custom addins can be added in Excel 2007 through the Office Button. \ Click on Office Button - Excel Options - Addins - Manage Addins. Anil Kumar Agarwala Anil Agarwala Co. Chartered Accountants 3rd Floor, Adiba Mansion Maszid Lane, Kamarpatty Fancy Bazar Guwahati : 781001 Assam

$$Excel-Macros$$ Re: Migrating Add-ins to Office 2007

Hello JM The custom addins can be added in Excel 2007 through the Office Button. \ Click on Office Button - Excel Options - Addins - Manage Addins. Anil Kumar Agarwala Anil Agarwala Co. Chartered Accountants 3rd Floor, Adiba Mansion Maszid Lane, Kamarpatty Fancy Bazar Guwahati : 781001 Assam

$$Excel-Macros$$ Re: Seeking help from Excel Macro experts : (Force to enable Macros, Disable design mode, make the project unviewable)

Dear Hemant, You can protect your VB project with a good password and that would be the best solution to your predicament! No one can then view your code, leave alone modify them. Sorry that I am unable to comment on the registry thing. Anil Kumar Agarwala Anil Agarwala Co. Chartered

$$Excel-Macros$$ Re: Help with Combo Box and Display

Maybe u need a combination of Data Validation and VLookup Function. Please attach a sheet with data so that solutions can be provided. CA_logo_icai Small1 Anil Kumar Agarwala Anil Agarwala Co. Chartered Accountants 3rd Floor, Adiba Mansion Maszid Lane, Kamarpatty Fancy Bazar Guwahati

$$Excel-Macros$$ Re: Conversion of value in words from figures

Dear Shiv Pratap There is no built in function in excel to do it. You have to use custom made function for the same which are quite difficult to come by (even ASAP utilities does not provide for one!). CA_logo_icai Small1 Anil Kumar Agarwala Anil Agarwala Co. Chartered Accountants 3rd

$$Excel-Macros$$ Want to learn Array function in Excel

in excel can any one give me the web link for the same where i can learn and understand the array function. -- Thanks Regards Anil Kumar --~--~-~--~~~---~--~~ - Some important

$$Excel-Macros$$ Searching a Value in Excel Sheet

it will give you the value as per your search. *NOTE :* Suppose there is no vlookup and hlookup fuction in Excel then what function i will use to solve my problem (Searching a data in excel file). -- Thanks Regards Anil Kumar 9213901798

$$Excel-Macros$$ Re: Leading zeros

is to be displayed as 15, you could custom format the cell/cells using the format cell dialogue box and typing 00 using custom format. Anil Kumar Agarwala Guwahati : 781001 Assam akagarw...@gmail.com -Original Message- From: excel-macros@googlegroups.com [mailto:excel-mac

$$Excel-Macros$$ Re: amt in words in excel add-in

hi all, please send this below mention file on my mail id. anil.4u.ku...@gmail.com Thanks Regards Anil Kumar. On 4/1/09, PUNEET NASA puneetn...@rediffmail.com wrote: CAN U SEND ME THE SAME On Tue, 31 Mar 2009 harsh shah wrote : *Installation Copy the attached file to the folder

$$Excel-Macros$$ Unprotect Password of VBA or a excel sheet

. If any one have this tool or this type of file which will can do my above mention task, then please fwd the same on my below mention mail ID: anil.4u.ku...@gmail.com i wolud really appricate to all of you. above need is on ugrent base. Thanks Regards, Anil Kumar. 09213901798

$$Excel-Macros$$ Re: doubt

Hi Dear, This dollar sign indicate the reference. for example A$2 - indicate's Column A with increment with 2,3,4,5 ...n $A2- - indicate's Column A with increment with 2,3,4,5 ...n $A$2 - will fixed the value of a2 cells. Thanks Regards, Anil Kumar. On 3/31/09, raafi barey raafiba

$$Excel-Macros$$ Re: Date Problem

Use the formula in cloumn 3 =IF(A5A6,B5,). Fill it in each row. Then filter column 3 for non-blanks. NB: It will be best if you format the data as a table (or excel list). CA_logo_icai Small1 Anil Kumar Agarwala From: excel-macros@googlegroups.com [mailto:excel-mac

$$Excel-Macros$$ Re: Can I get Day from date in excel.

Instead of using the nested IF function which makes the formula quite complicated, you can just use the weekday and custom format your cell as and get the desired result. Or as Dev suggested, Text(A1, ) works just as fine. Anil From: excel-macros@googlegroups.com [mailto:[EMAIL