Re: $$Excel-Macros$$ EXCEL ADD-IN for reconciling two Data Tables
Thanks Rajan... Its great... On Sat, Sep 15, 2012 at 10:47 AM, Ashish Bhalara wrote: > Its very nice Addon, excellent job. > > > On Fri, Sep 14, 2012 at 7:35 PM, Rajan_Verma wrote: > >> *Its Wow **J*** >> >> * * >> >> * * >> >> *Regards* >> >> *Rajan verma* >> >> *+91 7838100659 [IM-Gtalk]* >> >> * * >> >> *From:* excel-macros@googlegroups.com [mailto: >> excel-macros@googlegroups.com] *On Behalf Of *Aju Chacko >> *Sent:* 13 September 2012 11:59 >> *To:* excel-macros@googlegroups.com >> *Subject:* $$Excel-Macros$$ EXCEL ADD-IN for reconciling two Data Tables* >> *** >> >> ** ** >> >> Dear Friends, >> Please the attached Excel add-in Reconciliation >> Tool made by me.This Add-in can be used to reconcile two numerical fields >> Based on a common field. The data which has to be reconciled can be belong >> to *two different workbook or worksheet*. From the Combo Box choose >> First worksheet name, Common field which is available on both sheets,Then >> select numerical field on first sheet which has to reconciled . Similarly >> choose the details for second sheet also, Choose output sheet-(If you want >> a new workbook choose-“New Book” from the options of Output sheet). Now >> select the Operation to be done on numerical filed *[+,-,*, /, >> Comparison] *(Subtraction means the subtracting the *second* numerical >> field from *first*) and so on. If you want reconcile Debit & Credit >> choose operation as addition. A simple example is shown below.Please try >> and give ur valuable feedback,Because this is my first venture.Any doubt >> please reply.A simple example to demonstrate it's working is given below. >> *First Sheet* *Second Sheet* >> *Output Sheet* >>[image: Inline image 2] [image: Inline image 4] >> [image: >> Inline image 3] >> >> *How to Install* :Please save (Reconciliation Tool.Xlam) into any >> folder u like. This ass-in can be installed in excel *either by Double >> clicking on the icon OR by choosing (OFFICE BUTTON->Excel >> options->Add-Ins->Go-> Browse) and then choosing the Add-in* .Once >> installed an icon will be appearing in Add-in Menu. >> >> >> >> >> >> >> >> >> -- >> Join official facebook page of this forum @ >> https://www.facebook.com/discussexcel >> >> FORUM RULES (1120+ 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. >> >> 6) Jobs posting is not allowed. >> >> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. >> >> NOTE : Don't ever post personal or 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. >> >> >> >> -- >> Join official facebook page of this forum @ >> https://www.facebook.com/discussexcel >> >> FORUM RULES (1120+ 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. >> >> 6) Jobs posting is not allowed. >> >> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. >> >> NOTE : Don't ever post personal or 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. >> >> >> > > > > -- > Thanks & regards. > > Ashish Bhalara > 9624111822 > P*Please do not print this email unless it is absolutely necessary. > Spread environmental üawareness.♣♣♣* > > > -- > Join official facebook page of this forum @
$$Excel-Macros$$
-- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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.
$$Excel-Macros$$ Re: Highlight Worked Cells only if the Employee has worked in both areas
Hello Prince Dubey, Your solution works. But as I mentioned in my original post the data will be in different areas of the sheet Not in A1:AK117 always...which is where your code will work. Can you please change your code so that it runs on any selected range only. Thanks for your time and help. Rashid On Saturday, September 15, 2012 8:03:53 PM UTC+4, Prince Dubey wrote: > Hi Rashid, > > Please see the attachment, Hope this will help you. > > Note : For testing the solution first set any other color for the cell > where the your specified criteria matched and then press the button > Highlight. > > regards > prince > > On Saturday, 15 September 2012 17:22:57 UTC+5:30, prkhan56 wrote: >> >> Hello Experts, >> I am using Excel 2010 and have the following problem. >> If an employee no. is duplicate and he has worked in both Work Areas >> viz EC and RTG then I wish to highlight only those Worked Cells with Yellow. >> >> I have done it manually to demonstrate my requirement in yellow. >> >> As the data shown in the attached file is part of a big work area, I >> would like to RUN the macro only on the Selected Range after I have >> selected that Range. >> >> Thanks in advance >> Rashid Khan >> > -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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.
Re: $$Excel-Macros$$ Re: Excel Formula challenge
It workz for the given case but if more txt is der den formula wil run for milez :p I'm figuring formula dat wl work for all cases. Rgds -Original Message- From: "Rajan_Verma" Sender: excel-macros@googlegroups.com Date: Sat, 15 Sep 2012 22:38:16 To: Reply-To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Re: Excel Formula challenge Nicely done Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Vabz Sent: 15 September 2012 10:04 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: Excel Formula challenge Hi PFA Cheerz.. Rgds//Vabs On Wednesday, August 8, 2012 9:33:25 PM UTC+5:30, Rajan_Verma wrote: Hi group, Hope you will post an excellent solution here : Let suppose you have a string like below : A|A|A|B|B|C|A|B|C|D As you can see the characters are being repeat in this string output should be : A|B|C|D I don't think helper column is required J You can comment here also http://excelpoweruser.wordpress.com/2012/08/08/excel-formula-challenge/ Regards Rajan verma +91 7838100659 [IM-Gtalk] -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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.
RE: $$Excel-Macros$$ Re: Excel Formula challenge
Nicely done Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Vabz Sent: 15 September 2012 10:04 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: Excel Formula challenge Hi PFA Cheerz.. Rgds//Vabs On Wednesday, August 8, 2012 9:33:25 PM UTC+5:30, Rajan_Verma wrote: Hi group, Hope you will post an excellent solution here : Let suppose you have a string like below : A|A|A|B|B|C|A|B|C|D As you can see the characters are being repeat in this string output should be : A|B|C|D I don't think helper column is required J You can comment here also http://excelpoweruser.wordpress.com/2012/08/08/excel-formula-challenge/ Regards Rajan verma +91 7838100659 [IM-Gtalk] -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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.
$$Excel-Macros$$ Re: Excel Formula challenge
Hi PFA Cheerz.. Rgds//Vabs On Wednesday, August 8, 2012 9:33:25 PM UTC+5:30, Rajan_Verma wrote: > * * > > *Hi group,* > > * * > > *Hope you will post an excellent solution here :* > > *Let suppose you have a string like below :* > > *A|A|A|B|B|C|A|B|C|D* > > *As you can see the characters are being repeat in this string * > > *output should be : A|B|C|D* > > *I don’t think helper column is required **J*** > > * * > > * * > > *You can comment here also* > > *http://excelpoweruser.wordpress.com/2012/08/08/excel-formula-challenge/* > > * * > > * * > > *Regards* > > *Rajan verma* > > *+91 7838100659 [IM-Gtalk]* > > > -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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. ABCD.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Re: Highlight Worked Cells only if the Employee has worked in both areas
Hi Rashid, Please see the attachment, Hope this will help you. Note : For testing the solution first set any other color for the cell where the your specified criteria matched and then press the button Highlight. regards prince On Saturday, 15 September 2012 17:22:57 UTC+5:30, prkhan56 wrote: > > Hello Experts, > I am using Excel 2010 and have the following problem. > If an employee no. is duplicate and he has worked in both Work Areas > viz EC and RTG then I wish to highlight only those Worked Cells with Yellow. > > I have done it manually to demonstrate my requirement in yellow. > > As the data shown in the attached file is part of a big work area, I would > like to RUN the macro only on the Selected Range after I have selected that > Range. > > Thanks in advance > Rashid Khan > -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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. Group Highlight Problem.xlsm Description: application/vnd.ms-excel.sheet.macroenabled.12
Re: $$Excel-Macros$$ Re: WANT TO GET BOX MARGIN IN EVERY SHEET
Hi Go to page setup (its under print title) then.. Select Header / Footer, Then Select custom footer.. There ther is option for inserting Image.. Cheerz.. Rgds//Vabz On Saturday, September 15, 2012 9:03:48 PM UTC+5:30, sandeep chhajer wrote: > Dear sir, > > How to insert a line in footer. > > > > *Thank you > Regards > > > Sandeep Kumar Chhajer.* > > * * > > > > > > *From:* excel-...@googlegroups.com [mailto: > excel-...@googlegroups.com ] *On Behalf Of *Rajan_Verma > *Sent:* 15 September 2012 20:31 > *To:* excel-...@googlegroups.com > *Subject:* RE: $$Excel-Macros$$ Re: WANT TO GET BOX MARGIN IN EVERY SHEET > > > > *Absolutely* > > * * > > * * > > *Regards* > > *Rajan verma* > > *+91 7838100659 [IM-Gtalk]* > > * * > > *From:* excel-...@googlegroups.com [mailto: > excel-...@googlegroups.com ] *On Behalf Of *Vabz > *Sent:* 15 September 2012 8:27 > *To:* excel-...@googlegroups.com > *Subject:* $$Excel-Macros$$ Re: WANT TO GET BOX MARGIN IN EVERY SHEET > > > > Hi > > > > I dont know customisation for footer, however you can create Image of data > you want & Insert in footer.. > > > > Cheerz.. > > > > Rgds//Vabs > > > On Saturday, September 15, 2012 7:27:45 PM UTC+5:30, sandeep chhajer wrote: > > Dear all, > > > > I want to get box to be printed in every sheet. > > Now with “repeat rows” I can get only upper margin. I want it to be same > for lower margin to enclose the whole script in a box for a page. Please > help. > > > > *Thank you > Regards > > > Sandeep Kumar Chhajer.* > > * * > > > > > > -- > Join official facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES (1120+ 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. > > 6) Jobs posting is not allowed. > > 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. > > NOTE : Don't ever post personal or 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-...@googlegroups.com > . > To unsubscribe from this group, send email to > excel-macros...@googlegroups.com . > > > > -- > Join official facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES (1120+ 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. > > 6) Jobs posting is not allowed. > > 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. > > NOTE : Don't ever post personal or 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-...@googlegroups.com > . > To unsubscribe from this group, send email to > excel-macros...@googlegroups.com . > > > -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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 MAC
RE: $$Excel-Macros$$ Re: WANT TO GET BOX MARGIN IN EVERY SHEET
You can Make that image and set in footer Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Sandeep Chhajer Sent: 15 September 2012 9:04 To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Re: WANT TO GET BOX MARGIN IN EVERY SHEET Dear sir, How to insert a line in footer. Thank you Regards Sandeep Kumar Chhajer. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Rajan_Verma Sent: 15 September 2012 20:31 To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Re: WANT TO GET BOX MARGIN IN EVERY SHEET Absolutely Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Vabz Sent: 15 September 2012 8:27 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: WANT TO GET BOX MARGIN IN EVERY SHEET Hi I dont know customisation for footer, however you can create Image of data you want & Insert in footer.. Cheerz.. Rgds//Vabs On Saturday, September 15, 2012 7:27:45 PM UTC+5:30, sandeep chhajer wrote: Dear all, I want to get box to be printed in every sheet. Now with "repeat rows" I can get only upper margin. I want it to be same for lower margin to enclose the whole script in a box for a page. Please help. Thank you Regards Sandeep Kumar Chhajer. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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. -- Join official facebook page of this forum @ https://
RE: $$Excel-Macros$$ Re: WANT TO GET BOX MARGIN IN EVERY SHEET
Dear sir, How to insert a line in footer. Thank you Regards Sandeep Kumar Chhajer. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Rajan_Verma Sent: 15 September 2012 20:31 To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Re: WANT TO GET BOX MARGIN IN EVERY SHEET Absolutely Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Vabz Sent: 15 September 2012 8:27 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: WANT TO GET BOX MARGIN IN EVERY SHEET Hi I dont know customisation for footer, however you can create Image of data you want & Insert in footer.. Cheerz.. Rgds//Vabs On Saturday, September 15, 2012 7:27:45 PM UTC+5:30, sandeep chhajer wrote: Dear all, I want to get box to be printed in every sheet. Now with "repeat rows" I can get only upper margin. I want it to be same for lower margin to enclose the whole script in a box for a page. Please help. Thank you Regards Sandeep Kumar Chhajer. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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.
RE: $$Excel-Macros$$ Re: WANT TO GET BOX MARGIN IN EVERY SHEET
Absolutely Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Vabz Sent: 15 September 2012 8:27 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: WANT TO GET BOX MARGIN IN EVERY SHEET Hi I dont know customisation for footer, however you can create Image of data you want & Insert in footer.. Cheerz.. Rgds//Vabs On Saturday, September 15, 2012 7:27:45 PM UTC+5:30, sandeep chhajer wrote: Dear all, I want to get box to be printed in every sheet. Now with "repeat rows" I can get only upper margin. I want it to be same for lower margin to enclose the whole script in a box for a page. Please help. Thank you Regards Sandeep Kumar Chhajer. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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.
$$Excel-Macros$$ Re: WANT TO GET BOX MARGIN IN EVERY SHEET
Hi I dont know customisation for footer, however you can create Image of data you want & Insert in footer.. Cheerz.. Rgds//Vabs On Saturday, September 15, 2012 7:27:45 PM UTC+5:30, sandeep chhajer wrote: > Dear all, > > > > I want to get box to be printed in every sheet. > > Now with “repeat rows” I can get only upper margin. I want it to be same > for lower margin to enclose the whole script in a box for a page. Please > help. > > > > *Thank you > Regards > > > Sandeep Kumar Chhajer.* > > * * > > > > > -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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.
$$Excel-Macros$$ WANT TO GET BOX MARGIN IN EVERY SHEET
Dear all, I want to get box to be printed in every sheet. Now with "repeat rows" I can get only upper margin. I want it to be same for lower margin to enclose the whole script in a box for a page. Please help. Thank you Regards Sandeep Kumar Chhajer. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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. Book1.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Copy Two sheet of one Workbook to other Workbooks
Do you not know the names of your files? simply add a sheet to your workbook and enter these names. 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: Shrinivas Shevde To: excel-macros@googlegroups.com Sent: Sat, September 15, 2012 12:59:38 AM Subject: Re: $$Excel-Macros$$ Copy Two sheet of one Workbook to other Workbooks Dear Experts, If any one can solve this problem I will be verymuch thankful . This will reduce my work . Regards Shrinivas On Fri, Sep 14, 2012 at 12:23 PM, SAGAR KASANGOTTUWAR wrote: Dear Paul, > >How can we create a list of the 15 report files in a sheet? > >Kindly explain the same with example that will help a lot. > >Thanks & Regards, >Sagar > >On Wed, Sep 12, 2012 at 5:46 PM, dguillett1 wrote: > >As Paul said, there is a better way. Provide a file. >> >>Don Guillett >>Microsoft Excel Developer >>SalesAid Software >>dguille...@gmail.com >> >>From: SridharBL >>Sent: Wednesday, September 12, 2012 4:13 AM >>To: excel-macros@googlegroups.com >>Subject: $$Excel-Macros$$ Copy Two sheet of one Workbook to other Workbooks >> >>Hi Experts, >> >>I am working as a analyst and I do publish the review files to Leaders. >>I have one Base excel file, which has two sheets "Basesheet" & "Pipeline" >>sheets. I have to publish 15 review reports to different leaders. >> >>So I should be manually copy "Basesheet" & "Pipeline" to all the 15 excel >>files. Later I filter and delete unwanted data's in these sheets in those 15 >>files. >> >>So, is there a VBA code to copy the "Basesheet" & "Pipeline" to all the 15 >>files >>of different names. >>-- >>Join official facebook page of this forum @ >>https://www.facebook.com/discussexcel >> >>FORUM RULES (1120+ 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. >> >> >>6) Jobs posting is not allowed. >> >>7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. >> >>NOTE : Don't ever post personal or 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. >> >> >> >>-- >>Join official facebook page of this forum @ >>https://www.facebook.com/discussexcel >> >>FORUM RULES (1120+ 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. >> >> >>6) Jobs posting is not allowed. >> >>7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. >> >>NOTE : Don't ever post personal or 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. >> >> >> >-- >Join official facebook page of this forum @ >https://www.facebook.com/discussexcel > >FORUM RULES (1120+ 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 p
RE: $$Excel-Macros$$ Pull out VBA code from sheet
If you are using Excel 2010 , spark lines comes with that, Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of amar takale Sent: 15 September 2012 1:00 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Pull out VBA code from sheet Hi All VBA Experts Can Anybody pull out VBA code from Attached sheet for below chart Pie Charts Horizontal Bars Line Chart Bar Chart Bcos I will Create my own file with this only 4 Chart I like this 4 chart in one cell But there are many code in sheet & I confused which code for which Chart So I want to pull out Code.So I create & assign this code Thanks In Advance if anybody help me Amar -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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.
$$Excel-Macros$$ Re: Highlight Worked Cells only if the Employee has worked in both areas
HI You can use conditional formating in H10 coloumn =IF(A10=A9,IF(H9="",0,IF(H10="",0,1)),IF(H10="",0,IF(H11="",0,1)))=1 & set yellow color if true.. after that you can select area to assign. Cheerz.. Rgds//Vabs On Saturday, September 15, 2012 5:22:57 PM UTC+5:30, prkhan56 wrote: > Hello Experts, > I am using Excel 2010 and have the following problem. > If an employee no. is duplicate and he has worked in both Work Areas > viz EC and RTG then I wish to highlight only those Worked Cells with Yellow. > > I have done it manually to demonstrate my requirement in yellow. > > As the data shown in the attached file is part of a big work area, I would > like to RUN the macro only on the Selected Range after I have selected that > Range. > > Thanks in advance > Rashid Khan > -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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.
Re: $$Excel-Macros$$ Excel to powerpoint
Enhanced metafile Sent on my BlackBerry® from Vodafone -Original Message- From: natu.ajin...@gmail.com Sender: excel-macros@googlegroups.com Date: Sat, 15 Sep 2012 12:15:19 To: Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Excel to powerpoint What format are u pasting the picture as? Sent on my BlackBerry® from Vodafone -Original Message- From: joseph.cam...@gmail.com Sender: excel-macros@googlegroups.com Date: Sat, 15 Sep 2012 11:59:05 To: Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Excel to powerpoint Hi, I am using MSOffice 2010. I create charts in excel and paste them in PowerPoint as picture, the resolution of the chart is very poor. This does not happen when I use 2007 version. Please help. Thanks, Joseph Sent on my BlackBerry® from Vodafone -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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.
Re: $$Excel-Macros$$ Excel to powerpoint
What format are u pasting the picture as? Sent on my BlackBerry® from Vodafone -Original Message- From: joseph.cam...@gmail.com Sender: excel-macros@googlegroups.com Date: Sat, 15 Sep 2012 11:59:05 To: Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Excel to powerpoint Hi, I am using MSOffice 2010. I create charts in excel and paste them in PowerPoint as picture, the resolution of the chart is very poor. This does not happen when I use 2007 version. Please help. Thanks, Joseph Sent on my BlackBerry® from Vodafone -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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.
$$Excel-Macros$$ Excel to powerpoint
Hi, I am using MSOffice 2010. I create charts in excel and paste them in PowerPoint as picture, the resolution of the chart is very poor. This does not happen when I use 2007 version. Please help. Thanks, Joseph Sent on my BlackBerry® from Vodafone -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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.
$$Excel-Macros$$ Highlight Worked Cells only if the Employee has worked in both areas
Hello Experts, I am using Excel 2010 and have the following problem. If an employee no. is duplicate and he has worked in both Work Areas viz EC and RTG then I wish to highlight only those Worked Cells with Yellow. I have done it manually to demonstrate my requirement in yellow. As the data shown in the attached file is part of a big work area, I would like to RUN the macro only on the Selected Range after I have selected that Range. Thanks in advance Rashid Khan -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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. Group Highlight Problem.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Re: Please Help to Find out the solution
Hello Vabs. Hats off bro. Both of your solution are working for me. Thank you. Cheers On Sat, Sep 15, 2012 at 4:52 PM, Vabz wrote: > HI > > You can also use this formual.. > > =OFFSET(A2,1,1,) for Company & =OFFSET(A2,1,2,) for Phone number > > After that copy & paste sepcial all data to its value, then filter all > data. > > After that filer on coloumn A & selct only Blank & delete visible cell so > that you will get only desired data and you will go away with *#N/A*. > > Rgds//Vabs > > On Saturday, September 15, 2012 4:05:51 PM UTC+5:30, Vabz wrote: > >> Hi >> >> See Sheet with formula.. >> >> Let me know if itz fyne. >> >> Cheerz.. >> >> Rgds//Vabz >> >> On Saturday, September 15, 2012 2:54:36 PM UTC+5:30, Wassi wrote: >> >>> Hello Friends, >>> I am new using vba excel. Please help me to find >>> that how we can select after Vlookup. >>> >>> In attached workbook i m trying to find out >>> >>> Company Address >>> and >>> >>> Phone Number >>> >>> Thank you all in Advance >>> >>> -- > Join official facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES (1120+ 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. > > 6) Jobs posting is not allowed. > > 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. > > NOTE : Don't ever post personal or 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. > > > -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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.
$$Excel-Macros$$ Re: Please Help to Find out the solution
HI You can also use this formual.. =OFFSET(A2,1,1,) for Company & =OFFSET(A2,1,2,) for Phone number After that copy & paste sepcial all data to its value, then filter all data. After that filer on coloumn A & selct only Blank & delete visible cell so that you will get only desired data and you will go away with *#N/A*. Rgds//Vabs On Saturday, September 15, 2012 4:05:51 PM UTC+5:30, Vabz wrote: > Hi > > See Sheet with formula.. > > Let me know if itz fyne. > > Cheerz.. > > Rgds//Vabz > > On Saturday, September 15, 2012 2:54:36 PM UTC+5:30, Wassi wrote: > >> Hello Friends, >> I am new using vba excel. Please help me to find >> that how we can select after Vlookup. >> >> In attached workbook i m trying to find out >> >> Company Address >> and >> >> Phone Number >> >> Thank you all in Advance >> >> -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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.
$$Excel-Macros$$ Re: Please Help to Find out the solution
Hi See Sheet with formula.. Let me know if itz fyne. Cheerz.. Rgds//Vabz On Saturday, September 15, 2012 2:54:36 PM UTC+5:30, Wassi wrote: > Hello Friends, > I am new using vba excel. Please help me to find > that how we can select after Vlookup. > > In attached workbook i m trying to find out > > Company Address > and > > Phone Number > > Thank you all in Advance > > -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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. Address_Lookup.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ MIS REPORT FOR HR
Please search in below link http://www.citehr.com/48781-how-make-hr-mis.html On Sat, Sep 15, 2012 at 8:22 AM, kannan excel wrote: > Hi friends, > > i need mis report format for hr purpose. kly help me urgent base. > > regards > kannan v > > -- > Join official facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES (1120+ 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. > > 6) Jobs posting is not allowed. > > 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. > > NOTE : Don't ever post personal or 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. > > > -- . -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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.