Re: $$Excel-Macros$$ Re: How to remove space in excel cell

Hi Prabhu, see if the enclosed file helps Regards Umesh On Sun, May 29, 2011 at 9:55 AM, Prabhu prabhugate...@gmail.com wrote: Hi Friends, I have attached a sheet, which contains space in prefix and suffix. But below formula is not working. Kind do the needful. --

Re: $$Excel-Macros$$ Automation of formula

Hi, What's the code you want to pass and to which cell. mention that also Regards Umesh Dev On Mon, May 23, 2011 at 11:32 PM, Skanda skanda.pokkun...@gmail.com wrote: The column difference highlighted in green is calculated as the difference between the two cells to its left.Then %difference

Re: $$Excel-Macros$$ Need mis in excel vba format must in search engine

. Regards Umesh Dev On Sat, May 21, 2011 at 5:35 PM, kannan excel kannan.ex...@gmail.comwrote: If i put my executive name, his weekly and monthly perfomance will come automatically On Sat, May 21, 2011 at 5:31 PM, kannan excel kannan.ex...@gmail.comwrote: Hi rajan, i am maintain our

Re: $$Excel-Macros$$ Formula required

Hi Vikram, Find the sheet enclosed Regards Umesh Dev On Mon, May 16, 2011 at 11:07 PM, vikram vikramahuj...@gmail.com wrote: Hi, Please help regarding formula for validation: If we enter any numeric value in particular column it does not allow a duplicate entry and shows error

Re: $$Excel-Macros$$ Urgent Formula Required Help me

Hi Puttu, explain it in excel sheet and also mention all the possibilities. Regards Umesh On Fri, Apr 1, 2011 at 5:12 PM, Puttu * puttu...@gmail.com wrote: awaiting for your replay please. On Fri, Apr 1, 2011 at 4:49 PM, Puttu * puttu...@gmail.com wrote: Experts please help me on this

Re: $$Excel-Macros$$ Pivot table - Pivot tabel row Range

Hi Rakesh, can you attach the excel sheet Regards Umesh Dev On Fri, Apr 1, 2011 at 4:29 PM, rakesh kumar rakeshshail2...@gmail.comwrote: Hi ! Group members, I have a pivot table, which shows 5 income groups in row Range and their counts. However, when I apply a filter it leaves 3 income

Re: $$Excel-Macros$$ Calculating An Average Score from Multiple Tabs

Hi John, change the formula to IFERROR(AVERAGE('Dept A'!B10,'Dept B'!B10,'Dept C'!B10),) Regards Umesh On Tue, Mar 29, 2011 at 8:22 PM, John A. Smith johnasmit...@gmail.comwrote: I have like tabs from different departments and need to summarize an average score by day. But if there were no

Re: $$Excel-Macros$$ discussexcel.com Launched today

Hi Ayush, Congrats to you and the team. Regards Umesh On Mon, Mar 21, 2011 at 10:08 PM, neil johnson neil.jh...@googlemail.comwrote: Hi , Congratulation to you sir On 3/20/11, Ayush Jain jainayus...@gmail.com wrote: Dear Excel Group Members, I am very glad to share that*

Re: $$Excel-Macros$$ Please Help

Hi Sudhir, Check if its working. I have done it for only Running Balance. I am not clear with the Pending Amount the numbers are contradicting in the format which you had attached. if you can let me know how it is done. I can rework the code. Regards Umesh Dev On Sat, Mar 19, 2011 at 12:15 PM

Re: $$Excel-Macros$$ Please Help

, Thanx and It's feel good to see done with macro. And how to copy it to my main workbook. Meaning of Pending Amount : It mean's payment which was not collected yet. Regards Sudhir On 21/03/2011, Umesh Dev umesh.d...@gmail.com wrote: Hi Sudhir, Check if its working. I have done

Re: $$Excel-Macros$$ combining averageif with time into one formula

Hi Susan, Assuming that the formula is right. To change the number to time format. Do it this way mentioned below:- Right Click the cell - Click on* format cells* * *- Select *Time* from *Category(Number) *- Choose the format you want. Regards Umesh Dev On Sat, Mar 19, 2011 at 2:23 AM, Susan 1

Re: $$Excel-Macros$$ Please Help

Hi Sudhir, It is still not clear, how to get the Running Bal and the Pending Amount. Regards Umesh On Sat, Mar 19, 2011 at 12:55 AM, sudhir kumar bluecore...@gmail.comwrote: Dear Experts, Please read my attachment and solve it. thanx Sudhir Verma Asstt. Mngr. A/c's 9818479722

Re: $$Excel-Macros$$ Looping-stopping to process when cell starts with a D

sample excel sheet would be easier to understand and solve Reg Umesh On Thu, Mar 17, 2011 at 11:20 PM, Preston Moore moor...@ldschurch.orgwrote: I am just starting to use VBA so I am a neophyte. I have data that shows units sold by product listed by store for over 40 stores. Each store has

Re: $$Excel-Macros$$ Re: Ashish Koul : Most helpful Member

Congrats Ashish On Wed, Mar 2, 2011 at 5:36 PM, DILIPandey dilipan...@gmail.com wrote: Congrats Ashish...!! Best Regards, DILIPandey On Mar 1, 8:38 pm, Ayush jainayus...@gmail.com wrote: Hello Everyone, Ashish Koul has been selected as *'Most Helpful Member'* for the month of Feb

Re: $$Excel-Macros$$ Query: Seprate Row after every Semicolonq

There is no attachment On Thu, Feb 24, 2011 at 6:33 PM, Joao Matoso jcmat...@gmail.com wrote: Ww NOORAIN ANSARI noorain.ans...@gmail.com escreveu: Dear Experts.. Please find attached query sheet...I want to add a seperate row after every semicolon.. Please see attached sheet.. --

Re: $$Excel-Macros$$ Shorting Problems

Hi Sudhir, Select the row A = Click on Data Tab = Click on Advanced = Select Unique Records Only. That's it. Regards Umesh On Wed, Feb 9, 2011 at 4:29 PM, sudhir kumar bluecore...@gmail.com wrote: Dear Frnd I have list which have many repeated names i want short it with formula thanx

Re: $$Excel-Macros$$ $$Excel and macros$$

Hi Mujeeb, attach an excel sheet with example. Reg Umesh On Mon, Feb 7, 2011 at 4:38 PM, Mujeeb mujeebrahman...@gmail.com wrote: Hi team, Could you pls help me in solving this excel formula. Eg; If A1 has some text for eg My name is Google In B1 if we type any text from A1, Eg name

Re: $$Excel-Macros$$ Ashish Koul : Most helpful member : Jan11

congrats Ashish Regards Umesh Dev On Wed, Feb 2, 2011 at 8:25 PM, Ayush jainayus...@gmail.com wrote: Ashish Koul has been selected as *'Most Helpful Member'* for the month of Jan 2011. He has posted over 75 posts (11% of total posts) in January 2011 and helped many people through his

Re: $$Excel-Macros$$Help with macros automatic formulas.

Hi Hector, Change the formula to IF(ISBLANK(D2),(B2-A2)*24,(D2-B2)*24) in the vba you have mentioned is esblanco Regards Umesh Dev On Thu, Feb 3, 2011 at 2:01 AM, Hector Ruiz hector.ru...@gmail.com wrote: Hi all, I made a macro to do a consultation with automatic cell ranges

Re: $$Excel-Macros$$ How to extract data from an array

Hi, If you kindly put the data in excel it would be easy. Reg Umesh On Tue, Feb 1, 2011 at 12:22 AM, jmccaski jmccask...@gmail.com wrote: I have an arry of over 21,000 rows with data in this format: VarName TimeString VarValue Pos 27.01.2011 12:49:35 32 Pres27.01.2011

Re: $$Excel-Macros$$ Problem in excel

Hi jitender, Find the enclsd sheet if it could help. Regards Umesh On Sun, Jan 30, 2011 at 1:55 PM, Jitender kumar jk9779771...@gmail.comwrote: Dear Sir I have problem with excel file.Please provide the solution.(See attachment) Regards Jitender --

Re: $$Excel-Macros$$ removing multiple data and converting column into row

Hi I hope the enclsd sheet will help you. Regards Umesh Dev On Sun, Jan 30, 2011 at 12:40 PM, Ms-Exl-Learner . ms.exl.lear...@gmail.com wrote: Hi Vikalp, Please refer the attached excel for solution. I have automated everything in formula and you need not to do any manual input

Re: $$Excel-Macros$$ Please help

Hi sudhir, Click *Conditional formatting* tab -Select *New Rule* - Select *Format only cells that contain* - click on *Format* and choose the color. Regards Umesh Dev On Sun, Jan 30, 2011 at 9:27 PM, sudhir kumar bluecore...@gmail.com wrote: Dear Experts please hep me for a formula

Re: FW: $$Excel-Macros$$ Help Required_pdf file conversion

Hi Vikram, Its working in my sys. if its not working on your sys then let me know where the file is saved and also where your acro-reader is saved. Regards Umesh Dev On Sat, Jan 29, 2011 at 12:50 PM, vikram vikramahuj...@gmail.com wrote: Hi, Please help regarding below query as I need

Re: $$Excel-Macros$$ Please help to get result through Formule

Hi CS, If you want to color the band. You can Conditional Formatting to get the result. Regards Umesh On Thu, Jan 27, 2011 at 3:04 PM, Born to Win cs4...@gmail.com wrote: Hello Expert, In Attached Sheet i am making a tracker For Attrition In first summary sheet i have to show Band with

Re: $$Excel-Macros$$ Help Required

Hi Vikram, I clearly did not understand your query, however I have rectified the code. Regards Umesh Dev On Wed, Jan 26, 2011 at 9:32 PM, vikram vikramahuj...@gmail.com wrote: Hi Umesh, Thanks a lot for your help. I need one more help regarding below macro for converting PDF files

Re: $$Excel-Macros$$ Help Required

Hi Vikram, I am enclosing a file. It would ask for file each time you run the macros. Use this as a template and the save as daily file. Is it clear? Regards Umesh Dev 9019107882 On Tue, Jan 25, 2011 at 7:51 AM, vikram vikramahuj...@gmail.com wrote: Hi Umesh, I need one more help

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

Hi David, let me know the fields and how would you want it to be created. Umesh On Mon, Jan 24, 2011 at 12:32 AM, DavidG goldstone.da...@googlemail.comwrote: how do i add a file? On Jan 21, 8:57 pm, DavidG goldstone.da...@googlemail.com wrote: Hi I am trying to build a system for a

Re: $$Excel-Macros$$ Unique records

Hi Ashish Thank you ... You made it very simple. I was finding it difficult to loop. Thanks Omar for the input. Thanks and Regards Umesh Dev On Sat, Jan 15, 2011 at 9:53 PM, ashish koul koul.ash...@gmail.com wrote: check the attachement see if it helps On Sat, Jan 15, 2011 at 7:14 PM

$$Excel-Macros$$ Unique records

Hi All, Can anyone help me with the code in *VBA *to find unique values and pasting it separately in Excel. Regards Umesh Dev -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks

Re: $$Excel-Macros$$ How To Find Duplicate Records in Ms Excel

Hi Pankaj, Go to advanced filters and select Unique records Regards Umesh On Fri, Aug 27, 2010 at 11:21 AM, rajput rajputpanka...@gmail.com wrote: I have a lot of Data including number Alphabet , I am confussed that duplicate will be entered,,,which command i find duplicate records --

$$Excel-Macros$$ Re: Segregate data in appropriate sheet with Name as sheet name

).Name = Newname _ ThisWorkbook.Worksheets(i).Index Next i End Sub Umesh Dev On Tue, Nov 3, 2009 at 6:56 PM, Chanti ramesh1...@gmail.com wrote: Hi Team, Is there a way we can segregate the data depending upon the name (column A) to different tabs. Example If it is a macro

$$Excel-Macros$$ Re: Name Matching In Excel

Hi Dilip, Can you explain the logic pls. Regards Umesh On Tue, Oct 13, 2009 at 8:39 PM, Dilip Pandey dilipan...@gmail.com wrote: Thanks Michael, The enhancement is done in the attached file as per your requirements. Thanks -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91

$$Excel-Macros$$ Pdf Password

Regards Umesh Dev --~--~-~--~~~---~--~~ -- 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

$$Excel-Macros$$ Re: Difference of Modules

Thank You Paul Regards Umesh Dev On Thu, Oct 1, 2009 at 7:40 PM, Paul Schreiner schreiner_p...@att.netwrote: A Class is a way of defining a new object and attributes. let's say you wanted to create an object called People. Now, for each person in People you wanted to save the Name