Re: $$Excel-Macros$$ Running Count for particular data
Good! On Tue, Jul 6, 2010 at 8:55 AM, WizExcel ssw...@gmail.com wrote: This is just too good Ayush , thanks for the explanation. On Jul 5, 8:16 pm, Ayush jainayus...@gmail.com wrote: Thanks Ankit. As the running count was required, The formula should have running range. I have used Row f(x) to return the current row number and used the indirect f(x) to convert the test string into range. The two functions returns the running range and countif formula is used to count the values in running range. Example:- A2 cell will refer to range A2:A2 for counting A3 cell will refer to range A2:A3 for counting A4 cell will refer to range A2:A4 for counting and so on... I hope this helps. Best regards, Ayush Jain Group Manager. On Jul 5, 7:52 pm, Ankit Agarwal ankit.a...@gmail.com wrote: Hi Ayush, This formula is perfect. I would appreciate if you would pls. explain it. Thanks, Ankit On Mon, Jul 5, 2010 at 7:56 PM, ayush jain jainayus...@gmail.com wrote: Hi Wizexcel, Attached is the solution. You have to use the combination of countif, indirect and row function. The formula is :- *=COUNTIF(INDIRECT($A$2:$A$ ROW(A2)),A2)* Please let us know if any further assistance is required. Best regards, Ayush Jain Group Manager On Mon, Jul 5, 2010 at 5:49 PM, WizExcel ssw...@gmail.com wrote: Dear Experts, want to know if there is way / function for having a running count in Excel. I have tried COUNTIF and most of the Count Functions , but all give total count and not the Running Count. Example: See below. The Count for HDFC Bank should be 1, 2 . and then finally 3. and then similarly for other Banks. What the CountIF function shows is the TOTAL count. How it is happening now using CountIF: BankCount HFDC Bank 3 SBI Bank2 SBI Bank2 HDFC Bank 3 Axis Bank 1 HDFC Bank 3 How I want it : BankCount HFDC Bank 1 SBI Bank1 SBI Bank2 HDFC Bank 2 Axis Bank 1 HDFC Bank 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 @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials athttp://www.excel-macros.blogspot.com 4. Learn VBA Macros athttp://www.quickvba.blogspot.com 5. Excel Tips and Tricks athttp://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 -- Best regards, Ayush Jain -- ------ 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 athttp://www.excel-macros.blogspot.com 4. Learn VBA Macros athttp://www.quickvba.blogspot.com 5. Excel Tips and Tricks athttp://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- Hide quoted text - - Show quoted text - -- -- 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
Re: $$Excel-Macros$$ GNATT CHART
Give search on Google with Filetype:xls, you will get many options... I wish it will work for you. Anand On Tue, Jul 6, 2010 at 10:55 AM, zafnu zaf...@gmail.com wrote: Hi, Can u please help me to create a '*Gnatt Chart*' in excel. your immediate action is highly appreciated. Thanks regards Zafnim backer. -- -- 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
$$Excel-Macros$$ Re: Excel Programming
On 5 Jul., dtenz wrote: I have name cells A1 to D1 as Number Num1 Num2 and Num3. What? The cells A1 to D1 contain _four_ values. How do they correspond to Num1, Num2, and Num3? Please be as precise as possible. Now I have data in Col A from A1 to around A500 depending on the file. What I need to do is: If Number is =25, then Num1=25 and If Number is 25, then Num1=Number. What is Number? Where does it come from? What you are trying to do can be achieved by the max function: =max(A1;25) should do the trick For Num2: if Number-Num1=25 then Num2 = 25 else Num2=Number-Num1 For Num3: Num3=Number-Num1-Num2 The cell I am trying to calculate will be B2 and rest of col B = Num1, C2 and rest of col C = Num2 and D2 and rest of col D = Num3. That's not very clear to me. Before you post the next time, please show your description to someone else. If they understand it without having to ask you _any_ questions, you can post it to this newsgroup. Thank You, dtenz Please don't get me wrong, we don't want to harras you. You have to understand that we posting to this group in our free time. We are happy to help you with your problem, but we don't like to spend much time to find our what your problem actually is. Regards, Stuart -- -- 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$$ Problem
pls find the same. On Mon, Jul 5, 2010 at 4:31 PM, neil johnson neil.jh...@googlemail.comwrote: Hi , I have problem in this sheet. Please solve it . Please find the attached sheet Thanks and Regards -- -- 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 -- Regards, Prashant -- -- 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 problem(1).xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Urgent help....
Thanx Dear --- On Mon, 5/7/10, Deepak Rai daksh1...@gmail.com wrote: From: Deepak Rai daksh1...@gmail.com Subject: Re: $$Excel-Macros$$ Urgent help To: excel-macros@googlegroups.com Date: Monday, 5 July, 2010, 2:02 PM Hi Ankit, Please find the attached solved file. Column highlighted with yello color has the solution as requested. Thanks, Deepak On Mon, Jul 5, 2010 at 5:59 PM, Ankit Chandna ankit.chan...@yahoo.in wrote: Hi, hi to all ..i need a help PFA and help me to get reqired result. Regards, Ankit -- -- 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 -- -- 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
$$Excel-Macros$$
Hi, hi to all ..i need a help PFA and help me to get reqired result. Regards, Ankit -- -- 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 help.xlsx Description: Zip compressed data
Re: $$Excel-Macros$$ Problem in list box when using refedit control
it's not working... On Sun, Jul 4, 2010 at 3:03 PM, ayush jain jainayus...@gmail.com wrote: Hi Neil, As there are multiple items in a range, You need to use FOR EACH statement to add items of range one by one in listbox. Attached is the solution for your reference. I hope it helps. Please let me know if any further assistance is required. Best Regards, Ayush Jain Group Manager. On Sun, Jul 4, 2010 at 1:24 PM, neil johnson neil.jh...@googlemail.comwrote: Hi Everyone I make user form , and i reterive cell range through refedit contorl . when i select the range in refedit control and it show single range value in listbox MY *problem is that when i select more range it show error in list box.* *Can you sort out that prolblem as soon as possible.* I need to select the range(A1:B11). And should be shown in list box . How it can be possible Please find the attachment sheet . Thanks and Regards -- -- 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 -- Best regards, Ayush Jain -- -- 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$$ Cell Capacity filters
Thanks for your reply. That is what I am doing and it is combersome. What I want to know is as follows 1.ithere some VBA codes whereby the capacity can be enhanced from 255 charachters; or Excel 2010 would solve this problem ( I have Excel 2007). -- Have a good day! Muneeb Cell: 0300 2213043 -- -- 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
$$Excel-Macros$$ Merged Cells autofit row height
Dear Experts. I am working on a huge file where some cells have been merged. I need to autofit the row height of the merged cells. A code I have copied from the WEB does not work. Kinldy have a look at it or please suggest a new one. Code is as follows. Regards. Private Sub Worksheet_Change(ByVal Target As Range) Dim NewRwHt As Single Dim cWdth As Single, MrgeWdth As Single Dim c As Range, cc As Range Dim ma As Range With Target If .MergeCells And .WrapText Then Set c = Target.Cells(1, 1) cWdth = c.ColumnWidth Set ma = c.MergeArea For Each cc In ma.Cells MrgeWdth = MrgeWdth + cc.ColumnWidth Next Application.ScreenUpdating = False ma.MergeCells = False c.ColumnWidth = MrgeWdth c.EntireRow.AutoFit NewRwHt = c.RowHeight c.ColumnWidth = cWdth ma.MergeCells = True ma.RowHeight = NewRwHt cWdth = 0: MrgeWdth = 0 Application.ScreenUpdating = True End If End With End Sub -- Have a good day! Muneeb Cell: 0300 2213043 -- -- 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$$ Fwd:
Very Good! On Sat, Jul 3, 2010 at 2:15 PM, ashish koul koul.ash...@gmail.com wrote: Thanks a lot Dave. On Sat, Jul 3, 2010 at 2:22 PM, Dave Bonallack davebonall...@hotmail.comwrote: Hi, A1 = *United States of America* =FIND(CHAR(1),SUBSTITUTE(A1, ,CHAR(1),LEN(TRIM(A1))-LEN(SUBSTITUTE(A1, , Firstly, we need to find out how many spaces there are in the text. We do this by finding the text length of the original text, *Len(TRIM(A1))*then the text length of the text with all the spaces removed *LEN(SUBSTITUTE(A1, ,))*. Then find the difference *LEN(TRIM(A1))*-*LEN(SUBSTITUTE(A1, ,))*. In our case, 3. So the last instance of the space character is the 3rd one. The SUBSTITUTE function takes 4 arguements. 1: The original text, 2: text string you don't want, 3: text string you want instead, and 4: the optional arguement of what instance. So in our case, we want to replace the 3rd instance of the space character with something (anything) unique; for this, we use CHAR(1) (whatever that is). *SUBSTITUTE(A1, ,CHAR(1),3)* So replacing the 3rd instance of the space character with Char(1) we get *United States ofCHAR(1)America* Now we just use the FIND function to return the position of the CHAR(1) character. Cool Huh! Regards - Dave. ** ** -- Date: Sat, 3 Jul 2010 10:52:12 +0530 Subject: Re: $$Excel-Macros$$ Fwd: From: koul.ash...@gmail.com To: excel-macros@googlegroups.com hi dave can you explain the formula how it is working =FIND(CHAR(1),SUBSTITUTE(A1, ,CHAR(1),LEN(TRIM(A1))-LEN( SUBSTITUTE(A1, , On Fri, Jul 2, 2010 at 10:29 PM, praveen kumar bhspra...@gmail.comwrote: Here with have attached one pdf file. from that if i copy paste data to excel then it will show country name numbers together like this 1 United States 14,093,310 2 China 7,909,261 I want to seprate this country names numbers here. If have found out the position of the space from the right can use mid other formula to get the numbers separately. I hope this will makes you clear about my objective. Also let me if there is any other way to do the same. Thanks in advance On Fri, Jul 2, 2010 at 9:38 PM, krishna mummina lovemekris...@gmail.com wrote: 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 -- 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
Re: $$Excel-Macros$$ Hi, need your help - urgent
Good! But instead of copy paste we can use bring to front by keeping all images on same position. On Thu, Jul 1, 2010 at 7:38 PM, ashish koul koul.ash...@gmail.com wrote: hi Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) If ActiveCell.Row = 2 And ActiveCell.Column = 1 Then Call deletshape Sheets(Sheet1).Select Range(E9).Select Selection.Delete Sheets(2).Shapes(1).Copy Sheets(Sheet1).Select Range(E9).Select ActiveSheet.Paste ElseIf ActiveCell.Row = 3 And ActiveCell.Column = 1 Then Call deletshape Sheets(2).Shapes(2).Copy Sheets(Sheet1).Select Range(E9).Select ActiveSheet.Paste ElseIf ActiveCell.Row = 4 And ActiveCell.Column = 1 Then Call deletshape Sheets(2).Shapes(3).Copy Sheets(Sheet1).Select Range(E9).Select ActiveSheet.Paste ElseIf ActiveCell.Row = 5 And ActiveCell.Column = 1 Then Call deletshape Sheets(2).Shapes(4).Copy Sheets(Sheet1).Select Range(E9).Select ActiveSheet.Paste End If End Sub Sub deletshape() Dim sh As Shape For Each sh In Sheets(1).Shapes If sh.Type = msoPicture Then sh.Delete End If Next sh End Sub ashish koul akoul.blogspot.com On Thu, Jul 1, 2010 at 5:44 PM, Rajender Soni soni.rajen...@gmail.comwrote: Hi Pls find attached the excel file, I just want that when I move my mouse cursor over a cell, the image having the name equal to cell's value will get displayed, pls open the attached excel file for more clarification. Regards Rajender Soni -- -- 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 -- -- 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$$
Hi Ankit, Use ASAP utilities, it will solve your problem. On Tue, Jul 6, 2010 at 1:02 PM, Ankit Chandna ankit.chan...@yahoo.inwrote: Hi, hi to all ..i need a help PFA and help me to get reqired result. Regards, Ankit -- -- 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 -- With Love, Mahesh Bisht -- -- 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$$ Fwd:
Hi All, =LEN(A1)+1-FIND(CHAR(1),SUBSTITUTE(A1, ,CHAR(1),LEN(TRIM(A1))- LEN(SUBSTITUTE(A1, , The above formula works for me. Thanks a lot for all your efforts in helping me to solve this issue. On Sat, Jul 3, 2010 at 8:44 AM, ju...@thepepeshow.com jmora...@gmail.com wrote: Dave, I think Praveen was looking for the count from right to left. Your example formula results with 17 not 8. However, building on your formula, you can simply subtract from the length of the cell. Here is counting from right to left: =LEN(A1)+1-FIND(CHAR(1),SUBSTITUTE(A1, ,CHAR(1),LEN(TRIM(A1))- LEN(SUBSTITUTE(A1, , Praveen, let us know what works for you. On Jul 2, 4:37 pm, Dave Bonallack davebonall...@hotmail.com wrote: Hi Praveen, It's a bit long-winded, but here's a formula to find the position of the last space in Cell A1: =FIND(CHAR(1),SUBSTITUTE(A1, ,CHAR(1),LEN(TRIM(A1))-LEN(SUBSTITUTE(A1, , Regards - Dave. Date: Fri, 2 Jul 2010 19:48:01 +0530 Subject: $$Excel-Macros$$ Fwd: From: bhspra...@gmail.com To: excel-macros@googlegroups.com 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 athttp://www.excel-macros.blogspot.com 4. Learn VBA Macros athttp://www.quickvba.blogspot.com 5. Excel Tips and Tricks athttp://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 athttp://groups.google.com/group/excel-macros/subscribe _ New, Used, Demo, Dealer or Private? Find it at CarPoint.com.auhttp://clk.atdmt.com/NMN/go/206222968/direct/01/ -- -- 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 -- 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
Re: $$Excel-Macros$$
Hi, Please find the attached file for your required solution. Regards Sandeep On Tue, Jul 6, 2010 at 4:28 PM, Ankit Chandna ankit.chan...@yahoo.inwrote: Dear, Can u plz tell me exact procedure.i do hv ASAP utilities. --- On *Tue, 6/7/10, Mahesh mahender.bi...@gmail.com* wrote: From: Mahesh mahender.bi...@gmail.com Subject: Re: $$Excel-Macros$$ To: excel-macros@googlegroups.com Date: Tuesday, 6 July, 2010, 9:50 AM Hi Ankit, Use ASAP utilities, it will solve your problem. On Tue, Jul 6, 2010 at 1:02 PM, Ankit Chandna ankit.chan...@yahoo.inhttp://in.mc950.mail.yahoo.com/mc/compose?to=ankit.chan...@yahoo.in wrote: Hi, hi to all ..i need a help PFA and help me to get reqired result. Regards, Ankit -- -- 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.comhttp://in.mc950.mail.yahoo.com/mc/compose?to=excel-mac...@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 -- With Love, Mahesh Bisht -- -- 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 -- -- 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 help.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$
Hi, I think this formula may be useful for your requirement. =MID(B4,(FIND(-,B4)+1),(LEN(B4)-(FIND(-,B4 Let me know if it works On Tue, Jul 6, 2010 at 4:28 PM, Ankit Chandna ankit.chan...@yahoo.inwrote: Dear, Can u plz tell me exact procedure.i do hv ASAP utilities. --- On *Tue, 6/7/10, Mahesh mahender.bi...@gmail.com* wrote: From: Mahesh mahender.bi...@gmail.com Subject: Re: $$Excel-Macros$$ To: excel-macros@googlegroups.com Date: Tuesday, 6 July, 2010, 9:50 AM Hi Ankit, Use ASAP utilities, it will solve your problem. On Tue, Jul 6, 2010 at 1:02 PM, Ankit Chandna ankit.chan...@yahoo.inhttp://in.mc950.mail.yahoo.com/mc/compose?to=ankit.chan...@yahoo.in wrote: Hi, hi to all ..i need a help PFA and help me to get reqired result. Regards, Ankit -- -- 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.comhttp://in.mc950.mail.yahoo.com/mc/compose?to=excel-mac...@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 -- With Love, Mahesh Bisht -- -- 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 -- 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
$$Excel-Macros$$ Need code for Sort Sub-totals
Hi all, Need your help!!! I need a code for sorting sub-totals for the data which keeps (range) changing every day. Could you please help me in providing the Macro code at the earliest. Thanks for your help in advance! Srinivas -- -- 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
$$Excel-Macros$$ How to alter the contents of a row in a sheet
Hi All I was wondering if you could help. I have a column of data which is Column B within a sheet that I wish to alter, the data has the following format : XXX|XXX and I wish to change the contents of the cells in the column from XXX|XXX to [village]XXX|XXX[/village] using a single button. So essentially I want to add the text [village] before the co-ords and the text [/village] after the co-ords in each cell in column B can anyone help?? Thanks very much Alex Ps I can supply the sheet if needed J -- -- 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
$$Excel-Macros$$ COMPARING TEXT BETWEEN TO CELL DIFFERENCE IN THE THIRD CELL
Hello Friends I want to know that can it possible the following idea. Cell A1 contains text Shri Ram Chandra Cell B1 contains text - Shri RAM cHANDRAs I want to that i want the formula in C1 -- which give me the result of that difference between this A1 B1 the answer is only last word - S BUT 1] The difference of Capital Letter Small letter can be point out. 2] The space should not be taken into account 3] The cell may also contain - both text number also like BHCD 1234 DELETE Can it possible if yes by witch formula ? Have a nice day Thanks Savla -- -- 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
$$Excel-Macros$$ AUTO MAKE WORD FILE
Dear Friends, how to auto generate .doc file using excel data.. in excel sheet cell A1 -- ID NUMBER and B1 -- DETAILS For Example * A1 B1* *ID NUMBER* * DETAILS * 1 012345AMIT KUMAR S/O RAM KUMAR ADD- 2 012478KAMAL RAWAT S/O SUMAN SINGH ADD--111 *B1 cell (DETAILS) details Length min 1000 char and max 5000 char.* i want auto generate .doc file and file name is ID NUMBER and .doc file data DETAILS I want to know that can it possible the following idea. -- One Team One Dream One Goal Warm Regards, Vikas Chauhan E-Mail :- vikask...@gmail.com,vikask...@rediffmail.com, 9911868518, We can't Spell S_ccess without U Life is Very beautiful !!! ¨`•.•´¨) Always `•.¸(¨`•.•´¨) Keep (¨`•.•´¨)¸.•´ Smiling! `•.¸.•´. -- -- 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 alter the contents of a row in a sheet
Hi Alex, Please find attached the solution. I have used the following code inside a module Sub village() ' This loop runs until there is nothing in the last cell ' Aindril De (Andy) Do ActiveCell.Value = [village] ActiveCell.Value [/village] ActiveCell.Offset(1, 0).Select Loop Until IsEmpty(ActiveCell) End Sub *To run this code. click on the first cell where you want to start the changes (in my example it is cell B2) and then click on the button named village.* Pl let me know if u need any further help on this. Cheers!!, Andy On Tue, Jul 6, 2010 at 8:11 PM, Alexander Cargill zanderman1...@googlemail.com wrote: Hi All I was wondering if you could help. I have a column of data which is Column B within a sheet that I wish to alter, the data has the following format : XXX|XXX and I wish to change the contents of the cells in the column from XXX|XXX to [village]XXX|XXX[/village] using a single button. So essentially I want to add the text [village] before the co-ords and the text [/village] after the co-ords in each cell in column B can anyone help?? Thanks very much Alex Ps I can supply the sheet if needed J -- -- 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 Alexander.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Help Reqired Loop in macros
Hi Venkat, * The purpose of a loop is to get Excel to repeat a piece of code a certain number of times. How many times the code gets repeated can be specified as a fixed number (e.g. do this 10 times), or as a variable (e.g. do this for as many times as there are rows of data). Loops can be constructed many different ways to suit different circumstances. Often the same result can be obtained in different ways to suit your personal preferences. These exercises demonstrate a selection of different ways to use loops. There are two basic kinds of loops, both of which are demonstrated here: Do…Loop and For…Next loops. The code to be repeated is placed between the key words. Please refer to the attached link below and the example attached to it for further clarity. http://www.exceltip.com/st/Using_Loops_in_VBA_in_Microsoft_Excel/628.html Please let me know if u need any further help on this. Cheers!!, Andy * On Tue, Jul 6, 2010 at 3:31 PM, Venkatesan c venkat1@gmail.com wrote: Dear Group, What you mean by Loop in MacrosUse .can i have explanation with Example Best Regards, * Venkat * -- -- 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