$$Excel-Macros$$ GST 2A MATCHING
ANYBODY HAVE GST 2A MATCHING TOOL FOR GST, IF SO PLEASE SEND ME THE SAME. IF NOT PLEASE TELL ME HOW COULD I MATCH 2 EXCEL SHEETS. THANKS IN ADVANCE REGARDS HARI NAIR -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
$$Excel-Macros$$ Help Required
Sir, I have an attached tamplete called advice, I want to make a data sheet each time I save a work book from the advice. Please help Thanks in advance -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. Order-advice.xlsx Description: MS-Excel 2007 spreadsheet
Re: $$Excel-Macros$$ Re: Introduce Yourself !!
Access import from excel Once u created one data table n data, if the same details are in other 4 worksheets also. Use import from excel say append to existing data. Exact options changes from ur version's of office On Jan 23, 2014 5:24 AM, fahad hassan fahadhassan...@gmail.com wrote: Hey i want to ask a question regarding data transferring from excel to access. I have 4 excel sheets with data in it. i want to copy each of the sheet into a table (which is already existing) in Access. Can someone please help me with a method to perform this in a single step??? -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
$$Excel-Macros$$ Continues deduction
I want to deduct continues percentages from one amount.(i.e. assume that 100 in a1 then I want 100-2%-3%-4%-1.5% from that amount, the result should be (89.89) How can I enter formula) Regards, thanks in advance -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Want Excel formula to Omit saturday sunday!
Networkdays( stdate, end date,[holidays] Thanks Regards Hari Kumar Our strength grows from our weakness. On Jun 17, 2014 10:28 AM, pankaj khairanar pankajkh...@gmail.com wrote: Hi Expert, I want excel formula for below scenario. Date-9=result If result=saturday or sunday then omit saturday or sunday and consider monday. Extample1 02/June/14 - 9=Saturday, May 24, 2014 Want to omit this saturday and sunday want result as Monday, May 26,2014 Extample2 03/June/14 - 9=Sunday, May 25, 2014 Want to omit this sunday and want result as Monday, May 26,2014 Regards, Pankaj -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Date wise amount Invoice Nos. wanted to merge
Assuming data in cells a1 to e5 A6 cell value= If(and(a2=a3,a2=a4,a2=a5),a2,not same date)) B5 cell value = Sum (b2:b5) C5 cell value= C2/c3/c4/c5 Thanks Regards Hari Kumar Our strength grows from our weakness. On Jun 6, 2014 8:31 AM, Pravin Gunjal isk1...@gmail.com wrote: Dear Friends Good Evening, I have attached a working file and need help as follows: 1. The amount to be added in the above cell, if the date party is unique. 2. Invoice No. to be added by giving slash (/) For Example: Before Workout *Due Date* *Amount* *Inv No* *Party Name* 17.06.2014 32,174.00 1579001280 Annapurna Distributo - Latur 17.06.2014 2,123.00 1579001281 Annapurna Distributo - Latur 17.06.2014 19,377.00 1579001307 Annapurna Distributo - Latur 17.06.2014 5,571.00 1579001316 Annapurna Distributo - Latur After Workout it must be as follows: *Due Date* *Amount* *Inv No* *Party Name* 17.06.2014 59,245.00 1579001280/1579001281/1579001307/1579001316 Annapurna Distributo - Latur Please help. Regards Pravin Gunjal. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Large Model Question
Hi , It would be better to give a try of importing and working in access or any other databases for calculation and reporting. Thanks Regards Hari Kumar Our strength grows from our weakness. On May 19, 2014 3:28 AM, Dima semant...@gmail.com wrote: Hello! I have a few excel model files of the following sizes - 200 megabytes, 320 megabytes and 650 megabytes. I have 4 sets of data to be calculated by these models and combined in a single file. They can be either recalculated 4 times for each of the data sets - their results stored in a single file and then combined in a report after the final calculation. Or - I am thinking of buying more ram for my excel 64 and open up 4 instances of the aforementioned model files for each of the data set - so that all can be calculated at once. I calculated the total size of the models in memory would be 1600 megabytes - in the last case 6500 megabytes. I have Xeon e5-1650 - not sure if the last setup would work better - please let me know. It would allow to bypass the intervening stage of storing the separate results and combining them afterwards. Will be happy to hear what you think! D -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Consolidate to one working sheet
Thanks for your help. It will be much helpful other than in VBA code. Thanks, Harish On 11 October 2013 17:51, Ravinder ravinderexcelgr...@gmail.com wrote: PFA, if u r looking for this. ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Hari *Sent:* Friday, October 11, 2013 2:23 PM *To:* excel-macros@googlegroups.com *Subject:* Fwd: $$Excel-Macros$$ Consolidate to one working sheet ** ** Please need your help. -- Forwarded message -- From: *Hari* harisha.prabha...@gmail.com Date: 9 October 2013 14:54 Subject: $$Excel-Macros$$ Consolidate to one working sheet To: excel-macros@googlegroups.com Dear Excel gurus, ** ** Please suggest me in how to consolidate these files into one working sheet. Got too many files like this. Manually, opening each file, copying and pasting in one working sheet. ** ** Waiting for your valuable help. ** ** Thanks, Harish -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. ** ** -- Yours, Hari. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Yours, Hari. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum
$$Excel-Macros$$ Index of sheets
Dear excel gurus, Please let me know how to get the index of sheets in a given excel workbook. Thanks, Harish -- Yours, Hari. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
Re: $$Excel-Macros$$ Index of sheets
Thanks for your help. but is there any formulae to get the same answers. Thanks, Harish On 10 January 2013 10:11, The Viper viper@gmail.com wrote: Perhaps! He requires the list of available worksheet names from active workbook Sub SheetIndex() Dim i As Integer For i = 1 To ActiveWorkbook.Sheets.Count ActiveSheet.Range(A i).Value = Sheets(i).Name Range(A i).Select Next i End Sub pfa On Wed, Jan 9, 2013 at 5:59 PM, Paul Schreiner schreiner_p...@att.netwrote: What is it that you're looking for? Are you writing VBA code and want to find out how many sheets are in a workbook? Are you trying to use the Sheets() collection to get something to do with the sheets? The Sheets() collection is an array of sheets. The index of the Sheets() collection is the specific sheet of the Sheets array. If the second sheet of the workbook is currently active, that would be Sheets(2) So, when you say get the index of sheets, do you mean you want to know what is the index number in the Sheets collection for the currently active sheet? Or are you not using VBA at all and need something else entirely? Please elaborate on your requirement. *Paul* - *“Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley *- -- *From:* Hari harisha.prabha...@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Wed, January 9, 2013 6:57:56 AM *Subject:* $$Excel-Macros$$ Index of sheets Dear excel gurus, Please let me know how to get the index of sheets in a given excel workbook. Thanks, Harish -- Yours, Hari. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl
Re: $$Excel-Macros$$ Index of sheets
Thanks for your help. I got the answer for the same through below mail which i was looking for. Thanks, Harish On 9 January 2013 17:59, Paul Schreiner schreiner_p...@att.net wrote: What is it that you're looking for? Are you writing VBA code and want to find out how many sheets are in a workbook? Are you trying to use the Sheets() collection to get something to do with the sheets? The Sheets() collection is an array of sheets. The index of the Sheets() collection is the specific sheet of the Sheets array. If the second sheet of the workbook is currently active, that would be Sheets(2) So, when you say get the index of sheets, do you mean you want to know what is the index number in the Sheets collection for the currently active sheet? Or are you not using VBA at all and need something else entirely? Please elaborate on your requirement. *Paul* - *“Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley *- -- *From:* Hari harisha.prabha...@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Wed, January 9, 2013 6:57:56 AM *Subject:* $$Excel-Macros$$ Index of sheets Dear excel gurus, Please let me know how to get the index of sheets in a given excel workbook. Thanks, Harish -- Yours, Hari. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Yours, Hari. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
Re: $$Excel-Macros$$ Interest formulae
Thanks for your help.. On 8 January 2013 12:56, jmothilal gjmothi...@gmail.com wrote: use ((amount* int/100)/365) * no of days On Tue, Jan 8, 2013 at 11:43 AM, Hari harisha.prabha...@gmail.com wrote: -- Forwarded message -- From: Hari harisha.prabha...@gmail.com Date: 8 January 2013 11:43 Subject: Fwd: Interest formulae To: excel-macros@googlegroups.com -- Forwarded message -- From: Hari harisha.prabha...@gmail.com Date: 8 January 2013 11:42 Subject: Interest formulae To: excel-macros@googlegroups.com Dear excel experts, PFA document of FD made with interest compuation made. Provide me interest formulae in the attached sheet with the mathematical function or any macros. Your help will be guide for us to save time. -- Yours, Hari. -- Yours, Hari. -- Yours, Hari. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- *J.Mothilal : **Universal Computer Systems : # 16, Brindavan Complex :Otteri, Vellore-2* -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Yours, Hari. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
$$Excel-Macros$$ Interest formulae
Dear excel experts, PFA document of FD made with interest compuation made. Provide me interest formulae in the attached sheet with the mathematical function or any macros. Your help will be guide for us to save time. -- Yours, Hari. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. Interesest- FD.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Interest formulae
Dear excel experts, PFA document of FD made with interest compuation made. Provide me interest formulae in the attached sheet with the mathematical function or any macros. Your help will be guide for us to save time. -- Yours, Hari. -- Yours, Hari. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. Interesest- FD.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Fwd: Interest formulae
-- Forwarded message -- From: Hari harisha.prabha...@gmail.com Date: 8 January 2013 11:42 Subject: Interest formulae To: excel-macros@googlegroups.com Dear excel experts, PFA document of FD made with interest compuation made. Provide me interest formulae in the attached sheet with the mathematical function or any macros. Your help will be guide for us to save time. -- Yours, Hari. -- Yours, Hari. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. Interesest- FD.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Interest formulae
-- Forwarded message -- From: Hari harisha.prabha...@gmail.com Date: 8 January 2013 11:43 Subject: Fwd: Interest formulae To: excel-macros@googlegroups.com -- Forwarded message -- From: Hari harisha.prabha...@gmail.com Date: 8 January 2013 11:42 Subject: Interest formulae To: excel-macros@googlegroups.com Dear excel experts, PFA document of FD made with interest compuation made. Provide me interest formulae in the attached sheet with the mathematical function or any macros. Your help will be guide for us to save time. -- Yours, Hari. -- Yours, Hari. -- Yours, Hari. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. Interesest- FD.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ MVP Award....Congratulations Ashish Koul and Dilip Pandey !!
(986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- * * * MARIES* Excel Inspiration http://xcel-inspiration.blogspot.com/ -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- Yours, Hari. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ MVP Award....Congratulations Ashish Koul and Dilip Pandey !!
Congratulations to both of you. Keep smiling, Regards, Harish On 2 July 2012 12:19, Hari harisha.prabha...@gmail.com wrote: Congratulations to both of you. Keep smiling, Regards, Harish On 2 July 2012 11:51, Kuldeep Singh naukrikuld...@gmail.com wrote: Congratulations both of you Regards, Kuldeep Singh Back Office Executive Info Edge India Limited (naukri.com) Phone.: +91-120-4763793, Extn.: 793, 9716615535. naukrikuld...@gmail.com || www.naukri.com *Please* *Consider the environment. Please don't print this e-mail unless you really need to.* On Mon, Jul 2, 2012 at 11:48 AM, Maries talk2mar...@gmail.com wrote: *Congratulations Ashish and Dilip!* On Mon, Jul 2, 2012 at 10:17 AM, Anil Gawli gawlianil8...@gmail.comwrote: congrats to both of you . Regards, Anil G On Mon, Jul 2, 2012 at 11:35 AM, Asa Rossoff a...@lovetour.info wrote: Sorry to hear that. Your work is still valued by many, Don. Asa ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *dguillett1 *Sent:* Sunday, July 01, 2012 10:04 AM *To:* excel-macros *Cc:* Dilip Pandey; ashish koul *Subject:* Re: $$Excel-Macros$$ MVP AwardCongratulations Ashish Koul and Dilip Pandey !! ** ** And, Don Guillett was not re selected. Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com *From:* Ayush Jain jainayus...@gmail.com *Sent:* Sunday, July 01, 2012 11:24 AM *To:* excel-macros excel-macros@googlegroups.com *Cc:* Dilip Pandey dilipan...@gmail.com ; ashish koulkoul.ash...@gmail.com *Subject:* $$Excel-Macros$$ MVP AwardCongratulations Ashish Koul and Dilip Pandey !! Dear members, I am extremely happy to inform you that two members of the group are awarded Microsoft Most Valuable Professional Award. My heartiest congratulations to *Ashish koul* and *Dilip Pandey* and thanks for their big support to this forum. Keep posting ! Best regards, Ayush Jain Group Manager Microsoft MVP -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr
$$Excel-Macros$$ Tally import
Hi, Can someone tell the procedures of importing transactions into tally from MS Excel with details. Thanks in advance. -- Yours, Hari. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Tally import
HI, The following transactions to be imported into tally from excel in the attached file. No ledgers are created in tally. Regards, Harish On 2 June 2012 22:47, in.vaib...@gmail.com wrote: ** Hi, What you want to import, provide with details. -- *From: * Hari harisha.prabha...@gmail.com *Sender: * excel-macros@googlegroups.com *Date: *Sat, 2 Jun 2012 22:35:23 +0530 *To: *excel-macros@googlegroups.com *ReplyTo: * excel-macros@googlegroups.com *Subject: *$$Excel-Macros$$ Tally import Hi, Can someone tell the procedures of importing transactions into tally from MS Excel with details. Thanks in advance. -- Yours, Hari. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- Yours, Hari. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com excelimport.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Excel - Useful Web Links
Hi, Superb links. Thanks, Hari On 14 April 2012 12:44, PRAVESH KUMAR praveshkash...@gmail.com wrote: Hi Varun, a lot of Thanks On Tue, Apr 10, 2012 at 9:13 AM, VARUN CHAWLA varunchawla...@gmail.comwrote: On Sat, Apr 7, 2012 at 3:09 AM, Maries talk2mar...@gmail.com wrote: Dear Friends, I have accumulate the my collection for Excel. Please update, If you anything more. I hope these links are very useful everyone. http://www.andrewsexceltips.net/ http://www.andrewsexceltips.net/ http://www.andypope.info/ http://www.andypope.info/ http://members.aol.com/Machero http://members.aol.com/Machero http://www.appspro.com http://www.appspro.com/ http://www.ashishmathur.com http://www.ashishmathur.com/ http://www.bettersolutions.com/excel.aspx http://www.beyondtechnology.com http://www.beyondtechnology.com/ http://akoul.blogspot.com http://akoul.blogspot.com/ http://exceler.blogspot.com http://exceler.blogspot.com/ http://ashish-msaccess.blogspot.com/ http://exceldailytip.blogspot.com/ http://exceltnt.blogspot.com/ http://liyakatalilal.blogspot.com/ http://quickvba.blogspot.com/ http://learningiseasy.co.uk/Home.aspx peltiertech.com http://ExcelExperts.com http://excelexperts.com/ http://spreadsheetpage.com http://spreadsheetpage.com/ http://clearlyandsimply.com/ http://excelunusual.com/ http://exceluser.com/blog/ http://peltiertech.com/Excel/ChartsHowTo/index.html http://www.computergaga.com/excel/msxl_training.html http://www.contextures.com/ www.cpearson.com http://www.cpearson.comhttp://www.cpearson.com/ http://www.cpearson.com/excel/MainPage.aspx www.dailydoseofexcel.com/ http://www.dailydoseofexcel.com/ http://www.dailydoseofexcel.com/ www.datapigtechnologies.com http://www.datapigtechnologies.comhttp://www.datapigtechnologies.com/ http://www.datapigtechnologies.com/ExcelMain.htm http://www.discussexcel.com http://www.discussexcel.com/ http://www.dzikosoft.com/gmexcel/ http://www.edferrero.comhttp://www.edferrero.com/ www.exceler.blogspot.com www.ExcelExperts.comhttp://www.excelexperts.com/ www.ExcelExpertTraining.com http://www.excelexperttraining.com/ www.excelforum.com www.excelfox.com www.excelpoweruser.blogspot.com www.exceluser.com/ http://www.ExcelExpertTraining.comhttp://www.excelexperttraining.com/ http://www.excelguru.ca http://www.excelguru.ca/ http://www.exceluser.com/ http://www.exceluser.com/ http://www.excel4apps.com/ http://www.excel-exercice.com/ http://www.excelforum.com/ http://www.excelhero.com/ http://www.exceltip.com/index.php http://www.excel-vba.com/ http://www.excelvbamacros.com/ https://www.facebook.com/ExcelLover https://www.facebook.com/l.php?u=http%3A%2F%2Fwww.excelitems.com%2Fh=014d2ref=ts https://www.facebook.com/microsoftexcel https://www.facebook.com/pages/Excel-and-VBA-Codes-Macros/15180389897 http://www.facebook.com/groups/163491717053198/ http://www.facebook.com/groups/214214011997936/ http://www.facebook.com/pages/Access-VBA-Macros-Codes/212032078844161 http://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897 http://www1.finance30.com/ http://www.free-training-tutorial.com/ http://xcell05.free.fr http://xcell05.free.fr/ www.freevbcode.com http://www.functionx.com/excel/ http://www.functionx.com/vbaexcel/index.htm http://www.getexceltraining.com/ https://sites.google.com/site/chilexcel/Home https://people.highline.edu/mgirvin/ExcelIsFun.htm http://www.homeandlearn.co.uk/ME/MicrosoftExcel.html http://www.jiguparmar.com/ http://www.jkp-ads.comhttp://www.jkp-ads.com/ http://dj.joss.free.fr/ http://dj.joss.free.fr/ http://www.jumper.ch http://www.jumper.ch/ http://www.lacher.comhttp://www.lacher.com/ http://www.longhead.com/ http://www.longhead.com/ http://www.lynda.com/ http://msdn.microsoft.com/en-in/office/aa905411.aspx http://technet.microsoft.com/en-us/office/gg605176.aspx http://www.mrexcel.com http://blogs.msdn.com/b/excel/ www.mvps.org/dmcritchie/excel/excel.htm www.mvps.org/links.html http://orlando.mvps.org http://orlando.mvps.org/ http://www.mvps.org/dmcritchie/excel/excel.htmhttp://www.mvps.org/dmcritchie/excel/excel.htm http://www.mvps.org/links.html#Excel http://puremis.net/excel/http://puremis.net/excel/ www.nickhodge.co.uk http://www.nickhodge.co.ukhttp://www.nickhodge.co.uk/ www.oaltd.co.uk http://www.oaltd.co.uk http://www.oaltd.co.uk/ http://blogs.office.com/b/microsoft-excel/ chandoo.org http://chandoo.org/ http://chandoo.org/ www.ozgrid.com http://www.ozgrid.com/ http://home.pacbell.net/beban http://home.pacbell.net/beban www.peltiertech.com/ http://www.peltiertech.com/http://www.peltiertech.com/ akoul.posterous.com http://www.powerutilsnet.com/default.htm www.prodomosua.eu http://www.prodomosua.eu http://www.prodomosua.eu/ http://users.quick-line.ch/ramel/ http://users.quick-line.ch/ramel/ www.r-cor.com http://www.r-cor.com http://www.r-cor.com/ http
Re: $$Excel-Macros$$ Most Helpful Member Jan'12 - Noorain Ansari
Congratulations to our expert guru. On 1 February 2012 22:18, resp...@gmail.com wrote: ** Congrats NOORAIN ANSARI Sent from my BlackBerry® smartphone from Airtel Ghana -- *From: * xlstime xlst...@gmail.com *Sender: * excel-macros@googlegroups.com *Date: *Wed, 1 Feb 2012 22:17:19 +0530 *To: *excel-macros@googlegroups.com *ReplyTo: * excel-macros@googlegroups.com *Cc: *NOORAIN ANSARInoorain.ans...@gmail.com *Subject: *Re: $$Excel-Macros$$ Most Helpful Member Jan'12 - Noorain Ansari Congratulation Brother !! On Wed, Feb 1, 2012 at 10:11 PM, Ayush Jain jainayus...@gmail.com wrote: Hello Everyone, Noorain Ansari has been selected as 'Most Helpful Member' for the month of Jan'12 He has posted 175 posts in Jan'12 and helped many people through his expertise. He has been consistent contributor to this excel forum but has acheived this recognition for first time. *About Noorain Ansari :* [image: noorain.jpg] Noorain is a great poet and keep sharing his thoughts on different topics throgh cool poems. Professionally, he is a Excel aficionado and presently working as senior business analyst in One97 Communication Ltd. He is a MS excel - vba expert and keep sharing his thoughts with this forum. You can follow his blogs for Excel knowledge and cool poems : www.excel-macro.blogspot.com www.noorain-ansari.blogspot.com *Noorain, Many thanks for all your great support to group. Keep it up* *Thanks to Rajan Verma, Sam, Don Guillett, Kris, Bheema, Venkat, Chandru , Priyanka, Lokesh and other folks for helping excel enthusiasts voluntarily !! Keep it up !! ** *Keep posting. Regards Ayush Jain Group Manager Microsoft MVP -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- . -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Yours, Hari. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data
Re: $$Excel-Macros$$ Happy Birth Day
Wish you many many Happy Returns of the Day. Have a wonderful life ahead. Regards, Harish On 2 January 2012 20:25, Maries talk2mar...@gmail.com wrote: Wish you many many Happy Returns of the Day Noorain:) Enjoy :) On Mon, Jan 2, 2012 at 6:52 PM, Rajan_Verma rajanverma1...@gmail.comwrote: Hello Group, Today we have birthday of One of our Excel Champ, He has been recognised Most Helpful member on this group many times. *Noorain *has a sound knowledge of Excel and happy to help other peoples . So after New year we have another party on 2nd January J. Lets Wish Noorain a very Very Happy Birht Day. ** ** *Many Many happy return of the day Noorain.* * * *Keep helping Peoples.* * * *Thanks and Regards* Rajan Verma ** ** -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Yours, Hari. -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ Excel Books or classes
Excel Experts, Can any body suggest me how to learn MS Excel with VBA through referring some books with little bit of basic knowledge about excel. I will be grateful if u guide us to attend classes, if any. Currently, pursuing CA Final located in Bengalooru, karanataka. Have a nice week ahead and time. -- Yours, Hari. -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Happy Friendship Day
Hi guys, Happy friendship day to all my friends. Thanks for solving all my queries. Regards, Hari On 7 August 2011 11:29, Venkat CV venkat1@gmail.com wrote: Dear Friends, * HAPPY FRIENDSHIP DAY To All * Best Regards, Venkat Chennai On Sat, Aug 6, 2011 at 5:30 PM, Chidurala, Shrinivas shrinivas.chidur...@citi.com wrote: HAPPY FRIENDSHIP DAY They love you... but they are not your lover. They care for you, but they are not from your family... They are ready to help share the knowledge in Excel, but they are not in your teacher. They are one and only ... EXCEL GROUP FRIENDS I would thank you from the bottom of my heart all Excel Guru for your Help, Suggestions and knowledge sharing to every one. From your Friend, Shrinivas -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Yours, Hari. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Query
Thanks a lot dear On 28 July 2011 18:32, ashish koul koul.ash...@gmail.com wrote: SUBSTITUTE(F1TEXT(G1,ddmmyyy), ,) On Thu, Jul 28, 2011 at 5:13 PM, Hari harisha.prabha...@gmail.com wrote: dear members, can any one solve my query with help of formula, i am very poor in MS excel. find the attachement, reply at the earliest. Thanks in advance, have a nice day. -- Yours, Hari. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ http://akoul.posterous.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Yours, Hari. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Copy text from Word and paste into Excel
Do the following 1.creTe word app 2.take microsoft word library in the references 3m specify the path of word doc and On 7/22/11, dkelb dkelb1...@gmail.com wrote: I am a newbie to VBA I have a word document that is composed of many pages with text. I want to find the first occurance of Objective and copy the text that follows then paste it into A1. Find the next occurance and past it into A2. Do this until the end of the word file. Then find the first occurance of Date and copy the text that follows then paste it into B1. Find the next occurance and paste it into B2. Do this until the end of the word file. Thanks in advance for some VBA code for Excel that can save me tons of time! -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Hari kumar Our strength grows out of our weaknesses. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ marco to find common value
I want common numbers of both column should shown in column C while clicking a button. I have used the following formula, but it take very long time to process each time I opened the file. Thanks =INDEX($A$2:$A$1642,SMALL(IF(COUNTIF($B$2:$B$1642,$A$2:$A$1642),ROW($A$2:$A$1642)-MIN(ROW($A$2:$A$1642))+1,),ROW(A112))) On Wed, Jul 6, 2011 at 11:21 AM, Vasant vasant...@gmail.com wrote: Pls find the attached This function will give you only the common values in both the columns On Wed, Jul 6, 2011 at 10:49 AM, HARI NAIR hari.shrin...@gmail.com wrote: I want a marco to find common values of column A and B in column C in the attached file. Please Help. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Regards Vasant skype Id: vasantjob vasant...@gmail.com -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ marco to find common value
I want a marco to find common values of column A and B in column C in the attached file. Please Help. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel xyz2.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ and the Microsoft MVP award goes to Ashish Koul :)
Thanks for getting the award. Even though, i am very new to this group, I proudly wishes to keep this spirit high always, Have a nice day with best wishes, Regards, Hari On 1 July 2011 21:25, Ayush jainayus...@gmail.com wrote: Dear Group, I am extremely happy to share a good news with you. One of our dearest group member 'Ashish Koul' is awarded Microsoft MVP award on 1st July for his exceptional MS Excel skills and voluntary contribution. He is well deserving for the award and I am very happy and proud of his recognition. The guy has been top poster in the group from last 7-8 months. Let see who becomes the next MVP from the group. The group has now three active MVPs. Dear Ashish, Many Many congratulations for the award.I am very proud of you to be part of this group. Keep your valuable contribution to the group. I wish your long association with this group. Cheers !! Best Regards, Ayush Jain Group Manager -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Yours, Hari. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ HELP NEEDED FOR FORMULA
I WANT YOUR VALUE HELP TO PUT A FORMULA IN THE ATTACHED SHEET. PLEASE HELP THANKS IN ADVANCE.. HARI -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel GIRISH.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Beginer to Excel-VBA
Dear Friends, Can any one please help me in *how to learn Excel-VBA* through some tutorial materials as i am CA Final student. - Yours, Hari. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ Delete rows including blank row except few members
HLC Dear Krishna Mummina, I saw yr solution to the question of Niel Johnson. As i am a primary student in Excel I don't know how to create Excel Macro. I would like to know how to apply these commands in excel and how to use it. Shall I except yr kind help. Kindly enlighten me using or applying the following commands step by step in excel. delete the entire row when specification meets Sub processdata() Dim i As Long, lr As Long lr = ActiveSheet.UsedRange.Rows.Count Application.ScreenUpdating = False For i = 1 To lr If Range(A i).Value = Then Range(A i).EntireRow.Delete If UCase(Range(A i).Value) = C Then Range(A i).EntireRow.Delete If UCase(Range(A i).Value) = D Then Range(A i).EntireRow.Delete If UCase(Range(A i).Value) = E Then Range(A i).EntireRow.Delete If UCase(Range(A i).Value) = F Then Range(A i).EntireRow.Delete Next Application.ScreenUpdating = True End Sub Hari Lal -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
Re: $$Excel-Macros$$ PLEASE HELP WITH ATTACHED DATA
Dear Dilipji, Thank you very much, It is working, but one problem It showing error when nothing is entered, I have tried to insert isserror formula, but not able insert it. if possible please revise my file. again thank you very much for your kind help On Sat, Jul 24, 2010 at 9:24 AM, Dilip Pandey dilipan...@gmail.com wrote: Thanks Rahul, No doubt, concatenate and will do the task but for that we need to have a column on both d locations n we also need to check if this is feasible. But anyways both the ways are ok n there are other ways as well :) thx, DILIPandey On 7/24/10, Rahul Gandhi. myname.ra...@gmail.com wrote: I Think in particular this scenerio we have one more function of Concatenate or . that also helps us to do the same, at the other hand this formula is also very suitable for so many conditions.. Thanks again sir. On Jul 23, 6:33 pm, Dilip Pandey dilipan...@gmail.com wrote: Hi Hari, I have achieved the desired result using array functionality in Vlookup function. See the attached file and let me know if this helps. -- Thanks Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India On Fri, Jul 23, 2010 at 4:38 PM, HARI NAIR hari.shrin...@gmail.com wrote: I want to fill the basic rate column automatically from the rate column(Please refer the attached file, which considers all three columns factors, like, PO NO, Thickness. Width, Quality. Not a single column factor. Please Help, Any how, thanks to prajapatiji for sending me the solution which I earlier sent, in which only single colunm factor is looking (i.e. Quality) Regards, Hari -- -- 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 DATA - Vlookup with multiple criteria - by DILIpandey.xls 91KViewDownload -- -- 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 -- Sent from my mobile device Thanks Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India -- -- 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
$$Excel-Macros$$ Help with Date
Dear Friends, I want rate automatically comes from rate sheet in Data sheet when I enter the remaining details in the attached file, please help, Thanks in advance Regards, Hari -- -- 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 PR.xls Description: MS-Excel spreadsheet
Fwd: $$Excel-Macros$$ Auto Calculate Number to Percent
HLC -- Forwarded message -- From: MNM mnaf...@gmail.com Date: Fri, Jul 23, 2010 at 7:12 AM Subject: $$Excel-Macros$$ Auto Calculate Number to Percent To: MS EXCEL AND VBA MACROS excel-macros@googlegroups.com Hi, I am trying to figure out if there is a way to auto calculate number entered into a column to total percent. Example Column A contains 'Date' Column B contains 'User' Column C contains 'Hours worked' Based on the value in column B User 'XYZ' I should be able to convert hours worked into total percent Date | User | Hours Worked 7/16 | ABC | 8 This should self calculate and return on save 7/16 | ABC | 100% Example 2 Date | User | Hours Worked 7/16 | ABC | 8 7/16 | ABC | 8 7/16 | XYZ | 12 7/17 | ABC | 8 This should self calculate and return on save 7/16 | ABC | 33.3% 7/16 | ABC | 33.3% 7/16 | XYZ | 100% 7/17 | ABC | 33.3% At the end the total should equal 100% by User -- -- 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$$ CENTRAL EXCISE REGISTERS
I am looking for Central Excise Registers, like RG-23A Part-!, II, RG-1 Registers in excel .If anybody have please post 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 Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 Macros Free PDF
http://groups.google.com/group/excel-macros/files On 2/11/10, Venkatesan c venkat1@gmail.com wrote: Can I Have Excel Macros PDF Complete Guide -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,700 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 -- Hari kumar Our strength grows out of our weaknesses. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,700 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 All, As a New Year approaching with new beginnings!!! May your dreams and wishes will come true and may you have a bright days in future!!! Happy New Year! Shubho Nabo Barsho Xin Nian Kuai Le Prosit Neujahr Nutan Varshbhinandan Naye Varsha Ki Shubhkamanyen Hosa Varushadha Shubhashayagalu Naveen Varshachy Shubhechcha Puthuvatsara Aashamsakal Nave saal di Mubarak Nayou Saal Mubbarak Hoje Inniya Puthaandu Nalvazhthukkal Noothana samvatsara Shubhakankshalu Naya Saal Mubbarak Ho Think not on peace in your world, for it means that you believe there is none. Think not on love for the world, for it indicates you believe the world must lack it. Think not on joy for the world, for then joy appears to be missing. Think upon peace within you, upon love within you and the joyousness within you that brings into being the light for others. For nothing external of your mind will change externally! Wait not for peace, love and joy, for in gentle action within your mind, to change your perception of the world, alone resides the ability to change it! Because you are mind, let your belief and knowing of God's Peace, Love and Joy, be a living part of your consciousness. Welcome Him in strength and kindness to occupy your will to bring these things to the world” -- Hari kumar Our strength grows out of our weaknesses. -- -- Some important links for excel users: 1. Follow us in TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,500 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 2007: How can I use VBA to set series border line width?
On 10/5/09, Paul Schreiner schreiner_p...@att.net wrote: Have you tried recording a macro and then doing these steps? P Hi Sonny, Go to tools macros recod new macro you can right click on a Data Series. then select Format Data point. The on the right, select Border Styles. Within this, there's a way to set the width: say to 0.25 pt. regards hari kumar From: Sonny sonnyt...@gmail.com To: MS EXCEL AND VBA MACROS excel-macros@googlegroups.com Sent: Monday, October 5, 2009 8:55:18 AM Subject: $$Excel-Macros$$ Excel 2007: How can I use VBA to set series border line width? After making a chart in Excel 2007, you can right click on a Data Series. then select Format Data point. The on the right, select Border Styles. Within this, there's a way to set the width: say to 0.25 pt. That's the GUI way of doing it, how can I change this width using VBA? -- Hari kumar Our strength grows out of our weaknesses. --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: macro book!!urgent help
Hi Ankur, http://groups.google.com/group/excel-macros/files regards Hari kumar On Wed, Jun 24, 2009 at 10:09 PM, ankur ankurpande...@gmail.com wrote: hello excel gurus thanks for helps to my earlier queries i can work properly with excel sheets,but no familiar with macros. i can record macros,but dont understand the coding concept i have no programming background, so its very hard me to understand any macro in excel In today's era knowing excel with macros is essential i tried to find a simple books on writing macros in excel ,but all in vain so i request you all to please provide me a ebook on this topic which can be understandable by a non programmer like me i want to learn how to write macros in excel, i m waiting for positive reply. thanks in advance Have A Nice Time Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ -- Hari kumar Our strength grows out of our weaknesses. --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Best Excel Tip Award of Week # 24 goes to HARMEET SINGH
Hi I would undoubtedly say East or West-- Harmeet Singh is one of the kings of this group. regards Hari kumar On Wed, Jun 17, 2009 at 1:10 PM, Harmeet Singh harmeet.hew...@gmail.comwrote: Hi Ayush, Thanks a lot This is the charm of Excel Group that is attracting good talent. Hope to help you all in future too with my knowledge. Watch out for more [?] Regards, Harmeet On Wed, Jun 17, 2009 at 8:18 PM, Ayush jainayus...@gmail.com wrote: Hello Everyone, I am happy to inform you that the award of best excel Tip of Week # 24 goes to Harmeet Singh. The tip submitted by Harmeet is as follows : Subject : Hidden text in Formula Tip : =2018+1056-4*120+N(My Salary + Bonus - 4 weekly loan repayments) BY using *N() *formula You can enter hidden text in your formula. It was very different, useful and unique tip among all the tips by the participants. I encourage you all to submit such great tips which will help all members in big way and let you win the prize. CONGRATULATIONS HARMEET !! You are now nominated for monthly award your name is published on home page of this group. CHEERS !!! The competition of week # 25 is already started you can submit your tip in the thread mentioned below http://groups.google.com/group/excel-macros/browse_thread/thread/8f60d8d55837f5c9# Please participate and win wonderful prizes. KEEP POSTING Thanks and best regards, Ayush Jain -- Thanks Regards, Harmeet Singh -- Hari kumar Our strength grows out of our weaknesses. --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~--- inline: 332.gif
$$Excel-Macros$$ Re: excel macros
Hi Mayank, please look into the site. http://www.vbamacros.blogspot.com regards Hari Kumar On Mon, Jun 1, 2009 at 7:16 AM, mayank khare mmayank2...@gmail.com wrote: plz replyyy On Mon, Jun 1, 2009 at 7:13 AM, mayank khare mmayank2...@gmail.comwrote: Hai, I want to learn indepth excel macros. Plz tell the resource to learn this. I do not know any language ie Visual Basic ,which i know is required to write a macro. Plz guide me. -- Warm Regards Mayank Khare -- Warm Regards Mayank Khare -- Hari kumar Our strength grows out of our weaknesses. --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: color code excel cell if a cell has a formula
Hi All, This may help. Chang the code as you want. Sub ChangeformulaColor() If Application.IsText(ActiveCell) = True Then MsgBox (Text) Else If ActiveCell = Then MsgBox (Blank) Else End If If ActiveCell.HasFormula = True Then ActiveCell.Select With Selection.Font .Name = Arial .FontStyle = Regular .Size = 10 .Strikethrough = False .Superscript = False .Subscript = False .OutlineFont = False .Shadow = False .Underline = xlUnderlineStyleNone .ColorIndex = 46 End With With Selection.Interior .ColorIndex = 36 .Pattern = xlSolid .PatternColorIndex = xlAutomatic End With Else End If If IsDate(ActiveCell.Value) = True Then MsgBox (date) Else End If End If End Sub Regards Hari Kumar _ From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Dave Bonallack Sent: Monday, April 13, 2009 9:55 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: color code excel cell if a cell has a formula Hi, A quick way to reveal which cells have formulas: Ctrl+` That's Ctrl plus the key above the Tab key. Regards - Dave. Date: Mon, 13 Apr 2009 11:15:32 -0700 Subject: $$Excel-Macros$$ color code excel cell if a cell has a formula From: ned...@yahoo.com To: excel-macros@googlegroups.com could anyone tell me how to color code an excel cell if a cell has a formula. I have a long worksheet with lot of data and it it hard to tell which data is a formula and which is just value entered by users. Thanks /html --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: How to pull the charts from the excel file to the PPT?
Hi Raghu, Select the charts and run the below macro. Please let me know if there are any problems. Sub CopyChartsIntoPowerPoint() ''' COPY SELECTED EXCEL CHARTS INTO POWERPOINT ' Set a VBE reference to Microsoft PowerPoint Object Library Dim pptApp As PowerPoint.Application Dim iShapeIx As Integer, iShapeCt As Integer Dim myShape As Shape, myChart As ChartObject Dim bCopied As Boolean Set pptApp = GetObject(, PowerPoint.Application) If ActiveChart Is Nothing Then ''' SELECTION IS NOT A SINGLE CHART On Error Resume Next iShapeCt = Selection.ShapeRange.Count If Err Then MsgBox Select charts and try again, vbCritical, Nothing Selected Exit Sub End If On Error GoTo 0 For Each myShape In Selection.ShapeRange ''' IS SHAPE A CHART? On Error Resume Next Set myChart = ActiveSheet.ChartObjects(myShape.Name) If Not Err Then bCopied = CopyChartToPowerPoint(pptApp, myChart) End If On Error GoTo 0 Next Else ''' CHART ELEMENT OR SINGLE CHART IS SELECTED Set myChart = ActiveChart.Parent bCopied = CopyChartToPowerPoint(pptApp, myChart) End If Dim myPptShape As PowerPoint.Shape Dim myScale As Single Dim iShapesCt As Integer ''' BAIL OUT IF NO PICTURES ON SLIDE On Error Resume Next iShapesCt = pptApp.ActiveWindow.Selection.SlideRange.Shapes.Count If Err Then MsgBox There are no shapes on the active slide, vbCritical, No Shapes Exit Sub End If On Error GoTo 0 ''' ASK USER FOR SCALING FACTOR myScale = InputBox(Prompt:=Enter a scaling factor for the shapes (percent), _ Title:=Enter Scaling Percentage) / 100 ''' LOOP THROUGH SHAPES AND RESCALE PICTURES For Each myPptShape In pptApp.ActiveWindow.Selection.SlideRange.Shapes If myPptShape.Name Like Picture* Then With myPptShape .ScaleWidth myScale, msoTrue, msoScaleFromMiddle .ScaleHeight myScale, msoTrue, msoScaleFromMiddle End With End If Next Set myChart = Nothing Set myShape = Nothing Set myPptShape = Nothing Set pptApp = Nothing End Sub Sub CopyChartsIntoPowerPoint() ''' COPY SELECTED EXCEL CHARTS INTO POWERPOINT ' Set a VBE reference to Microsoft PowerPoint Object Library Dim pptApp As PowerPoint.Application Dim iShapeIx As Integer, iShapeCt As Integer Dim myShape As Shape, myChart As ChartObject Dim bCopied As Boolean Set pptApp = GetObject(, PowerPoint.Application) If ActiveChart Is Nothing Then ''' SELECTION IS NOT A SINGLE CHART On Error Resume Next iShapeCt = Selection.ShapeRange.Count If Err Then MsgBox Select charts and try again, vbCritical, Nothing Selected Exit Sub End If On Error GoTo 0 For Each myShape In Selection.ShapeRange ''' IS SHAPE A CHART? On Error Resume Next Set myChart = ActiveSheet.ChartObjects(myShape.Name) If Not Err Then bCopied = CopyChartToPowerPoint(pptApp, myChart) End If On Error GoTo 0 Next Else ''' CHART ELEMENT OR SINGLE CHART IS SELECTED Set myChart = ActiveChart.Parent bCopied = CopyChartToPowerPoint(pptApp, myChart) End If Dim myPptShape As PowerPoint.Shape Dim myScale As Single Dim iShapesCt As Integer ''' BAIL OUT IF NO PICTURES ON SLIDE On Error Resume Next iShapesCt = pptApp.ActiveWindow.Selection.SlideRange.Shapes.Count If Err Then MsgBox There are no shapes on the active slide, vbCritical, No Shapes Exit Sub End If On Error GoTo 0 ''' ASK USER FOR SCALING FACTOR myScale = InputBox(Prompt:=Enter a scaling factor for the shapes (percent), _ Title:=Enter Scaling Percentage) / 100 ''' LOOP THROUGH SHAPES AND RESCALE PICTURES For Each myPptShape In pptApp.ActiveWindow.Selection.SlideRange.Shapes If myPptShape.Name Like Picture* Then With myPptShape .ScaleWidth myScale, msoTrue, msoScaleFromMiddle .ScaleHeight myScale, msoTrue, msoScaleFromMiddle End With End If Next Set myChart = Nothing Set myShape = Nothing Set myPptShape = Nothing Set pptApp = Nothing End Sub On Thu, Apr 9, 2009 at 2:34 AM, jamadagnira...@gmail.com wrote: Hi All, Please find the attachment. My requirements is – Can anyone tell me how to pull the charts from the excel file to the PPT? I want two charts to be placed in ONE PPT. For example – Chart 1 Chart 2 should go to PPT Slide 1 and Chart 3 Chart 4 should go PPT Slide 2 and likewise. I want it be placed centrally. I have to update lots of Charts to update in the PPT from excel file every month and its very annoying to copy and paste one by one and consumes lots of time. PLEASE HELP. Regards, Raghu J. -- Hari kumar --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http
$$Excel-Macros$$ Re: Hi I would require help on vlookup with search option
Hi Aplesh / Kgrabbs, Thank you very much. Regards Hari Kumar -Original Message- From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of kgrabbs Sent: Friday, April 03, 2009 6:32 PM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ Re: Hi I would require help on vlookup with search option I had not known you can add wild cards to vlookups. That is really cool. One note of caution is that I got false positives when entering the name George. The method stated above will display results upon the first match, which in this case was George, Bush and not George as in Jefferson. This was also true when entering B, J, H, or K which are all partial matches. So I built upon the vlookup with wild cards and added the ISERROR function combined with an IF statement. This function will use the exact match first before using the wild card vlookup. [Cell D5] =IF(ISERROR(VLOOKUP(D2,data!$B:$D,3,0)),VLOOKUP(*D2*,data!$B:$D, 3,0),VLOOKUP(D2,data!$B:$D,3,0)) Cheers, kgrabbs On Apr 3, 9:33 am, Alpesh Juvarewala ajuvarew...@gmail.com wrote: Hi, Pls find the attached solution. The trick is to use wild card character. The limitation is that the text should not be repeated in any other cell or else the result may not be as per expectation. 2009/4/3 hari prekkeh...@gmail.com: Hi All, I would require the output “city name from sheet “Data” on input of First Name in the sheet”require information” I tried vlookup which matches for exact search. Can anyone please suggest how to use vlookup after using search or finding a string? Enclosed please find the file. Regards Hari Kumar address(1).xls 29KViewDownload- Hide quoted text - - Show quoted text - --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Hi I would require help on vlookup with search option
Hi All, I would require the output city name from sheet Data on input of First Name in the sheetrequire information I tried vlookup which matches for exact search. Can anyone please suggest how to use vlookup after using search or finding a string? Enclosed please find the file. Regards Hari Kumar --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~--- address.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Re: How to break the vba project password
Hi Harmeet, Thank you very much. Regards Hari Kumar _ From: Harmeet Singh [mailto:harmeet.hew...@gmail.com] Sent: Wednesday, March 18, 2009 10:10 PM To: excel-macros@googlegroups.com Cc: prekkeh...@gmail.com Subject: Re: $$Excel-Macros$$ Re: How to break the vba project password Hi Hari, It is unlocked. Password for is 1. On Fri, Mar 20, 2009 at 10:19 AM, hari prekkeh...@gmail.com wrote: Hi Harmeet, Enclosed please find the file. Regards Hari Kumar _ From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Harmeet Singh Sent: Wednesday, March 18, 2009 7:19 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: How to break the vba project password Where is the file. On Thu, Mar 19, 2009 at 1:20 PM, hari prekkeh...@gmail.com wrote: Hi All, Can anyone help me how to break a vba protect password. Regards Hari kumar -- Thanks Regards, Harmeet Singh -- Thanks Regards, Harmeet Singh --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---
$$Excel-Macros$$ How to break the vba project password
Hi All, Can anyone help me how to break a vba protect password. Regards Hari kumar --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: charts to powerpoint
Hi Alok, Thank you. Regards Hari kumar _ From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Alokeshwar Tiwary Sent: Tuesday, March 10, 2009 6:35 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: charts to powerpoint Dear Hari, Attached zip file contains tow example files for your problem. Unzip both files in same folder and then open Power Point file and run macro xlchartpastespecial macro. The macro will copy all charts from excel file to power point. You may record a macro to change chart position in the slide. Or you can modify below code to change the position of the chart: ActiveWindow.Selection.SlideRange.Shapes(Picture 1).Select With ActiveWindow.Selection.ShapeRange .IncrementLeft 308.25 .IncrementTop 180.75 End With _ There are known knowns. These are things we know that we know. There are known unknowns. That is to say, there are things that we know we don't know. But there are also unknown unknowns. There are things we don't know we don't know. _ From: hari prekkeh...@gmail.com To: excel-macros@googlegroups.com Sent: Wednesday, 11 March, 2009 11:29:52 AM Subject: $$Excel-Macros$$ charts to powerpoint Hi All, I have a problem of inserting 6 charts from a excel sheet to slide in power point. The effort is doing for almost 58-60 slides in a similar fashion. I got the code for getting the charts into a power point slide. Can anyone advise me with formatting the positioning of the charts in power point thru vba code excel. Regards Hari kumar _ Add more friends to your messenger and enjoy! Invite http://in.rd.yahoo.com/tagline_messenger_6/*http:/messenger.yahoo.com/invit e/ them now. --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Reminder workbook
Hi Santosh, it's not possible under my view. however you can do this create reminders based on dates in a excel workbook. there is an excel workbook with dates to follow up various assignements. when i open outlook...the macro should should open the excel file run through the dates and add reminders for that particular assignment example excel workbook will contain type descirption complete_by client insurance card 15feb08 Function AddOutLookTask() Dim appOutLook As Outlook.Application Dim taskOutLook As Outlook.TaskItem Set appOutLook = CreateObject(Outlook.Application) Set taskOutLook = appOutLook.CreateItem(olTaskItem) With taskOutLook .Subject = This is the subject of my task .Body = This is the body of my task. .ReminderSet = True .ReminderTime = DateAdd(n, 2, Now) ' Set to remind us 2 ' minutes from now. .DueDate = DateAdd(n, 5, Now) ' Set the due date to ' 5 minutes from now. .ReminderPlaySound = True 'add the path to a .wav file on your computer. .ReminderSoundFile = C:\Win95\media\ding.wav .Save End With End Function On Sun, Mar 8, 2009 at 5:42 AM, santosh subudhi santoshkumar.subu...@gmail.com wrote: Hello All, Please help me with below mail it is very urgent. Regards Santosh On 3/1/09, santosh subudhi santoshkumar.subu...@gmail.com wrote: Hi All, I want to put some reminders in my excel sheet which we open regularly. Suppose a pop up message box appear on a particular date stating Hello today is the birthday of your team memeber or need to send a mail to some one. Regards Santosh -- Hari kumar --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: By Macro-Draw charts from Excel to ppt
http://www.computing.net/answers/office/paste-excel-graphs-to-powerpoint/7040.html On Tue, Mar 3, 2009 at 7:11 PM, Nassa nassim.czdas...@gmail.com wrote: Hi all, I have a table on Excel like below table, and I want to write a macro to draw charts and graphs in power point. I don't know how to write such a macro One of the graphs is depend on Dname per week, For instance, it draws chart from Feb.09.09 to Feb.15.09 we have 15 Jack, 10 Alice, and 20 Dave and draw bellow chart in power point… NameT.Nomber DName DQuantity Date A001 Jack 6 Feb. 09.09 B002 Alice 10 Feb. 13.09 C004 Jack 9 Feb. 10.09 D002,001 Dave 20 Feb. 12.09 Thanks all, -- Hari kumar --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: how to attach the file while replying.
Hi Vinu, When you are replying there will be an option attach a file, select your attachment. regards hari kumar On Tue, Feb 17, 2009 at 10:43 PM, vinu vinu1sm...@gmail.com wrote: Hello Group members, Could you pls let me know how to attach the file while replying to any of the queries. Thanks -- Hari kumar --~--~-~--~~~---~--~~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com If you find any spam message in the group, please send an email to Ayush @ jainayus...@gmail.com -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: urgent help needed
Hi Pavithrak, Not sre what markers are required. i had updated three radio buttons but not sure of the code which you require the below link has the option of adding the code. *http://www.functionx.com/excel2003/articles/radiobuttons.htm* regards Hari kumar On Wed, Feb 18, 2009 at 8:56 AM, pavithra murthy pavithrak2...@gmail.comwrote: hi excelers ,hi nishant i want to add the radio buttons dynamically where it looks for a DNA marker and like suppose Suppos I want a radio button to appear incells e13 ,e16 and e18 i have given 3 markers I HAVE to loop thro .bcoz i dont know how many more radio buttons i need plz c -- Hari kumar --~--~-~--~~~---~--~~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com If you find any spam message in the group, please send an email to Ayush @ jainayus...@gmail.com -~--~~~~--~~--~--~--- Book1.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Re: Counting duplicates once
Hi Stuart. this may help you. Sub DuplicateRed() 'color cells in red for duplicates in selected range Application.ScreenUpdating = False Rng = Selection.Rows.Count For i = Rng To 1 Step -1 myCheck = ActiveCell ActiveCell.Offset(1, 0).Select For j = 1 To i If ActiveCell = myCheck Then Selection.Font.Bold = True Selection.Font.ColorIndex = 3 End If ActiveCell.Offset(1, 0).Select Next j ActiveCell.Offset(-i, 0).Select Next i Application.ScreenUpdating = True End Sub On Wed, Feb 11, 2009 at 2:44 AM, stuartjohnw...@googlemail.com stuartjohnw...@googlemail.com wrote: Hope you can help. In column B2:B265 I have a list of names, each name appears about 4 time each. In column H2:H265 there is a list containing either PC, Laptop or CAD corresponding to what type of computer each individual in column A is using. I'm looking for a formula or series of formulas that will tell me how many PC's, laptops's and CAD's are being used but only counting one per name once (hope that makes sense). -- Hari kumar --~--~-~--~~~---~--~~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com If you find any spam message in the group, please send an email to Ayush @ jainayus...@gmail.com -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Help me to add time to a date and time
put now() and in other cell input the number of hours in the same format and then add the two cells. On Fri, Jan 30, 2009 at 8:38 AM, Muthu psgmu...@gmail.com wrote: I will explain my problem with an example. 30/01/2009 13:30 is the time.I want to add 36 hrs to it. But I should add it only during the working hours.(8:30 hours per hour a day(exclude week ends and holidays)). Assume working time to be from 08:00 to 16:30 So the time after 36hrs added would be 05/02/2009 16:00. I can add only the date through workday function,which also excludes holidays and weekends.But I am not able to add the exact time. Can YOU help me to get it done through macros?? Thanks in Advance -- Hari kumar --~--~-~--~~~---~--~~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com If you find any spam message in the group, please send an email to Ayush @ jainayus...@gmail.com -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Help me !!!
Select edit insert fill series ( step 1 ) option On Sun, Feb 1, 2009 at 5:21 AM, yorkeyite yorkeyi...@gmail.com wrote: Ctrl +D try this site http://www.asap-utilities.com/excel-tips-shortcuts.php Y On Feb 1, 4:26 pm, Ajay Kumar ajay.trivand...@gmail.com wrote: The fill handle is very helpful for filling cells with various values. However, I much prefer to use the keyboard in preference to the mouse. Is it possible to utilize the fill handle in some way only by using the keyboard? aJaY :) (R)™ -- Hari kumar --~--~-~--~~~---~--~~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com If you find any spam message in the group, please send an email to Ayush @ jainayus...@gmail.com -~--~~~~--~~--~--~---