Re: $$Excel-Macros$$ unable to use advance vlookup
Hi Aamir, Thanks Is working, that’s what I exactly want to do.But Its better if we avoid extra column. I am able to avoid sheet “Subsidiary Ledger Trial Balance” Helpingcolumn but unable to avoid sheet “Sheet2” Helping column. Can you ………? =VLOOKUP(A2,Sheet2!$A$2:$C$7493,3,0) =IFERROR(LEFT(B2,FIND(-,B2)-1)SUBSTITUTE(RIGHT(B2,LEN(B2)-FIND( ,B2)),(2),),B2) =VLOOKUP(IFERROR(LEFT(B2,FIND(-,B2)-1)SUBSTITUTE(RIGHT(B2,LEN(B2)-FIND( ,B2)),(2),),B2) ,Sheet2!$A$2:$C$7493,3,0) Sheet2!$A$2:$C$7493--? Thanks Regards LAKSHMAN From: Aamir Shahzad aamirshahza...@gmail.com To: excel-macros@googlegroups.com Sent: Sunday, May 20, 2012 8:33 PM Subject: Re: $$Excel-Macros$$ unable to use advance vlookup As desired by you, see the attached file. Aamir Shahzad On Sun, May 20, 2012 at 5:17 PM, Seraj Alam seraj.ala...@gmail.com wrote: Hi, Please try below formula... =IFERROR(VLOOKUP(*A2*,Sheet2!$A$2:$B$3272,2,0),) On Sat, May 19, 2012 at 12:16 PM, LAKSHMAN PRASAD lakshman_...@yahoo.com wrote: Dear Anil, I know Hi, Anil, I know that, but as per my condition or requirement, if first five number (from left) and first name (in any case upper of lower) should be match. subsidary sheet in A17 is 10020-16A-BLKC-MR. ANUPAM SARKAR and in sheet2 in A17 is 10020--BLKC-MR. ANUPAM SARKAR(2) From: Anil Gawli gawlianil8...@gmail.comTo: excel-macros@googlegroups.com Sent: Friday, May 18, 2012 6:22 PM Subject: Re: $$Excel-Macros$$ unable to use advance vlookup subsidary sheet in A17 is 10020-16A-BLKC-MR. ANUPAM SARKAR and in sheet2 in A17 is 10020--BLKC-MR. ANUPAM SARKAR(2) both are not matching that,s why Regards, Anil Gawli On Fri, May 18, 2012 at 6:05 PM, LAKSHMAN PRASAD lakshman_...@yahoo.com wrote: Hi Anil, Plz see cell D13 and D17 value or #NA data no coming From: Anil Gawli gawlianil8...@gmail.com To: excel-macros@googlegroups.com Sent: Friday, May 18, 2012 5:37 PM Subject: Re: $$Excel-Macros$$ unable to use advance vlookup Try this see attached file On Fri, May 18, 2012 at 4:36 PM, LAKSHMAN PRASAD lakshman_...@yahoo.com wrote: Dear Expert I m unable to use advance vlookup, plz see the attached file. Regards LAKSHMAN -- 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 -- Thanks Regards,Gawli Anil NarayanSoftware Developer,Abacus Software Services Pvt Ltd-- 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-- Thanks Regards,Gawli Anil NarayanSoftware Developer,Abacus Software Services Pvt Ltd-- FORUM
Re: $$Excel-Macros$$ Form tracker and new base-1
*Hi Anil and experts, Yes it working good. very very very thank you. you all are genius. i am feeling very guilty that i am unable to create such things (marcos coding). i have tried to learn form various website and books, but i am unable to code my self. i think i very fool on this. Please suggest me how to create own and learn. i think i want a huge advice form the experts. i am very shy on this regards that i am unable to learn on this concerns. if i look all the experts template and coding solved. i am very regretted. Please experts help me. i will be grateful to your kind advice and suggestions. * Thanks Regards, Deba Ranjan P On Mon, May 21, 2012 at 11:37 AM, Anil Gawli gawlianil8...@gmail.comwrote: See the attached File On Mon, May 21, 2012 at 10:46 AM, Deba Ranjan drdeva...@gmail.com wrote: *Hi experts, Please find the attached file. There you will find that *Bé Trần Văn sir has done his best to solved my problem. Thank you very much Bé Trần Văn sir. BUt my tracker is still unsolved. Please see the attached file and click the Tracker button. You will find my query. Thank you experts. Thanks Regards, Deba Ranjan P On Sat, May 19, 2012 at 7:38 PM, Bé Trần Văn betnmtdongna...@gmail.comwrote: 2012/5/19 Deba Ranjan drdeva...@gmail.com * *Hi Experts, the password for Up_validation forM (vba) is - *9815* * Hi Anil and experts, The attached file by Anil sir is properly working in Windows 7 for only the customer not the Customer number, perhaps, i am using windows xp, so might not work. Please check it and let me know. Please see the attached file of my error reflected.* Thanks in advance. Thanks Regards, Deba Ranjan P -- Forwarded message -- From: Deba Ranjan drdeva...@gmail.com Date: Sat, May 19, 2012 at 2:48 PM Subject: $$Excel-Macros$$ Form tracker and new base-1 To: excel-macros@googlegroups.com *Hi Anil and experts, The attached file by Anil sir is properly working in Windows 7 for only the customer not the Customer number, perhaps, i am using windows xp, so might not work. Please check it and let me know. Please see the attached file of my error reflected.* Thanks Regards, Deba Ranjan P -- 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 Form view you do not have the right idea -- 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
$$Excel-Macros$$ REMOVE ME
REMOVE ME Regards, Ashish Saxena The Cosmic Realtors 8586928623 9717111457 From: Shelly Murray lt;shelly.mur...@eamc.orggt; Sent: Sun, 20 May 2012 04:43:18 To: excel-macros@googlegroups.com lt;excel-macros@googlegroups.comgt; Subject: $$Excel-Macros$$ REMOVE ME Shelly Murray, PHR Manager, Labor amp; Workforce Planning East Alabama Medical Center 2000 Pepperell Parkway Opelika, AL 36801 P 334-528-1355 -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of bwo...@cox.net Sent: Saturday, May 19, 2012 6:02 PM To: excel-macros@googlegroups.com Cc: Maries Subject: $$Excel-Macros$$ REMOVE ME Maries lt;talk2mar...@gmail.comgt; wrote: gt; TO UNSUBSCRIBE gt; gt; Google Groups help on the subject: gt; http://support.google.com/groups/bin/answer.py?hl=enamp;answer=46608 gt; gt; Key points thereof: gt; gt; Leave the group by any of these methods: gt; gt; * nbsp; nbsp; nbsp; nbsp; Reply to any group email and change the subject to REMOVE ME gt; gt; * nbsp; nbsp; nbsp; nbsp; Send a blank email to excel-macros+unsubscr...@googlegroups.com gt; gt; * nbsp; nbsp; nbsp; nbsp; If you have a Google account (you could create one first if you gt; want), you can go to http://groups.google.com/group/excel-macros and gt; click Edit my membership then Unsubscribe. nbsp;You can actually also gt; change your email option (even no email) there. gt; gt; gt; gt; [By Asa] gt; gt; gt; Rajan. gt; gt; On Wed, May 16, 2012 at 9:21 PM, Swarup Choghale gt; lt;choghaleswa...@yahoo.co.in gt; gt; wrote: gt; gt; gt; UNSUBSCRIBE gt; gt; gt; gt; Thanks and Regards, gt; gt; Swarup Choghale gt; gt; gt; gt; --- On *Wed, 16/5/12, Naresh V lt;naresh.veerabo...@gmail.comgt;* wrote: gt; gt; gt; gt; gt; gt; From: Naresh V lt;naresh.veerabo...@gmail.comgt; gt; gt; gt; gt; Subject: Re: $$Excel-Macros$$ Time Difference gt; gt; To: excel-macros@googlegroups.com gt; gt; Cc: Mangesh Dayne lt;mangesh.da...@gmail.comgt; gt; gt; Date: Wednesday, 16 May, 2012, 6:47 PM gt; gt; gt; gt; gt; gt; gt; gt; gt; gt; On Wed, May 16, 2012 at 8:04 AM, Mangesh Dayne gt; gt; lt;mangesh.da...@gmail.comlt;http://in.mc1926.mail.yahoo.com/mc/compose? gt; gt; to=mangesh.da...@gmail.comgt; gt; gt; gt; wrote: gt; gt; gt; gt; Hi Friends, gt; gt; gt; gt; Please help me on this issue. gt; gt; gt; gt; Please refer the attached file. gt; gt; gt; gt; In file, nbsp;I need time at other countries depending on the time in Mumbai. gt; gt; Time difference is mentioned in the sheet. gt; gt; Please help me by providing answer/vba code. gt; gt; gt; gt; Thanks gt; gt; gt; gt; gt; gt; Mangesh gt; gt; -- gt; gt; FORUM RULES (986+ members already BANNED for violation) gt; gt; gt; gt; 1) Use concise, accurate thread titles. Poor thread titles, like gt; gt; Please Help, Urgent, Need Help, Formula Problem, Code Problem, and gt; gt; Need Advice will not get quick attention or may not be answered. gt; gt; gt; gt; 2) Don't post a question in the thread of another member. gt; gt; gt; gt; 3) Don't post questions regarding breaking or bypassing any security gt; gt; measure. gt; gt; gt; gt; 4) Acknowledge the responses you receive, good or bad. gt; gt; gt; gt; 5) Cross-promotion of, or links to, forums competitive to this forum gt; gt; in signatures are prohibited. gt; gt; gt; gt; NOTE :nbsp;Don't ever post personal or confidential data in a workbook. gt; gt; Forum owners and members are not responsible for any loss. gt; gt; gt; gt; gt; gt; gt; gt; -- gt; gt; To post to this group, send email to gt; gt; excel-macros@googlegroups.comlt;http://in.mc1926.mail.yahoo.com/mc/com gt; gt; pose?to=excel-macros@googlegroups.comgt; gt; gt; gt; gt; gt; gt; -- gt; gt; FORUM RULES (986+ members already BANNED for violation) gt; gt; gt; gt; 1) Use concise, accurate thread titles. Poor thread titles, like gt; gt; Please Help, Urgent, Need Help, Formula Problem, Code Problem, and gt; gt; Need Advice will not get quick attention or may not be answered. gt; gt; gt; gt; 2) Don't post a question in the thread of another member. gt; gt; gt; gt; 3) Don't post questions regarding breaking or bypassing any security gt; gt; measure. gt; gt; gt; gt; 4) Acknowledge the responses you receive, good or bad. gt; gt; gt; gt; 5) Cross-promotion of, or links to, forums competitive to this forum gt; gt; in signatures are prohibited. gt; gt; gt; gt; NOTE :nbsp;Don't ever post personal or confidential data in a workbook. gt; gt; Forum owners and members are not responsible for any loss. gt; gt; gt; gt; gt; gt; gt; gt; -- gt; gt; To post to this group, send email to excel-macros@googlegroups.com gt; gt; gt; gt; nbsp;-- gt; gt;
$$Excel-Macros$$ Ashish Saxena -The Cosmic Realtors
Hi Guys, I am into a real estate business.please contact me if you want to purchase any property in Delhi NCR. we will provide you the best rate as compare to the market. Also if you have any references than please give my number to them or their no. to me. My offices is as c-4, Sec-63, Noida 201301 by the nae of The Cosmic Realtors Regards, Ashish Saxena The Cosmic Realtors 8586928623 9717111457 From: Shelly Murray lt;shelly.mur...@eamc.orggt; Sent: Sun, 20 May 2012 04:43:18 To: excel-macros@googlegroups.com lt;excel-macros@googlegroups.comgt; Subject: $$Excel-Macros$$ REMOVE ME Shelly Murray, PHR Manager, Labor amp; Workforce Planning East Alabama Medical Center 2000 Pepperell Parkway Opelika, AL 36801 P 334-528-1355 -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of bwo...@cox.net Sent: Saturday, May 19, 2012 6:02 PM To: excel-macros@googlegroups.com Cc: Maries Subject: $$Excel-Macros$$ REMOVE ME Maries lt;talk2mar...@gmail.comgt; wrote: gt; TO UNSUBSCRIBE gt; gt; Google Groups help on the subject: gt; http://support.google.com/groups/bin/answer.py?hl=enamp;answer=46608 gt; gt; Key points thereof: gt; gt; Leave the group by any of these methods: gt; gt; * nbsp; nbsp; nbsp; nbsp; Reply to any group email and change the subject to REMOVE ME gt; gt; * nbsp; nbsp; nbsp; nbsp; Send a blank email to excel-macros+unsubscr...@googlegroups.com gt; gt; * nbsp; nbsp; nbsp; nbsp; If you have a Google account (you could create one first if you gt; want), you can go to http://groups.google.com/group/excel-macros and gt; click Edit my membership then Unsubscribe. nbsp;You can actually also gt; change your email option (even no email) there. gt; gt; gt; gt; [By Asa] gt; gt; gt; Rajan. gt; gt; On Wed, May 16, 2012 at 9:21 PM, Swarup Choghale gt; lt;choghaleswa...@yahoo.co.in gt; gt; wrote: gt; gt; gt; UNSUBSCRIBE gt; gt; gt; gt; Thanks and Regards, gt; gt; Swarup Choghale gt; gt; gt; gt; --- On *Wed, 16/5/12, Naresh V lt;naresh.veerabo...@gmail.comgt;* wrote: gt; gt; gt; gt; gt; gt; From: Naresh V lt;naresh.veerabo...@gmail.comgt; gt; gt; gt; gt; Subject: Re: $$Excel-Macros$$ Time Difference gt; gt; To: excel-macros@googlegroups.com gt; gt; Cc: Mangesh Dayne lt;mangesh.da...@gmail.comgt; gt; gt; Date: Wednesday, 16 May, 2012, 6:47 PM gt; gt; gt; gt; gt; gt; gt; gt; gt; gt; On Wed, May 16, 2012 at 8:04 AM, Mangesh Dayne gt; gt; lt;mangesh.da...@gmail.comlt;http://in.mc1926.mail.yahoo.com/mc/compose? gt; gt; to=mangesh.da...@gmail.comgt; gt; gt; gt; wrote: gt; gt; gt; gt; Hi Friends, gt; gt; gt; gt; Please help me on this issue. gt; gt; gt; gt; Please refer the attached file. gt; gt; gt; gt; In file, nbsp;I need time at other countries depending on the time in Mumbai. gt; gt; Time difference is mentioned in the sheet. gt; gt; Please help me by providing answer/vba code. gt; gt; gt; gt; Thanks gt; gt; gt; gt; gt; gt; Mangesh gt; gt; -- gt; gt; FORUM RULES (986+ members already BANNED for violation) gt; gt; gt; gt; 1) Use concise, accurate thread titles. Poor thread titles, like gt; gt; Please Help, Urgent, Need Help, Formula Problem, Code Problem, and gt; gt; Need Advice will not get quick attention or may not be answered. gt; gt; gt; gt; 2) Don't post a question in the thread of another member. gt; gt; gt; gt; 3) Don't post questions regarding breaking or bypassing any security gt; gt; measure. gt; gt; gt; gt; 4) Acknowledge the responses you receive, good or bad. gt; gt; gt; gt; 5) Cross-promotion of, or links to, forums competitive to this forum gt; gt; in signatures are prohibited. gt; gt; gt; gt; NOTE :nbsp;Don't ever post personal or confidential data in a workbook. gt; gt; Forum owners and members are not responsible for any loss. gt; gt; gt; gt; gt; gt; gt; gt; -- gt; gt; To post to this group, send email to gt; gt; excel-macros@googlegroups.comlt;http://in.mc1926.mail.yahoo.com/mc/com gt; gt; pose?to=excel-macros@googlegroups.comgt; gt; gt; gt; gt; gt; gt; -- gt; gt; FORUM RULES (986+ members already BANNED for violation) gt; gt; gt; gt; 1) Use concise, accurate thread titles. Poor thread titles, like gt; gt; Please Help, Urgent, Need Help, Formula Problem, Code Problem, and gt; gt; Need Advice will not get quick attention or may not be answered. gt; gt; gt; gt; 2) Don't post a question in the thread of another member. gt; gt; gt; gt; 3) Don't post questions regarding breaking or bypassing any security gt; gt; measure. gt; gt; gt; gt; 4) Acknowledge the responses you receive, good or bad. gt; gt; gt; gt; 5) Cross-promotion of, or links to, forums competitive to this forum gt; gt; in signatures are prohibited. gt; gt; gt; gt; NOTE :nbsp;Don't ever post personal or confidential data in a
Re: $$Excel-Macros$$ NEW RULE : No more job postings in this forum.
Welcome, your decision. However I would request you to allow Job openings related with Excel, VBA else Can we have our signatures include Searching for Job (in any of the member is looking for job)? Regards Shekhar Sharma On Sun, May 20, 2012 at 8:24 PM, Ayush Jain jainayus...@gmail.com wrote: Hello everyone, There is sudden increase in job posts and more than half of all job posts are irrelevent not related to excel. I have decided not to allow any jobs whether related to excel or not. *This is not employment forum and intended to help on excel queries only.* Anyone found posting jobs will be banned without any warning. Let me know if you have any questions. Regards Ayush Jain Group Manager and 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 -- Shekhar Sharma 9910010060 Life consists not in holding good cards but in playing those you hold well Before you judge another, think of your own last mistake. -- 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
$$Excel-Macros$$ Drop down list
Hi, I have a drop down list which is created using menu 'data validation'. Is it possible to get the items in the first line in the drop down while start entering the letters of the items. Eg: Item Pen, pencils, Notepad is there in my drop down list, if I start entering P itself Pen and pencils should come in the first line. Please help on this Thanks Smitha -- 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$$ Drop down list
File attached FYI On Mon, May 21, 2012 at 1:50 PM, Smitha S R sperdwo...@gmail.com wrote: Hi, I have a drop down list which is created using menu 'data validation'. Is it possible to get the items in the first line in the drop down while start entering the letters of the items. Eg: Item Pen, pencils, Notepad is there in my drop down list, if I start entering P itself Pen and pencils should come in the first line. Please help on this Thanks Smitha -- 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 -- Thanks Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd -- 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 drop down list .xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Drop down list
Hi, PFA the book with dropdown list prepared using data validation. Suggest whether it is possible in this also. (s it possible to get the items in the first line in the drop down while start entering the letters of the items. Eg: Item Pen, pencils, Notepad is there in my drop down list, if I start entering P itself Pen and pencils should come in the first line.) On Mon, May 21, 2012 at 2:28 PM, Anil Gawli gawlianil8...@gmail.com wrote: File attached FYI On Mon, May 21, 2012 at 1:50 PM, Smitha S R sperdwo...@gmail.com wrote: Hi, I have a drop down list which is created using menu 'data validation'. Is it possible to get the items in the first line in the drop down while start entering the letters of the items. Eg: Item Pen, pencils, Notepad is there in my drop down list, if I start entering P itself Pen and pencils should come in the first line. Please help on this Thanks Smitha -- 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 -- Thanks Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd -- 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 test data validation.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Drop down list
with data validation i don't think so, i have prepared in combo box control. Is it Ok? On Mon, May 21, 2012 at 3:53 PM, Smitha S R sperdwo...@gmail.com wrote: Hi, PFA the book with dropdown list prepared using data validation. Suggest whether it is possible in this also. (s it possible to get the items in the first line in the drop down while start entering the letters of the items. Eg: Item Pen, pencils, Notepad is there in my drop down list, if I start entering P itself Pen and pencils should come in the first line.) On Mon, May 21, 2012 at 2:28 PM, Anil Gawli gawlianil8...@gmail.comwrote: File attached FYI On Mon, May 21, 2012 at 1:50 PM, Smitha S R sperdwo...@gmail.com wrote: Hi, I have a drop down list which is created using menu 'data validation'. Is it possible to get the items in the first line in the drop down while start entering the letters of the items. Eg: Item Pen, pencils, Notepad is there in my drop down list, if I start entering P itself Pen and pencils should come in the first line. Please help on this Thanks Smitha -- 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 -- Thanks Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd -- 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 -- Thanks Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd -- 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
$$Excel-Macros$$ How to distribute one value into different cells proportionately based on some conditions
Hi Experts I am finding some problem in excel formula, pls help me here. I have a excel data at two locations, 1st is Supplier's Bill details and 2nd is Purchase order details. I need a formula that can distribute the Party Bill Amount figure proportionately to PO Amount figures based on B/L# . You can look into attached Sample File for better understanding. In that file I have shown the result what I want in column I. Pls help me here. Regards Amit -- 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 SAMPLE FILE.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
$$Excel-Macros$$ Re: Hi all Experts Cna u share a Macro for outlook emails sending Specific Templet With Attachments formats of .PDF .htm
Hi All Actually i need Export ladger data from tally in .htm format exported data saved in one perticular folder, then i need to send each individual file willbe sending to the individual receipitent Ex: xyz.htm file wilbe sending to the xyz customer and xyz2.htm file will be sending to the xyz2 customer and so on .like this in the end of the month i need to send payslip .pdf files also send as like that only On Thursday, 17 May 2012 17:24:23 UTC+5:30, renuka chari wrote: Dear experts Excel macro for sendin outlook emails from Specific Templet With Attachments formats of .PDF .htm Thanks in Advance -- 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
$$Excel-Macros$$ Appropriate formula required
Dear Friends, In the attached list the total monthly allocations is more than the total amount to be allocated, please suggest a suitable formula to compute the same. R'gds Dhanesh -- 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 Book2.xlsx Description: Book2.xlsx
Re: $$Excel-Macros$$ Form tracker and new base-1
2012/5/21 Deba Ranjan drdeva...@gmail.com *Hi Anil and experts, Yes it working good. very very very thank you. you all are genius. i am feeling very guilty that i am unable to create such things (marcos coding). i have tried to learn form various website and books, but i am unable to code my self. i think i very fool on this. Please suggest me how to create own and learn. i think i want a huge advice form the experts. i am very shy on this regards that i am unable to learn on this concerns. if i look all the experts template and coding solved. i am very regretted. Please experts help me. i will be grateful to your kind advice and suggestions. * Thanks Regards, Deba Ranjan P On Mon, May 21, 2012 at 11:37 AM, Anil Gawli gawlianil8...@gmail.comwrote: See the attached File On Mon, May 21, 2012 at 10:46 AM, Deba Ranjan drdeva...@gmail.comwrote: *Hi experts, Please find the attached file. There you will find that *Bé Trần Văn sir has done his best to solved my problem. Thank you very much Bé Trần Văn sir. BUt my tracker is still unsolved. Please see the attached file and click the Tracker button. You will find my query. Thank you experts. Thanks Regards, Deba Ranjan P On Sat, May 19, 2012 at 7:38 PM, Bé Trần Văn betnmtdongna...@gmail.com wrote: 2012/5/19 Deba Ranjan drdeva...@gmail.com * *Hi Experts, the password for Up_validation forM (vba) is - *9815* * Hi Anil and experts, The attached file by Anil sir is properly working in Windows 7 for only the customer not the Customer number, perhaps, i am using windows xp, so might not work. Please check it and let me know. Please see the attached file of my error reflected.* Thanks in advance. Thanks Regards, Deba Ranjan P -- Forwarded message -- From: Deba Ranjan drdeva...@gmail.com Date: Sat, May 19, 2012 at 2:48 PM Subject: $$Excel-Macros$$ Form tracker and new base-1 To: excel-macros@googlegroups.com *Hi Anil and experts, The attached file by Anil sir is properly working in Windows 7 for only the customer not the Customer number, perhaps, i am using windows xp, so might not work. Please check it and let me know. Please see the attached file of my error reflected.* Thanks Regards, Deba Ranjan P -- 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 Form view you do not have the right idea -- 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
RE: $$Excel-Macros$$ REMOVE ME
See the last line of Group Signature To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Ashish Saxena Sent: 21 May 2012 12:10 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ REMOVE ME REMOVE ME Regards, Ashish Saxena The Cosmic Realtors 8586928623 9717111457 From: Shelly Murray shelly.mur...@eamc.org Sent: Sun, 20 May 2012 04:43:18 To: excel-macros@googlegroups.com excel-macros@googlegroups.com Subject: $$Excel-Macros$$ REMOVE ME Shelly Murray, PHR Manager, Labor Workforce Planning East Alabama Medical Center 2000 Pepperell Parkway Opelika, AL 36801 P 334-528-1355 -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of bwo...@cox.net Sent: Saturday, May 19, 2012 6:02 PM To: excel-macros@googlegroups.com Cc: Maries Subject: $$Excel-Macros$$ REMOVE ME Maries talk2mar...@gmail.com wrote: TO UNSUBSCRIBE Google Groups help on the subject: http://support.google.com/groups/bin/answer.py?hl=en http://support.google.com/groups/bin/answer.py?hl=enanswer=46608 answer=46608 Key points thereof: Leave the group by any of these methods: * Reply to any group email and change the subject to REMOVE ME * Send a blank email to excel-macros+unsubscr...@googlegroups.com * If you have a Google account (you could create one first if you want), you can go to http://groups.google.com/group/excel-macros and click Edit my membership then Unsubscribe. You can actually also change your email option (even no email) there. [By Asa] Rajan. On Wed, May 16, 2012 at 9:21 PM, Swarup Choghale choghaleswa...@yahoo.co.in mailto:choghaleswa...@yahoo.co.in%0b wrote: UNSUBSCRIBE Thanks and Regards, Swarup Choghale --- On *Wed, 16/5/12, Naresh V naresh.veerabo...@gmail.com* wrote: From: Naresh V naresh.veerabo...@gmail.com Subject: Re: $$Excel-Macros$$ Time Difference To: excel-macros@googlegroups.com Cc: Mangesh Dayne mangesh.da...@gmail.com Date: Wednesday, 16 May, 2012, 6:47 PM On Wed, May 16, 2012 at 8:04 AM, Mangesh Dayne mangesh.da...@gmail.comhttp://in.mc1926.mail.yahoo.com/mc/compose? http://www.rediffmail.com/cgi-bin/red.cgi?account_type=1red=http%3A%2F%2Fi n.mc1926.mail.yahoo.com%2Fmc%2Fcompose%3FisImage=0BlockImage=0rediffng=0 to=mangesh.da...@gmail.com wrote: Hi Friends, Please help me on this issue. Please refer the attached file. In file, I need time at other countries depending on the time in Mumbai. Time difference is mentioned in the sheet. Please help me by providing answer/vba code. Thanks Mangesh -- 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.comhttp://in.mc1926.mail.yahoo.com/mc/com http://www.rediffmail.com/cgi-bin/red.cgi?account_type=1red=http%3A%2F%2Fi n.mc1926.mail.yahoo.com%2Fmc%2FcomisImage=0BlockImage=0rediffng=0 pose?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,
$$Excel-Macros$$ Unsubscribe
-- 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$$ NEW RULE : No more job postings in this forum.
Hi Ayush sir, Can you plz exlude me from this forum. Sent on my BlackBerry® from Vodafone -Original Message- From: Ayush Jain jainayus...@gmail.com Sender: excel-macros@googlegroups.com Date: Sun, 20 May 2012 07:54:03 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ NEW RULE : No more job postings in this forum. Hello everyone, There is sudden increase in job posts and more than half of all job posts are irrelevent not related to excel. I have decided not to allow any jobs whether related to excel or not. *This is not employment forum and intended to help on excel queries only.* Anyone found posting jobs will be banned without any warning. Let me know if you have any questions. Regards Ayush Jain Group Manager and 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Appropriate formula required
I don’t understand your example but here is a formula you can adapt if you have the analysis toolpak =MAX(0, MIN(EOMONTH(F$1,0), $B2) - MAX(F$1, $A2) + 1) * $C2 / $D2 Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Dhanesh Verma Sent: Monday, May 21, 2012 7:13 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Appropriate formula required Dear Friends, In the attached list the total monthly allocations is more than the total amount to be allocated, please suggest a suitable formula to compute the same. R’gds Dhanesh DISCLAIMER AND PRIVILEGE NOTICE : This e-mail and any files transmitted with it contain confidential, copyright, proprietary and legally privileged information. It should not be used by anyone who is not the original intended recipient. Any use, distribution, copying or disclosure by any other person is strictly prohibited. If you receive this transmission in error, please notify the sender by reply email and then destroy the message. Opinions, conclusions and other information in this message that do not relate to official business of DEN Networks Ltd., its subsidiaries, holding companies i.e. DEN shall be understood to be neither given nor endorsed by DEN. Internet communications cannot be guaranteed to be timely, Secure, error or virus-free. The sender does not accept liability for any errors or omissions. -- 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
Re: $$Excel-Macros$$ NEW RULE : No more job postings in this forum.
Hi All, Welcome decision. In addition, it is also good that job posting should be related to excel, vba only. Our objective is to make universal platform for EXCEL/VBA LOVERS. with regards, Mangesh On Mon, May 21, 2012 at 7:10 PM, prernacha...@ymail.com wrote: ** Hi Ayush sir, Can you plz exlude me from this forum. Sent on my BlackBerry® from Vodafone -- *From: * Ayush Jain jainayus...@gmail.com *Sender: * excel-macros@googlegroups.com *Date: *Sun, 20 May 2012 07:54:03 -0700 (PDT) *To: *excel-macros@googlegroups.com *ReplyTo: * excel-macros@googlegroups.com *Subject: *$$Excel-Macros$$ NEW RULE : No more job postings in this forum. Hello everyone, There is sudden increase in job posts and more than half of all job posts are irrelevent not related to excel. I have decided not to allow any jobs whether related to excel or not. *This is not employment forum and intended to help on excel queries only.* Anyone found posting jobs will be banned without any warning. Let me know if you have any questions. Regards Ayush Jain Group Manager and 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 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
Re: $$Excel-Macros$$ NEW RULE : No more job postings in this forum.
Thanks everyone for your support. Initially, I allowed to post excel related jobs but that allowance was misused by spammers. It is very difficult to differentiate excel jobs with other technical jobs for moderators. Hence, I have decided not to allow any job opening posts in this forum. Thanks for your understanding. Regards Ayush Jain Group Manager Microsoft MVP On Mon, May 21, 2012 at 9:37 PM, Mangesh Dayne mangesh.da...@gmail.comwrote: Hi All, Welcome decision. In addition, it is also good that job posting should be related to excel, vba only. Our objective is to make universal platform for EXCEL/VBA LOVERS. with regards, Mangesh On Mon, May 21, 2012 at 7:10 PM, prernacha...@ymail.com wrote: ** Hi Ayush sir, Can you plz exlude me from this forum. Sent on my BlackBerry® from Vodafone -- *From: *Ayush Jain jainayus...@gmail.com *Sender: *excel-macros@googlegroups.com *Date: *Sun, 20 May 2012 07:54:03 -0700 (PDT) *To: *excel-macros@googlegroups.com *ReplyTo: *excel-macros@googlegroups.com *Subject: *$$Excel-Macros$$ NEW RULE : No more job postings in this forum. Hello everyone, There is sudden increase in job posts and more than half of all job posts are irrelevent not related to excel. I have decided not to allow any jobs whether related to excel or not. *This is not employment forum and intended to help on excel queries only.* Anyone found posting jobs will be banned without any warning. Let me know if you have any questions. Regards Ayush Jain Group Manager and 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 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 -- Best regards, Ayush Jain -- 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$$ unable to use advance vlookup
sorry not understand make it clear, lots of expert here can solve your issue. Aamir Shahzad On Mon, May 21, 2012 at 11:13 AM, LAKSHMAN PRASAD lakshman_...@yahoo.comwrote: Hi Aamir, Thanks Is working, that’s what I exactly want to do. But Its better if we avoid extra column. I am able to avoid sheet “Subsidiary Ledger Trial Balance” Helping column but unable to avoid sheet “Sheet2” Helping column. Can you ………? =VLOOKUP(A2,Sheet2!$A$2:$C$7493,3,0) =IFERROR(LEFT(B2,FIND(-,B2)-1)SUBSTITUTE(RIGHT(B2,LEN(B2)-FIND( ,B2)),(2),),B2) =VLOOKUP(IFERROR(LEFT(B2,FIND(-,B2)-1)SUBSTITUTE(RIGHT(B2,LEN(B2)-FIND( ,B2)),(2),),B2) ,Sheet2!$A$2:$C$7493,3,0) Sheet2!$A$2:$C$7493--? Thanks Regards LAKSHMAN *From:* Aamir Shahzad aamirshahza...@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Sunday, May 20, 2012 8:33 PM *Subject:* Re: $$Excel-Macros$$ unable to use advance vlookup As desired by you, see the attached file. Aamir Shahzad On Sun, May 20, 2012 at 5:17 PM, Seraj Alam seraj.ala...@gmail.comwrote: Hi, Please try below formula... =IFERROR(VLOOKUP(*A2*,Sheet2!$A$2:$B$3272,2,0),) On Sat, May 19, 2012 at 12:16 PM, LAKSHMAN PRASAD lakshman_...@yahoo.comwrote: Dear Anil, I know Hi, Anil, I know that, but as per my condition or requirement, if first five number (from left) and first name (in any case upper of lower) should be match. subsidary sheet in A17 is 10020-16A-BLKC-MR. ANUPAM SARKAR and in sheet2 in A17 is 10020--BLKC-MR. ANUPAM SARKAR(2) *From:* Anil Gawli gawlianil8...@gmail.com*To:* excel-macros@googlegroups.com *Sent:* Friday, May 18, 2012 6:22 PM *Subject:* Re: $$Excel-Macros$$ unable to use advance vlookup subsidary sheet in A17 is 10020-16A-BLKC-MR. ANUPAM SARKAR and in sheet2 in A17 is 10020--BLKC-MR. ANUPAM SARKAR(2) both are not matching that,s why Regards, Anil Gawli On Fri, May 18, 2012 at 6:05 PM, LAKSHMAN PRASAD lakshman_...@yahoo.comwrote: Hi Anil, Plz see cell D13 and D17 value or #NA data no coming *From:* Anil Gawli gawlianil8...@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Friday, May 18, 2012 5:37 PM *Subject:* Re: $$Excel-Macros$$ unable to use advance vlookup Try this see attached file On Fri, May 18, 2012 at 4:36 PM, LAKSHMAN PRASAD lakshman_...@yahoo.comwrote: *Dear Experthttp://www.hawaii.edu/hivandaids/Dear%20Expert%20Lesson%20Plan.pdf * I m unable to use advance vlookup, plz see the attached file. Regards LAKSHMAN -- 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 -- Thanks Regards,Gawli Anil NarayanSoftware Developer,Abacus Software Services Pvt Ltd-- 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
Re: $$Excel-Macros$$ help in matching data in excel sheet
2012/5/19 Rajan_Verma rajanverma1...@gmail.com Sample file?? ** ** * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Cute Awesome *Sent:* 19 May 2012 6:13 *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ help in matching data in excel sheet ** ** ** ** ** ** - i am having data of sale value derived from sales sheet for over 3200 pieces ** ** the same has been taken in two different excel sheet by two guys but when we try to match sale value its not matching wheres pieces ref is matching. how i can match sale value to remove the difference i.e. 2500 example one guy has taken only sale value and pieces reference while another guy has taken date, sale sheet no, piece ref and sale value. ** ** example ** ** in sheet A the data contains ** ** Date - sale sheet no- pieces reference -sale value ** ** in other sheet B ** ** pieces reference- sale value ** ** when we try to match sale value there's difference in sale value for over2500 but the pieces references are matching ** ** how can i match in excel sheet. Is there any formula to match the sale value of sheet a and sheet b. forward the formula and help in matching the sale value data thanks ** ** Best regards ** ** ** ** ** ** -- 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 You download the file to know how to compare columns and columns? -- 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
$$Excel-Macros$$ Double click Bar Charts
Dear Gurus, I want to create a chart with click event or any other option. Please suggest :- like if i have a bar/pie chart with five products with some sale so i gets five product bars. what i wants is when i click on product 2 bar i should get/open product 2 sales charts linked to it go on further levels also. when i click on product 3 bar i should get/open product 3 sales charts linked to it go on further levels also. Thanks and Regards, -- Pankaj Kumar -- 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$$ Double click Bar Charts
can you share the sample data On Tue, May 22, 2012 at 7:40 AM, pankaj gmail account pankaji...@gmail.comwrote: Dear Gurus, I want to create a chart with click event or any other option. Please suggest :- like if i have a bar/pie chart with five products with some sale so i gets five product bars. what i wants is when i click on product 2 bar i should get/open product 2 sales charts linked to it go on further levels also. when i click on product 3 bar i should get/open product 3 sales charts linked to it go on further levels also. Thanks and Regards, -- Pankaj Kumar -- 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 -- *Regards* * * *Ashish Koul* *http://www.excelvbamacros.com/* *http://www.accessvbamacros.com/* http://www.accessvbamacros.com/ P Before printing, think about the environment. -- 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$$ Double click Bar Charts
Thanks for quick response. Please find attached data. I donot want to use pivot table for this. this is just a new imagination can we do this in excel. Linked Drill down Charts. Thanks and regards, Pankaj Michael On Tue, May 22, 2012 at 7:42 AM, ashish koul koul.ash...@gmail.com wrote: can you share the sample data On Tue, May 22, 2012 at 7:40 AM, pankaj gmail account pankaji...@gmail.com wrote: Dear Gurus, I want to create a chart with click event or any other option. Please suggest :- like if i have a bar/pie chart with five products with some sale so i gets five product bars. what i wants is when i click on product 2 bar i should get/open product 2 sales charts linked to it go on further levels also. when i click on product 3 bar i should get/open product 3 sales charts linked to it go on further levels also. Thanks and Regards, -- Pankaj Kumar -- 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 -- *Regards* * * *Ashish Koul* *http://www.excelvbamacros.com/* *http://www.accessvbamacros.com/* http://www.accessvbamacros.com/ P Before printing, think about the environment. -- 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 -- Pankaj Kumar -- 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 Data.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
RE: $$Excel-Macros$$ NEW RULE : No more job postings in this forum.
Mr. Ayush I also support u r decision to ban those who post the job offer applications. Regards, Muneer, CC... -- 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$$ Drop down list
your attached file is corrupted and cannot be opned? Regards Gawli Anil On Tue, May 22, 2012 at 12:20 AM, Bé Trần Văn betnmtdongna...@gmail.comwrote: 2012/5/21 Anil Gawli gawlianil8...@gmail.com with data validation i don't think so, i have prepared in combo box control. Is it Ok? On Mon, May 21, 2012 at 3:53 PM, Smitha S R sperdwo...@gmail.com wrote: Hi, PFA the book with dropdown list prepared using data validation. Suggest whether it is possible in this also. (s it possible to get the items in the first line in the drop down while start entering the letters of the items. Eg: Item Pen, pencils, Notepad is there in my drop down list, if I start entering P itself Pen and pencils should come in the first line.) On Mon, May 21, 2012 at 2:28 PM, Anil Gawli gawlianil8...@gmail.comwrote: File attached FYI On Mon, May 21, 2012 at 1:50 PM, Smitha S R sperdwo...@gmail.comwrote: Hi, I have a drop down list which is created using menu 'data validation'. Is it possible to get the items in the first line in the drop down while start entering the letters of the items. Eg: Item Pen, pencils, Notepad is there in my drop down list, if I start entering P itself Pen and pencils should come in the first line. Please help on this Thanks Smitha -- 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 -- Thanks Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd -- 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 -- Thanks Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd -- 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 I do not understand, want to make as attachments -- 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
Re: $$Excel-Macros$$ REMOVE ME
just email a blank with out subject to excel-macros+unsubscr...@googlegroups.com to remove yourself from the group. Regards Gawli Anil On Tue, May 22, 2012 at 4:01 AM, Asa Rossoff a...@lovetour.info wrote: Best not to quote my old post that indicates that a remove me subject will work. Google Help says so, but it doesn't look to be true. ** ** I and with Rajan in recommending to just send a blank email to excel-macros+unsubscr...@googlegroups.com to remove yourself from the group. ** ** ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Rajan_Verma *Sent:* Monday, May 21, 2012 6:09 AM *To:* excel-macros@googlegroups.com *Subject:* RE: $$Excel-Macros$$ REMOVE ME ** ** See the last line of Group Signature ** ** To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com ** ** ** ** ** ** * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Ashish Saxena *Sent:* 21 May 2012 12:10 *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ REMOVE ME ** ** REMOVE ME Regards, Ashish Saxena The Cosmic Realtors 8586928623 9717111457 From: Shelly Murray shelly.mur...@eamc.org Sent: Sun, 20 May 2012 04:43:18 To: excel-macros@googlegroups.com excel-macros@googlegroups.com Subject: $$Excel-Macros$$ REMOVE ME Shelly Murray, PHR Manager, Labor Workforce Planning East Alabama Medical Center 2000 Pepperell Parkway Opelika, AL 36801 P 334-528-1355 -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]On Behalf Of bwo...@cox.net Sent: Saturday, May 19, 2012 6:02 PM To: excel-macros@googlegroups.com Cc: Maries Subject: $$Excel-Macros$$ REMOVE ME Maries talk2mar...@gmail.com wrote: TO UNSUBSCRIBE Google Groups help on the subject: http://support.google.com/groups/bin/answer.py?hl=enanswer=46608 Key points thereof: Leave the group by any of these methods: * Reply to any group email and change the subject to REMOVE ME * Send a blank email to excel-macros+unsubscr...@googlegroups.com * If you have a Google account (you could create one first if you want), you can go to http://groups.google.com/group/excel-macros and click Edit my membership then Unsubscribe. You can actually also change your email option (even no email) there. [By Asa] Rajan. On Wed, May 16, 2012 at 9:21 PM, Swarup Choghale choghaleswa...@yahoo.co.in choghaleswa...@yahoo.co.in%0b wrote: UNSUBSCRIBE Thanks and Regards, Swarup Choghale --- On *Wed, 16/5/12, Naresh V naresh.veerabo...@gmail.com* wrote: From: Naresh V naresh.veerabo...@gmail.com Subject: Re: $$Excel-Macros$$ Time Difference To: excel-macros@googlegroups.com Cc: Mangesh Dayne mangesh.da...@gmail.com Date: Wednesday, 16 May, 2012, 6:47 PM On Wed, May 16, 2012 at 8:04 AM, Mangesh Dayne mangesh.da...@gmail.comhttp://in.mc1926.mail.yahoo.com/mc/compose?http://www.rediffmail.com/cgi-bin/red.cgi?account_type=1red=http%3A%2F%2Fin.mc1926.mail.yahoo.com%2Fmc%2Fcompose%3FisImage=0BlockImage=0rediffng=0 to=mangesh.da...@gmail.com wrote: Hi Friends, Please help me on this issue. Please refer the attached file. In file, I need time at other countries depending on the time in Mumbai. Time difference is mentioned in the sheet. Please help me by providing answer/vba code. Thanks Mangesh -- 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.comhttp://in.mc1926.mail.yahoo.com/mc/comhttp://www.rediffmail.com/cgi-bin/red.cgi?account_type=1red=http%3A%2F%2Fin.mc1926.mail.yahoo.com%2Fmc%2FcomisImage=0BlockImage=0rediffng=0 pose?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,
Re: $$Excel-Macros$$ Re: Hi all Experts Cna u share a Macro for outlook emails sending Specific Templet With Attachments formats of .PDF .htm
file attached with modifications disadvantages is that it will ask to attach for every row as an attachments. Regards, Anil Gawli On Mon, May 21, 2012 at 5:44 PM, Anil Gawli gawlianil8...@gmail.com wrote: File attached for ur Reference. On Mon, May 21, 2012 at 5:25 PM, renuka chari jva.ch...@gmail.com wrote: Hi All Actually i need Export ladger data from tally in .htm format exported data saved in one perticular folder, then i need to send each individual file willbe sending to the individual receipitent Ex: xyz.htm file wilbe sending to the xyz customer and xyz2.htm file will be sending to the xyz2 customer and so on .like this in the end of the month i need to send payslip .pdf files also send as like that only On Thursday, 17 May 2012 17:24:23 UTC+5:30, renuka chari wrote: Dear experts Excel macro for sendin outlook emails from Specific Templet With Attachments formats of .PDF .htm Thanks in Advance -- 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 -- Thanks Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd -- Thanks Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd -- 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 Example(Email).xlsm Description: Binary data
