Re: $$Excel-Macros$$ Hi - Details needed for the MIS Executive Qualification
Sam Are you asking me or to whom you are referring to call you? Here is my number : 09866902757 On Tue, Aug 2, 2011 at 5:25 AM, Sam K soura...@gmail.com wrote: give me call at 12 tomorrow; or leave sms 028482 On Mon, Jul 25, 2011 at 7:00 PM, krishna mummina lovemekris...@gmail.comwrote: Hi Group, My Name is krishna, Working as a Data Analyst from the last 3 years. My daily work includes working with excel, Creating General Reports, Pdf to Excel Conversion, Data Mining and Analyzing data by using Data Tools like, Filter, Formulas, Sorting etc.. But I got a mail from one of my friend, It is an Opening for MIS Executive. I just want to know the exact qualification needed for the job. I mean, what are the Tools i need to know, I know, Many of us are already well settled. So, I just want to know from you people, Thanking you and Waiting for your reply - Krrish -- -- 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 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.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- * *~~ With Best Regards ~~ * *~(Sourav.Kamra)~ * -- -- 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 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.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- 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 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.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Hi - Details needed for the MIS Executive Qualification
Thank you very much for the links. Most of them are just a normal reports like using the basic formulas. Is this is all about MIS Executive role to create the reports like this? Waiting for your reply - krrish On Sat, Jul 30, 2011 at 12:06 AM, XLS S xlst...@gmail.com wrote: Please find the below links http://www.citesales.com/ http://www.ksde.org/Default.aspx?tabid=2836 On Fri, Jul 29, 2011 at 9:05 PM, krishna mummina lovemekris...@gmail.comwrote: Thank you very much for the total input guys. Now, I just want to see some of the example reports and some excel sheets. Is there any site to find those reports etc..? Waiting for your kind reply - krrish On Wed, Jul 27, 2011 at 10:24 AM, Venkatesh Srinivas venkateshs@gmail.com wrote: I some how feel he need to know a bit of database basics... - Clean and organize the database before working on it... - Ensure to know the compatible formula- other features based on version and its disadvantages Regards Venkatesh +91 9841969353 On Wed, Jul 27, 2011 at 9:41 AM, XLS S xlst...@gmail.com wrote: Hey Please find below link http://en.wikipedia.org/wiki/Management_information_system On Mon, Jul 25, 2011 at 7:00 PM, krishna mummina lovemekris...@gmail.com wrote: Hi Group, My Name is krishna, Working as a Data Analyst from the last 3 years. My daily work includes working with excel, Creating General Reports, Pdf to Excel Conversion, Data Mining and Analyzing data by using Data Tools like, Filter, Formulas, Sorting etc.. But I got a mail from one of my friend, It is an Opening for MIS Executive. I just want to know the exact qualification needed for the job. I mean, what are the Tools i need to know, I know, Many of us are already well settled. So, I just want to know from you people, Thanking you and Waiting for your reply - Krrish -- -- 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 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.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- . -- -- 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 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.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Regards Venkatesh KS Phone: +91 98419 69353 -- -- 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 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.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- 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 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.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- . -- -- 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 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
Re: $$Excel-Macros$$ Hi - Details needed for the MIS Executive Qualification
vijaykumar and venkat thank you very much for your valuable input. On Sat, Jul 30, 2011 at 8:23 PM, P.VIJAYKUMAR vijay.4...@gmail.com wrote: Dear Krishna, The profile of MIS Executive changes with the type organisation.If it is a small organisation MIS Executive role would be to prepare normal reports like the work you do.If it is a big and reputed organisation your role in addition to normal report preparation would be to do fianacial modelling or creating financial model which would help the management in its decision making process. For more information for using excel in financial modelling u can refer to the website www.exinfm.com. Regards, Vijaykumar On Mon, Jul 25, 2011 at 7:00 PM, krishna mummina lovemekris...@gmail.comwrote: Hi Group, My Name is krishna, Working as a Data Analyst from the last 3 years. My daily work includes working with excel, Creating General Reports, Pdf to Excel Conversion, Data Mining and Analyzing data by using Data Tools like, Filter, Formulas, Sorting etc.. But I got a mail from one of my friend, It is an Opening for MIS Executive. I just want to know the exact qualification needed for the job. I mean, what are the Tools i need to know, I know, Many of us are already well settled. So, I just want to know from you people, Thanking you and Waiting for your reply - Krrish -- -- 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 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.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- P.VIJAY KUMAR -- -- 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 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.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- 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 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.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Hi - Details needed for the MIS Executive Qualification
Thank you venkat, Report Generation and Data Management? If you have some examples, can you please provide those? Thanks in advance, Krrish On Tue, Jul 26, 2011 at 11:57 AM, Venkat CV venkat1@gmail.com wrote: Hi Krish, MIS Executive Role also Same kind of role as you now doing...Reports generation Data Management activities *Best Regards,* *Venkat* *Chennai* On Mon, Jul 25, 2011 at 7:00 PM, krishna mummina lovemekris...@gmail.comwrote: Hi Group, My Name is krishna, Working as a Data Analyst from the last 3 years. My daily work includes working with excel, Creating General Reports, Pdf to Excel Conversion, Data Mining and Analyzing data by using Data Tools like, Filter, Formulas, Sorting etc.. But I got a mail from one of my friend, It is an Opening for MIS Executive. I just want to know the exact qualification needed for the job. I mean, what are the Tools i need to know, I know, Many of us are already well settled. So, I just want to know from you people, Thanking you and Waiting for your reply - Krrish -- -- 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 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.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- * * * * * * -- -- 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 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.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- 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 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.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Hi - Details needed for the MIS Executive Qualification
Thank you very much sir, Really very detailed explanation. Once again Thank you very much. On Tue, Jul 26, 2011 at 4:28 PM, anandydr ananad...@gmail.com wrote: Hi, In case of MIS Executives the kind of the data sets is very rigid. The data is always in the same format. Mostly the amount of data would also be the same every day/week. The frequency of reports would be also same for them, i.e. the MIS is generated on a weekly, daily or 15 days or quarterly basis. The data is extracted from a source which is set by a business analyst beforehand and should not or is not manipulated without prior permission. Considering all this we can conclude: 1. MIS Executive is Good at Excel functions like Lookup, Vlookup and Hlookup 2. He/She has some knowledge of pivot tables and data extraction. 3. He/She can work comfortably on data sets of around 20,000 rows and 200 colums (approx) 4. He/She should have some knowledge of text manipulation functions (Concatenate, len, find, left, right etc). 5. He/She should be comfortable using combination of functions e.g. extract first name from email id in cell A1 when A1 contains anand...@gmail.com 6. He/She should be able to use logical functions 7. Should be able to use error handling functions available in MS Excel. 8. Last but not the least WILLINGNESS TO LEARN. Warm regards, Anand Kumar. -- -- 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 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.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- 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 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.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ Hi - Details needed for the MIS Executive Qualification
Hi Group, My Name is krishna, Working as a Data Analyst from the last 3 years. My daily work includes working with excel, Creating General Reports, Pdf to Excel Conversion, Data Mining and Analyzing data by using Data Tools like, Filter, Formulas, Sorting etc.. But I got a mail from one of my friend, It is an Opening for MIS Executive. I just want to know the exact qualification needed for the job. I mean, what are the Tools i need to know, I know, Many of us are already well settled. So, I just want to know from you people, Thanking you and Waiting for your reply - Krrish -- -- 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 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.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Delete rows including blank row except few members
Hi Hari, Just Insert the Code in VBA Module, Like, press Alt+F11, VBA window will open, then, just from the menu bar, Insert , Module, there you will place the code. Here is a link: www.contextures.com/xlvba01.html http://www.contextures.com/xlvba01.htmlKeep Smiling, On Mon, Nov 8, 2010 at 9:07 AM, Hari Lal. C harilal@gmail.com wrote: HLC Dear Krishna Mummina, I saw yr solution to the question of Niel Johnson. As i am a primary student in Excel I don't know how to create Excel Macro. I would like to know how to apply these commands in excel and how to use it. Shall I except yr kind help. Kindly enlighten me using or applying the following commands step by step in excel. delete the entire row when specification meets Sub processdata() Dim i As Long, lr As Long lr = ActiveSheet.UsedRange.Rows.Count Application.ScreenUpdating = False For i = 1 To lr If Range(A i).Value = Then Range(A i).EntireRow.Delete If UCase(Range(A i).Value) = C Then Range(A i).EntireRow.Delete If UCase(Range(A i).Value) = D Then Range(A i).EntireRow.Delete If UCase(Range(A i).Value) = E Then Range(A i).EntireRow.Delete If UCase(Range(A i).Value) = F Then Range(A i).EntireRow.Delete Next Application.ScreenUpdating = True End Sub Hari Lal -- -- 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 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.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- 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 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.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
Re: $$Excel-Macros$$ Delete rows including blank row except few members
Try this: It will delete the entire row when specification meets Sub processdata() Dim i As Long, lr As Long lr = ActiveSheet.UsedRange.Rows.Count Application.ScreenUpdating = False For i = 1 To lr If Range(A i).Value = Then Range(A i).EntireRow.Delete If UCase(Range(A i).Value) = C Then Range(A i).EntireRow.Delete If UCase(Range(A i).Value) = D Then Range(A i).EntireRow.Delete If UCase(Range(A i).Value) = E Then Range(A i).EntireRow.Delete If UCase(Range(A i).Value) = F Then Range(A i).EntireRow.Delete Next Application.ScreenUpdating = True End Sub On Sun, Nov 7, 2010 at 1:20 PM, neil johnson neil.jh...@googlemail.comwrote: Hi Everyone, I have data in rows(A:A) like . Now I want to delete blank row and *C, D, E, F till last range in A. how can I make macros for this * Name B C A B C A A A A B C C C C C B B C C C D E E F F F -- -- 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 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.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- 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 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.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
Re: $$Excel-Macros$$ help required
Dear Girish, Sorry I didn't understand what you are looking for, Please give an Example, what you want exactly? May be i have some communication problem to understand your query. Thanks, Excelkid On Mon, Oct 18, 2010 at 7:52 PM, girish kumar girishkumar832...@gmail.comwrote: Dear Experts, need one urgent help from you guys i have attached one file having 2 sheets named system data Raw CDR i need a formula for getting name in sheet Raw CDR for exam sheet system data having no 93 Afghanistan Other and Raw Cdr having No 93854512115 for getting destination name in sheet raw CDR i m using 1st left function like =left(A2,13) and again giving vllokup formula as mentioned in sheet if data not found, then i decrease the no's in left function as 12, 11, 10 till i get the destintaion name problem is data will be very huge and take more time to calculate so friends if u can find any logical function for this it'll help me very much thanks in advance Girish -- -- 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 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.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- 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 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.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
Re: $$Excel-Macros$$ Password Help Required
Hi, what about a hidden sheet? On Mon, Oct 11, 2010 at 11:23 PM, hemant shah hemanthin...@gmail.comwrote: Hi All, Can you please help me with my query regarding the password change in VBA. Thanks in advance. Waiting for the resolution on my query. Regards, Hemant Shah -- -- 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 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.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- 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 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.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
Re: $$Excel-Macros$$ Rupee symbol HOW ???
Check out here: http://bishwajeet.blogspot.com/2010/07/steps-to-include-indian-rupee-symbol.html On Sat, Oct 9, 2010 at 3:17 PM, SAJID MEMON sajidwi...@hotmail.com wrote: -- Hi, I have done following tricks but not satisfied as : 1) Select the column/cell where you want to have the format with the new ` rupee symbol. 2) Change the format of the cell to Currency. 3) Go to Cell Format - Choose Custom and paste the following: [999]` ##\,##\,##\,##0.00;[9]` ##\,##\,##0.00;`##,##0.00 4) Change the font of the column/cell selected to Rupee Fordian. And thats all you need. but when i am doing this trick in excel it is not working please tell me step by step to get new Rupee Symbol can mentioned in excel platform Regards sajid memon -- -- 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 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.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- 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 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.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
Re: $$Excel-Macros$$ DELETE OF A VALUE DELTES THAT FROM EVERY SHEET
Hey Dude, Do this, Select the Cell which you want to delete and Ctrl+Select Every Sheet, then press Delete. I hope it will helpful. Regards, Krrish On Fri, Oct 8, 2010 at 6:40 PM, sudheer lolla sudheer1...@gmail.com wrote: Hi guys I Have a column xyz which is there in every sheet of the workbook and the column number in sheet A is 1 ,sheet B is 2,sheet C is 1 If i delete a value from that column xyz in sheet A,the deleted cell has to be deleted from these B,C sheets But the vice-versa should not happen i.e Delete of a cell in column xyz of sheet B or C should not delete from A For me sheet A is a base sheet DELETE REFLECTS ALL SHEETS IS WHAT I NEEDED I will be very thankful to this community if i get some answer. Thanks sudheer.L -- -- 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 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.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- 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 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.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
Re: $$Excel-Macros$$ How to delete blank columns rows using VBA
Hey, Check this and Let me know. Sub del_br() Dim coun As Long With ActiveSheet For coun = .Cells.SpecialCells(xlCellTypeLastCell).Row To 1 Step -1 If WorksheetFunction.CountA(.Rows(coun)) = 0 Then ActiveSheet.Rows(coun).Delete End If Next End With End Sub On Thu, Oct 7, 2010 at 6:53 PM, Rajat Kapoor rajat.bi...@gmail.com wrote: I wanted to know how can one delete all blank rows columns using VBA? Suppose in Cell A1 there is data but in other cells with row 1 there is no data. Thus we can say this row is not blank. BUt taking other example suppose there is data in Cell C1, A3, A4. But entire row i.e ROW - 2 is blank. How can one delete all such entire blank rows using VBA. Similarly this apply to columns also. -- -- 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 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.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- 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 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.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
$$Excel-Macros$$ VBA CODE UNLOCKER
Hello Guys, Check it out. http://www.vbaunlocker.info/* * -- -- 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 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.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
Re: $$Excel-Macros$$ Help in sending the salary slip
You may use of macro. I am not sure about Password for the file, but You can send automatically to the Concerned person. -- -- 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 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.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
Re: $$Excel-Macros$$ Ayush Jain – Microsoft MVP 20 10
Congratulations Ayush Jain. Really Very proud of you man. On 10/4/10, rajasekhar praharaju rajasekhar.prahar...@gmail.com wrote: hearty congratulations ayush, you really deserve it Infact you are good encyclopedia for us. Have a flamboyant future and delightful moments for ur future endeavors. Regards, Raj On Sun, Oct 3, 2010 at 3:47 PM, Ayush jainayus...@gmail.com wrote: Dear Group, I am proud to announce that I am awarded Microsoft Most Valuable Professional MVP on October 01, 2010 for providing technical expertise in Excel technical communities for past one year. http://blogs.technet.com/b/southasiamvp/archive/2010/10/01/new-mvps-announced-october-2010.aspx This is a prestigious award from Microsoft given every Quarter to the people who share their deep knowledge, real-world experience, and impartial, objective feedback to help people enhance the way they use technology. My deep thanks to each group member for all your support and contribution to this group. Best regards, Ayush Jain Microsoft MVP -- -- 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 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.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- 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 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.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- 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 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.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
$$Excel-Macros$$ Excel Related Jobs
Hello All, My name is krishna, Currently working as a Data Analyst based on Excel. So, I want to know the Other Areas where we can Get the Job. Basically I have 2 years of MNC Experience as a Data Analyst, and I am a Excel Advance User. I am looking to give a try in Deloite and Other Big daddy's. Is there any way to go into it.? Please Discuss Regarding this. Thanks, krrish -- -- 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 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.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
Re: $$Excel-Macros$$ Fwd:
Hi praveen, we can find the position and could you please tell me why you need it. Bye On 7/2/10, praveen kumar bhspra...@gmail.com wrote: Hi Friends, Is there any way to find the position of the space in a word from right side. Ex: United States of America - here the position of the space from right side is 8. -- Regards, praveen -- -- 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 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.blogspot.com To post to this group, send email to excel-macros@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 -- -- 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 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.blogspot.com To post to this group, send email to excel-macros@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
Re: $$Excel-Macros$$ How to increase size and color of text in user form ?
CLICK ON THE TEXT, YOU WILL GET THE PROPERTIES OR ELSE, RIGHT CLICK ON THAT AND PROPERTIES, THERE YOU WILL FIND WHAT YOU WANT. On 7/2/10, worawat kh worawat...@gmail.com wrote: Dear Group , How to increase size and color of text in user form ? Thanks, Worawat -- -- 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 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.blogspot.com To post to this group, send email to excel-macros@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 -- -- 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 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.blogspot.com To post to this group, send email to excel-macros@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