Re: $$Excel-Macros$$ EXCEL SHORTCUT -- PLEASE HELP :-)
Select the function and press tab. Thanks Regards Sandeep On Thu, May 6, 2010 at 11:38 PM, Michael mich...@michaelkwak.net wrote: I posted a picture of what I'm trying to discover: http://excel-macros.googlegroups.com/web/5-6-2010%2010-30-03%20AM.png?gsc=KEUGpSMAAABiUNuXkcp8v73inTrP5WRB6rVQQoo7NfTRwCUKHBmr860IoyLhPG2x5smOr2otMGI Does anyone know of a shortcut to select from the drop down of suggested terms when creating a formula? (i.e. what would I need to press on my keyboard to finish populating the chain named range into my formula without typing out the thing?) Currently, I know you need to double click with your mouse to accomplish this; however, it's cumbersome when updating complex array formulas. Thanks so much for yoour help in advance! Michael -- -- 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 6,800 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 6,800 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$$ Excel Bug ?
Dear All, Last time 1 of my friend come to me and ask that he is using to search ? and want to replace it 0 just try it,in range a:a values are,i.e 1 1 1 1 1 1 ? ? 1 ? ? ? 1 1 ? Now when u will try to search ? and replace with 0,have a look what happen -- Thanks Regards Shyam Software Engineer '' When one door of happiness closes, another opens; but often we look so long at the closed door that we do not see the one which has been opened for us. - Helen Keller '' Wenn eine Tür des Glücks schließt, öffnet sich ein weiteres, aber oft schauen wir so lange auf die geschlossene Tür, dass wir nicht sehen ein, die für uns geöffnet wurde. - Helen Keller '' -- -- 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 6,800 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$$ Re: Extract Right Word in Line
Thanks Ashish. You have cleared my burden. Thanks a ton. Thanks and Regards, Anand S On Thu, May 6, 2010 at 9:22 PM, ashish koul koul.ash...@gmail.com wrote: Public Function exright(Str) Dim i, NumStr1 NumStr1 = For i = Len(Str) To 1 Step -1 If (Mid(Str, i, 1))Then NumStr1 = Mid(Str, i, 1) NumStr1 Else Exit For End If Next i exright = NumStr1 End Function On Thu, May 6, 2010 at 6:15 PM, anand shivappa anand.shiva...@gmail.comwrote: Please help out. I got struct here. On Thu, May 6, 2010 at 5:45 PM, anand shivappa anand.shiva...@gmail.comwrote: Hi Everyone, I need to extract a rightmost word in a line through excel functions. Like USA Street is having no 10. I need to extract the last word like 10. Please help me out. Thanks and Regards, Anand S -- When everything fails Patience will win -- When everything fails Patience will win -- -- 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 6,800 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 6,800 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 -- When everything fails Patience will win -- -- 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 6,800 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$$ Re: Extract Right Word in Line
hi anand how are you AB 1 vikas kumar =right(A1,LEN(A1)-FIND( ,A1) RESULT IS KUMAR On Thu, May 6, 2010 at 9:39 AM, P.VIJAYKUMAR vijay.4...@gmail.com wrote: Use the function RIGHT(Select the whole text in which the textor the thing which you want is there,number of characters which you want from the text) Ex: If a Cell B2 ContainsTIGER999 .Use the function = RIGHT(B2,3) to get the required 999 as the answer. On Thu, May 6, 2010 at 9:22 PM, ashish koul koul.ash...@gmail.com wrote: Public Function exright(Str) Dim i, NumStr1 NumStr1 = For i = Len(Str) To 1 Step -1 If (Mid(Str, i, 1))Then NumStr1 = Mid(Str, i, 1) NumStr1 Else Exit For End If Next i exright = NumStr1 End Function On Thu, May 6, 2010 at 6:15 PM, anand shivappa anand.shiva...@gmail.comwrote: Please help out. I got struct here. On Thu, May 6, 2010 at 5:45 PM, anand shivappa anand.shiva...@gmail.com wrote: Hi Everyone, I need to extract a rightmost word in a line through excel functions. Like USA Street is having no 10. I need to extract the last word like 10. Please help me out. Thanks and Regards, Anand S -- When everything fails Patience will win -- When everything fails Patience will win -- -- 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 6,800 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 6,800 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 -- 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 HELP US GROW !! We reach over 6,800 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 -- 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 6,800 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$$ Need Help to pickup Rate List for formula
Thanks for reply. With Regards, Hitesh. From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of ashish koul Sent: Thursday, May 06, 2010 3:55 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Need Help to pickup Rate List for formula USE THIS ONE =VLOOKUP(C6,INDIRECT(B6!A:I),2+MATCH('Inv for Rate'!D6,INDIRECT(B6!$C$2:$I$2),0),0) Inv for Rate'!D6, specifies the value of cell d6 of sheet name Inv for Rate' On Thu, May 6, 2010 at 11:48 AM, vidyut more vidyutm...@gmail.com wrote: Thnaks for ur sollution. I have given sample ,anybody has formula for to many parties and rate is different for each party i want to know. On Thu, May 6, 2010 at 10:19 AM, Hitesh Dilipbhai Dhare hitesh.dh...@idea.adityabirla.com wrote: Can you tell me, what is the meaning of following argument in the solution provided? 'Inv for Rate'!D8 With Regards, Hitesh From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of ashish koul Sent: Wednesday, May 05, 2010 10:59 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Need Help to pickup Rate List for formula check the attachment On Wed, May 5, 2010 at 6:56 PM, vidyut more vidyutm...@gmail.com wrote: I have attached sample file. I want formula for picking up rate from excel sheets. Thanks in advance -- -- 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 http://www.excel-macros.blogspot.com/ 4. Learn VBA Macros at http://www.quickvba.blogspot.com http://www.quickvba.blogspot.com/ 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com http://exceldailytip.blogspot.com/ To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 6,800 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 http://www.excel-macros.blogspot.com/ 4. Learn VBA Macros at http://www.quickvba.blogspot.com http://www.quickvba.blogspot.com/ 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com http://exceldailytip.blogspot.com/ To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 6,800 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 ideacellular.com http://ideacellular.com/ E-Mail Domain is now idea.adityabirla.com http://idea.adityabirla.com/ E-Mail Domain ** Visit www.ideacellular.com http://www.ideacellular.com/ to know more about latest Products, tariffs, online payments and recharges. ** An idea can change your life. ** LEGAL DISCLAIMER This E-Mail may contain Confidential and/or legally privileged Information and is meant for the intended recipient(s) only. If you have received this e-mail in error and are not the intended recipient/s, kindly notify us at mailad...@idea.adityabirla.com and then delete this e-mail immediately from your system. You are also hereby notified that any use, any form of reproduction, dissemination, copying, disclosure, modification, distribution and/or publication of this e-mail, its contents or its attachment/s other than by its intended recipient/s is strictly prohibited and may be unlawful. Internet Communications cannot be guaranteed to be secure or error-free as information could be delayed, intercepted, corrupted, lost, or contain viruses. IDEA Cellular Limited does not accept any liability for any errors, omissions, viruses or computer problems experienced by any recipient as a result of this e-mail. -- -- Some
Re: $$Excel-Macros$$ Date formatting
Dear Members I was just trying to calculate a similer thing but could not. Please help me too. I need to add a certain number of years to a date and get the resulting date. HOW? Thanks AZHAR RAI Skype: azhar.rai On 6 May 2010 16:13, dare2gold goldiechoudh...@gmail.com wrote: Dear Members,., i want to know how to get a later date just by inserting present date into one column and getting the date we desire just by typing the no of days suppose i entered 1.04.2010 29days the output should be 30.04.2010. please tell me ... thanks in anticipations goldie -- -- 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 6,800 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 6,800 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$$ TOUGH QUESTION
Dear Members Can someone help me create a trick related to mail merge in Office 2007/2010. I want to mail merge pictures FROM an excel sheet (where there are hyperlink to different pictures) TO a word document. Your help will save a lot of my time and efforts. Regards AZHAR RAI Cell: 0333-552-7731 Skype: azhar.rai -- -- 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 6,800 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$$ prima and non-prima
hi all, im new member in this group.. I want to find a number of non-prime numbers.. (please see attachment) example READ 45 RESULT NON-PRIMA 3 5 9 15 … i read the number 15 the result will be NON-PRIMA and the below cell (optional) will create a number that can be divide by *read number* Thanks for all of ur attention L-van -- -- 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 6,800 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 prima_nonprima-EXCELMACRO.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ prima and non-prima
hi all, im new member in this group.. I want to find a number of non-prime numbers.. (please see attachment) http://groups.google.com/group/excel-macros/web/prima_nonprima-EXCELMACRO.xls example READ45 RESULT NON-PRIMA 3 5 9 15 … if i read the number 15 the result will be NON-PRIMA and the below cell (optional) will create a number that can be divide by read number Thanks for all of ur attention L-van -- -- 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 6,800 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$$ Find the last 5 users
Someone has changed data in my sheet and i want to know the last 5 users , is there any possiblity to track the users -- -- 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 6,800 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$$ Pivot Table Help - Gross Margin % % of Sales
Hi, Just see the attached file and confirm If this is what you are looking for. Best Regards, Guru On Tue, May 4, 2010 at 8:57 PM, dza7 dvpe...@gmail.com wrote: Hello, I have a challenging pivot table issue that I hope I can get some help on. Here is the spreadsheet I'm working with: https://www.yousendit.com/download/OHo0N3RSSU90d0UwTVE9PQ I'm having problems with showing percentages in my pivot table such as gross margin and operational profit. Here is the PL pivot table as I have it now, as you can see I can't get the Gross Margin % to output a number. Both Gross Margin % and Operational Profit % are calculated fields I've added to the pivot table since the raw data only includes sales, cost of goods sold expenses. I believe that this has something to do with the detail that I want to show in different parts of the PL. With that in mind I've attempted to add new fields to the data to help but still no success. I can add as much as it is needed to the data to make this work (outside of changing the first column and the PTD, QTD YTD figures which are output from our system) but I'm at a standstill. Can someone help!?! I have to roll this out amongst different divisions and it's going to be a killer tool if I can figure it out! Thanks in advance. Dvpetta Dza -- -- 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 6,800 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 6,800 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 COMPARISON Pamp;L.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
$$Excel-Macros$$-Macro to Prepare Letters
Hello Team, I am looking at a macro to write letter in word (a predefine letter format) with certain field to be picked from an excel-sheet source. Request you to send me macro code. Thanks and Regards Atul Kesaria -- -- 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 6,800 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$$ EXCEL SHORTCUT -- PLEASE HELP :-)
sorry did not get select the funcion and presss tab can u expalin this dear friend On Fri, May 7, 2010 at 11:54 AM, Sandeep Kumar Maurya sandymau...@gmail.com wrote: Select the function and press tab. Thanks Regards Sandeep On Thu, May 6, 2010 at 11:38 PM, Michael mich...@michaelkwak.net wrote: I posted a picture of what I'm trying to discover: http://excel-macros.googlegroups.com/web/5-6-2010%2010-30-03%20AM.png?gsc=KEUGpSMAAABiUNuXkcp8v73inTrP5WRB6rVQQoo7NfTRwCUKHBmr860IoyLhPG2x5smOr2otMGI Does anyone know of a shortcut to select from the drop down of suggested terms when creating a formula? (i.e. what would I need to press on my keyboard to finish populating the chain named range into my formula without typing out the thing?) Currently, I know you need to double click with your mouse to accomplish this; however, it's cumbersome when updating complex array formulas. Thanks so much for yoour help in advance! Michael -- -- 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 6,800 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 6,800 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 6,800 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$$ EXCEL SHORTCUT -- PLEASE HELP :-)
When we write function in any excel cell, EXCEL 2007 shows us a list of functions available from the word or character we written in the cell. Michael wants to know how we can get the function in the cell when list appears without writing it completely. So the solution is start to write your function in cell and when list appears then go to the desired function by down arrow key and then press tab to get the function in cell. Thanks Regards Sandeep On Fri, May 7, 2010 at 1:03 PM, L.K. Modi ca.mod...@gmail.com wrote: sorry did not get select the funcion and presss tab can u expalin this dear friend On Fri, May 7, 2010 at 11:54 AM, Sandeep Kumar Maurya sandymau...@gmail.com wrote: Select the function and press tab. Thanks Regards Sandeep On Thu, May 6, 2010 at 11:38 PM, Michael mich...@michaelkwak.net wrote: I posted a picture of what I'm trying to discover: http://excel-macros.googlegroups.com/web/5-6-2010%2010-30-03%20AM.png?gsc=KEUGpSMAAABiUNuXkcp8v73inTrP5WRB6rVQQoo7NfTRwCUKHBmr860IoyLhPG2x5smOr2otMGI Does anyone know of a shortcut to select from the drop down of suggested terms when creating a formula? (i.e. what would I need to press on my keyboard to finish populating the chain named range into my formula without typing out the thing?) Currently, I know you need to double click with your mouse to accomplish this; however, it's cumbersome when updating complex array formulas. Thanks so much for yoour help in advance! Michael -- -- 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 6,800 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 6,800 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 6,800 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 6,800 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$$ Excel Bug ?
Hi, Because ? is a special character set in computer, if you want to find it you must prefix it with tilde in the find. ( ~?) http://support.microsoft.com/kb/214138 --- On Fri, May 7, 2010 at 3:05 PM, rf1234 rf1234 rfhyd1...@gmail.com wrote: Dear All, Last time 1 of my friend come to me and ask that he is using to search ? and want to replace it 0 just try it,in range a:a values are,i.e 1 1 1 1 1 1 ? ? 1 ? ? ? 1 1 ? Now when u will try to search ? and replace with 0,have a look what happen -- Thanks Regards Shyam Software Engineer '' When one door of happiness closes, another opens; but often we look so long at the closed door that we do not see the one which has been opened for us. - Helen Keller '' Wenn eine Tür des Glücks schließt, öffnet sich ein weiteres, aber oft schauen wir so lange auf die geschlossene Tür, dass wir nicht sehen ein, die für uns geöffnet wurde. - Helen Keller '' -- -- 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 6,800 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 6,800 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$$ VBA code to delete all dates before last week
Assuming that : * YOUR LIST OF DATE are in a Range * to delete means to clear the content of a cell containing Date data Sub DoSomething() Dim MyRange as Range, Xel As Range Dim LastWeekWednesday As Date '--Please edit the code for your Range Set MyRange = Sheets(Bla).Range(A2:A65533) LastWeekWednesday = Date - Weekday(Date) - 3 For Each Xel In MyRange If Xel.Value LastWeekWednesday Then Xel.ClearContents Next End Sub On May 6, 8:08 pm, Sundarvelan N nsund...@gmail.com wrote: Hi Friends, Please help me to delete the date which are older than last week wednesday. Also i need a code to remove page breaks except the below recoded code ActiveSheet.VPageBreaks(1).DragOff Direction:=xlToRight, RegionIndex:=1 Thanks N.Sundarvelan -- -- 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 6,800 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$$ prima and non-prima
Dim ArrDevisors() Sub BlaBlaBlaBla() ' siti Vi / bluewater, indonesia / 7 May 2010 Dim MyCell As Range Dim isPrima As String, n As Long Set MyCell = Selection isPrima = IsPrimeNumber(MyCell.Value) MyCell(1, 4) = Result: MyCell(1, 5) = isPrima If isPrima = NON-PRIMA Then For n = 1 To UBound(ArrDevisors) MyCell(1 + n, 5) = ArrDevisors(n) Next n End If End Sub Private Function IsPrimeNumber(aNumber As Long) As String ' siti Vi / bluewater, indonesia /14 Dec 2005 Dim AreYou As Boolean Dim Devisor As Long Dim i As Long AreYou = True For Devisor = 2 To aNumber If aNumber Mod Devisor = 0 Then AreYou = False i = i + 1: ReDim Preserve ArrDevisors(1 To i) ArrDevisors(i) = Devisor End If Next If aNumber = 0 Then AreYou = False IsPrimeNumber = IIf(AreYou, PRIMA, NON-PRIMA) End Function ' NOTE: '-- before running the makro (BlaBlaBla procedure) '-- you have to select the cell (single cell) containing the number. On May 7, 12:56 pm, L- Van elvan.bys...@gmail.com wrote: hi all, im new member in this group.. I want to find a number of non-prime numbers.. (please see attachment)http://groups.google.com/group/excel-macros/web/prima_nonprima-EXCELM... example READ 45 RESULT NON-PRIMA 3 5 9 15 … if i read the number 15 the result will be NON-PRIMA and the below cell (optional) will create a number that can be divide by read number Thanks for all of ur attention L-van -- -- 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 6,800 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$$ prima and non-prima
there is a little correction in my code '--- Dim ArrDevisors() Sub BlaBlaBlaBla() ' siti Vi / bluewater, indonesia / 7 May 2010 Dim MyCell As Range Dim isPrima As String, n As Long Set MyCell = Selection isPrima = IsPrimeNumber(MyCell.Value) MyCell(1, 4) = Result: MyCell(1, 5) = isPrima If isPrima = NON-PRIMA Then For n = 1 To UBound(ArrDevisors) MyCell(1 + n, 5) = ArrDevisors(n) Next n End If End Sub Private Function IsPrimeNumber(aNumber As Long) As String ' siti Vi / bluewater, indonesia /14 Dec 2005 Dim AreYou As Boolean Dim Devisor As Long Dim i As Long AreYou = True For Devisor = 2 To aNumber - 1 If aNumber Mod Devisor = 0 Then AreYou = False i = i + 1: ReDim Preserve ArrDevisors(1 To i) ArrDevisors(i) = Devisor End If Next If aNumber = 0 Then AreYou = False IsPrimeNumber = IIf(AreYou, PRIMA, NON-PRIMA) End Function '- On May 7, 12:53 pm, L- Van elvan.bys...@gmail.com wrote: hi all, im new member in this group.. I want to find a number of non-prime numbers.. (please see attachment) example READ 45 RESULT NON-PRIMA 3 5 9 15 … i read the number 15 the result will be NON-PRIMA and the below cell (optional) will create a number that can be divide by *read number* Thanks for all of ur attention L-van -- -- 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 6,800 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$$ Re: Extract Right Word in Line
I am fine buddy. If it is more than 5 words in a cell how will you extract the right word. Probably Ashish has sent was the perfect solution for it. Thanks and Regards, Anand S On Fri, May 7, 2010 at 9:49 AM, Vikas Chouhan vikask...@gmail.com wrote: hi anand how are you AB 1 vikas kumar =right(A1,LEN(A1)-FIND( ,A1) RESULT IS KUMAR On Thu, May 6, 2010 at 9:39 AM, P.VIJAYKUMAR vijay.4...@gmail.com wrote: Use the function RIGHT(Select the whole text in which the textor the thing which you want is there,number of characters which you want from the text) Ex: If a Cell B2 ContainsTIGER999 .Use the function = RIGHT(B2,3) to get the required 999 as the answer. On Thu, May 6, 2010 at 9:22 PM, ashish koul koul.ash...@gmail.comwrote: Public Function exright(Str) Dim i, NumStr1 NumStr1 = For i = Len(Str) To 1 Step -1 If (Mid(Str, i, 1))Then NumStr1 = Mid(Str, i, 1) NumStr1 Else Exit For End If Next i exright = NumStr1 End Function On Thu, May 6, 2010 at 6:15 PM, anand shivappa anand.shiva...@gmail.com wrote: Please help out. I got struct here. On Thu, May 6, 2010 at 5:45 PM, anand shivappa anand.shiva...@gmail.com wrote: Hi Everyone, I need to extract a rightmost word in a line through excel functions. Like USA Street is having no 10. I need to extract the last word like 10. Please help me out. Thanks and Regards, Anand S -- When everything fails Patience will win -- When everything fails Patience will win -- -- 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 6,800 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 6,800 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 -- 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 HELP US GROW !! We reach over 6,800 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 -- 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 6,800 subscribers worldwide and receive many nice notes about the learning and support from the
Re: $$Excel-Macros$$ Date formatting
Hi Goldie, PFA the solution. Regards, Aindril On Thu, May 6, 2010 at 4:43 PM, dare2gold goldiechoudh...@gmail.com wrote: Dear Members,., i want to know how to get a later date just by inserting present date into one column and getting the date we desire just by typing the no of days suppose i entered 1.04.2010 29days the output should be 30.04.2010. please tell me ... thanks in anticipations goldie -- -- 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 6,800 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 6,800 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 aindril.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Date formatting
Hi Azhar, PFA the solution Regards, Andy On Fri, May 7, 2010 at 10:27 AM, Azhar Rai azhar@gmail.com wrote: Dear Members I was just trying to calculate a similer thing but could not. Please help me too. I need to add a certain number of years to a date and get the resulting date. HOW? Thanks AZHAR RAI Skype: azhar.rai On 6 May 2010 16:13, dare2gold goldiechoudh...@gmail.com wrote: Dear Members,., i want to know how to get a later date just by inserting present date into one column and getting the date we desire just by typing the no of days suppose i entered 1.04.2010 29days the output should be 30.04.2010. please tell me ... thanks in anticipations goldie -- -- 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 6,800 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 6,800 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 6,800 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 aindril.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$-Macro to Prepare Letters
Hi atul, Why dont u use mail merge. Regards, Andy On Fri, May 7, 2010 at 12:38 PM, Atul Kesaria atul.kesa...@gmail.comwrote: Hello Team, I am looking at a macro to write letter in word (a predefine letter format) with certain field to be picked from an excel-sheet source. Request you to send me macro code. Thanks and Regards Atul Kesaria -- -- 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 6,800 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 6,800 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$$ TOUGH QUESTION
Hi azhar, Are these images stored somewhere in your local disk or online? Regards, aindril On Fri, May 7, 2010 at 10:46 AM, Azhar Rai azhar@gmail.com wrote: Dear Members Can someone help me create a trick related to mail merge in Office 2007/2010. I want to mail merge pictures FROM an excel sheet (where there are hyperlink to different pictures) TO a word document. Your help will save a lot of my time and efforts. Regards AZHAR RAI Cell: 0333-552-7731 Skype: azhar.rai -- -- 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 6,800 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 6,800 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$$ VBA DATE
Hi Friends, Can any one help me to solve the below condition *HIGHLIGHT ANYTHING OVER 30 DAYS SINCE LAST ACTION FILL IN COLOR YELLOW* Thanks, N.Sundarvelan -- -- 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 6,800 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$$
good to hear from u shyam, I am currently using trade tiger from sharekhan and i have a strategy that i think is profitable, wanted to know if i can use excel to automate my strategy nitin gupta 9731423808 -- -- 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 6,800 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$$ Excel Bug ?
Shyam: Good Catch OSA: Good Solution... Thanks to both, for sharing this Harry On May 7, 1:14 pm, OSA osav...@gmail.com wrote: Hi, Because ? is a special character set in computer, if you want to find it you must prefix it with tilde in the find. ( ~?) http://support.microsoft.com/kb/214138 --- On Fri, May 7, 2010 at 3:05 PM, rf1234 rf1234 rfhyd1...@gmail.com wrote: Dear All, Last time 1 of my friend come to me and ask that he is using to search ? and want to replace it 0 just try it,in range a:a values are,i.e 1 1 1 1 1 1 ? ? 1 ? ? ? 1 1 ? Now when u will try to search ? and replace with 0,have a look what happen -- Thanks Regards Shyam Software Engineer '''''' When one door of happiness closes, another opens; but often we look so long at the closed door that we do not see the one which has been opened for us. - Helen Keller '''''' Wenn eine Tür des Glücks schließt, öffnet sich ein weiteres, aber oft schauen wir so lange auf die geschlossene Tür, dass wir nicht sehen ein, die für uns geöffnet wurde. - Helen Keller '''''' -- ------ 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 6,800 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 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 6,800 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- 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 6,800 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$$ Ebook on Excel 2003 VBA
Jaao Matoso, The link doesnt work Harry On May 7, 2:35 am, João Matoso jcmat...@gmail.com wrote: www.tudosobrexcell.com 2010/5/6 nagendra baral mr.nagendraba...@gmail.com Hi There Please send some website links which can be helpful in learning Excel VBA and downloading Ebooks. Thanks and Regards Nagendra I -- ------ 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 6,800 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 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 6,800 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- 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 6,800 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$$ CC in Mail Merge
Guys, I wanted to add CC or Multiple Receipients in a Mail Merge. Is there be any Possiblity then please let me know. Regards Rahul Gandhi. -- -- 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 6,800 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$$ Re: Please help In seperating alphabets and numbers from a cell
Guys I am very Sorry for turning up very late and giving you an alarm with respect to that all the above formula will not work if we found any alphanumeric string Lets take an example if we have appended string then the above formula will not work. Hello my 9711 no is in 77 alpha numeric 2297 string, and my 14 home address is 49 Sorry Dave and Harmeet ! Regards, Rahul Gandhi +91-9711772297 On Apr 1, 4:15 pm, Dipika Mallya blraspirants...@gmail.com wrote: Great point Paul, @Abhi To add to Paul's Excell insight with a working example, Suppose two functional links.http://j.mp/gate2010csithttp://j.mp/gate2010cs exist Does your function need to identify the csit link from the cs link or not. Regards, DMhttp://anonomi.com/inamehttp://anonomi.com/DM On Wed, Mar 31, 2010 at 2:24 AM, paulwillekens paul.johan.willek...@gmail.com wrote: Hi Abhidha, Please specify what the result is you look for... is it jdsdnc versus 2123 versus asdd ... or only extraction of the number 2123 ? is it iofruif versus 68732 versus fnw ... or simply 68732 ? do digits appear separated by alphabetical characters on some occasions or never? As soon as I get that cleared out, I'll send you the routine you need... Greetings, Paul Willekens -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 6,800 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 To unsubscribe, reply using remove me as the subject. -- -- 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 6,800 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