$$Excel-Macros$$ Re: Help needed on average formula
That formula is doing the same as required !! Regards, MandeepBaluja Learningzmypassion. https://www.facebook.com/groups/825221420889809/ https://www.linkedin.com/profile/view?id=312532939 On Wednesday, July 1, 2015 at 9:22:39 AM UTC+5:30, Kumar Bhanushali wrote: *Dear Mandeep,* Please Help. *Regards, Kumar Bhanushali* DISCLAIMER The information contained in this e-mail including attachment is meant only for the addressee and may contain confidential and privileged information. Any use, distribution, printing, retransmission, dissemination, copying or disclosure of this e-mail by any other person is strictly prohibited and may be unlawful. If you are not the intended recipient and receive this e-mail in error, please notify the sender by reply e-mail and then permanently delete this message. Electronic transmission cannot be guaranteed to be secured. Accordingly, PMC Projects (I) Pvt Ltd does not accept liability for any data loss, corruption, interception, unauthorised amendment, viruses, delays or consequences thereof. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Re: Help needed
Dear Kumar, Deciding min Max level based on 3 month data is bit unscientific,you need to have at least 6 months data. Based on data provided by you, I have answered your queries. As mentioned by you GEOFORCE is external warehouse. It is not clear if the stock at other location is replenished from GEOFORCE,.Hence i have given two pivots and minitab box plot analysis. Hope this will solve your query. Prashant Pednekar. On Wed, Apr 15, 2015 at 10:50 PM, kumar skandan1...@gmail.com wrote: Hi, Any one looked at it? On Wednesday, April 15, 2015 at 3:13:43 PM UTC+1, kumar wrote: Hi, Just want to solve the questions with analysis. please find the enclosed attachment and answer the question. I also trying to solve. But needed Gurus help. Thanks -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. Sample data for Analyst_pp.xlsx Description: MS-Excel 2007 spreadsheet
$$Excel-Macros$$ Re: Help needed
Hi, Any one looked at it? On Wednesday, April 15, 2015 at 3:13:43 PM UTC+1, kumar wrote: Hi, Just want to solve the questions with analysis. please find the enclosed attachment and answer the question. I also trying to solve. But needed Gurus help. Thanks -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Re: Help Needed
Dear Friend Dhaval, Thanks for your comments. As per the given requirement i thought this would be the suitable coding. May be I am not understand you exact requirement properly. If possible could you please let me know you requirement clearly once again so that I can try to help you to solve the macro. Have a nice day. Regards, MV On Mon, Mar 2, 2015 at 12:24 AM, michael vinoth michaelvino...@gmail.com wrote: Hi Dhaval Shah, Please find the attached macro file. Regards, MV On Saturday, February 28, 2015 at 2:41:50 PM UTC+5:30, Dhaval Shah wrote: Dear Friends Pls find attached file of my work In sheet two sheets one is main sheet another is daily data in main sheet yellow mark is the difference of two dates i want to do this automatic becuase @ present i do it mannual and its taking too much time pls give me suggestion Warm Regards, Dhaval Shah M) 98240 35253 *E-mail : todhav...@gmail.com* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Re: Help Needed
Try this... Press Alt + F8 Run macro, on prompt enter date for which you are updating data..macro will copy data from daily data sheet to main sheet... Cheers!! On Mon, Mar 2, 2015 at 3:53 PM, Dhaval Shah todhavals...@gmail.com wrote: ANY OTHER WAY TO USE OPTION OF PIVOT TABLE ?? Warm Regards, Dhaval Shah M) 98240 35253 *E-mail : todhavals...@gmail.com todhavals...@gmail.com* On Mon, Mar 2, 2015 at 3:52 PM, Dhaval Shah todhavals...@gmail.com wrote: THANKS DEAR FOR U R EFFORTS BUT ITS NOT USE FULL TO ME BECAUSE WHILE I UPDATE ITS PASTE WRONGLY Warm Regards, Dhaval Shah M) 98240 35253 *E-mail : todhavals...@gmail.com todhavals...@gmail.com* On Mon, Mar 2, 2015 at 12:24 AM, michael vinoth michaelvino...@gmail.com wrote: Hi Dhaval Shah, Please find the attached macro file. Regards, MV On Saturday, February 28, 2015 at 2:41:50 PM UTC+5:30, Dhaval Shah wrote: Dear Friends Pls find attached file of my work In sheet two sheets one is main sheet another is daily data in main sheet yellow mark is the difference of two dates i want to do this automatic becuase @ present i do it mannual and its taking too much time pls give me suggestion Warm Regards, Dhaval Shah M) 98240 35253 *E-mail : todhav...@gmail.com* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit
Re: $$Excel-Macros$$ Re: Help Needed
ANY OTHER WAY TO USE OPTION OF PIVOT TABLE ?? Warm Regards, Dhaval Shah M) 98240 35253 *E-mail : todhavals...@gmail.com todhavals...@gmail.com* On Mon, Mar 2, 2015 at 3:52 PM, Dhaval Shah todhavals...@gmail.com wrote: THANKS DEAR FOR U R EFFORTS BUT ITS NOT USE FULL TO ME BECAUSE WHILE I UPDATE ITS PASTE WRONGLY Warm Regards, Dhaval Shah M) 98240 35253 *E-mail : todhavals...@gmail.com todhavals...@gmail.com* On Mon, Mar 2, 2015 at 12:24 AM, michael vinoth michaelvino...@gmail.com wrote: Hi Dhaval Shah, Please find the attached macro file. Regards, MV On Saturday, February 28, 2015 at 2:41:50 PM UTC+5:30, Dhaval Shah wrote: Dear Friends Pls find attached file of my work In sheet two sheets one is main sheet another is daily data in main sheet yellow mark is the difference of two dates i want to do this automatic becuase @ present i do it mannual and its taking too much time pls give me suggestion Warm Regards, Dhaval Shah M) 98240 35253 *E-mail : todhav...@gmail.com* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Re: Help Needed
THANKS DEAR FOR U R EFFORTS BUT ITS NOT USE FULL TO ME BECAUSE WHILE I UPDATE ITS PASTE WRONGLY Warm Regards, Dhaval Shah M) 98240 35253 *E-mail : todhavals...@gmail.com todhavals...@gmail.com* On Mon, Mar 2, 2015 at 12:24 AM, michael vinoth michaelvino...@gmail.com wrote: Hi Dhaval Shah, Please find the attached macro file. Regards, MV On Saturday, February 28, 2015 at 2:41:50 PM UTC+5:30, Dhaval Shah wrote: Dear Friends Pls find attached file of my work In sheet two sheets one is main sheet another is daily data in main sheet yellow mark is the difference of two dates i want to do this automatic becuase @ present i do it mannual and its taking too much time pls give me suggestion Warm Regards, Dhaval Shah M) 98240 35253 *E-mail : todhav...@gmail.com* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
$$Excel-Macros$$ Re: Help Needed
Hi Dhaval Shah, Please find the attached macro file. Regards, MV On Saturday, February 28, 2015 at 2:41:50 PM UTC+5:30, Dhaval Shah wrote: Dear Friends Pls find attached file of my work In sheet two sheets one is main sheet another is daily data in main sheet yellow mark is the difference of two dates i want to do this automatic becuase @ present i do it mannual and its taking too much time pls give me suggestion Warm Regards, Dhaval Shah M) 98240 35253 *E-mail : todhav...@gmail.com javascript:* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. participant wise.xlsm Description: application/vnd.ms-excel.sheet.macroenabled.12
$$Excel-Macros$$ Re: Help Needed
Dear Sriram, find the attached file. Regards, Mandeep Baluja Excel Specialist. https://www.linkedin.com/profile/view?id=312532939 https://www.facebook.com/VBAEXCELSQL?ref=hl On Tuesday, November 25, 2014 4:52:28 PM UTC+5:30, sriram ji wrote: Dear Guru's If Forecast Deviation Answered on forecast is = 110% it must shown as 80% or else Answered with TH / Net call Offered. Please Help me. [image: Inline image 1] Thanks Reargds, Sriram -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. HelpResolved.xlsx Description: MS-Excel 2007 spreadsheet
$$Excel-Macros$$ Re: Help needed enclosed template also
Hi mandeep. I have to compare prices of different varieties in various markets across markets. Mostly the price comparison is on daily/weekly/Monthly/Yearly basis and thier absolute change or diffrence between two dates. But in the above formula mentioned by you,i have to select dates for various reports and to compare the different dates but in this i have to change the formula daily. And also to keep out the market or variety whom price are not available for the two dates. Is there any permanent way ,any coding or any other way. On Tuesday, November 18, 2014 10:41:27 AM UTC+5:30, Mandeep Baluja wrote: Create a calculated field and set the format of text according find the result attachment. Thanks *Mandeep baluja http://vbaexcelsql.blogspot.in/* On Monday, November 17, 2014 2:11:34 PM UTC+5:30, ram gopal yadav wrote: Dear all, i need your help in attached excel. In Worksheet named 'Master' - Daily prices are hand filled from various weblinks and sources. In 2nd worksheet named 'pivot'- i get table from master sheet for variety prices in different markets. Here the blanks remain blank In 3 rd worksheet named daily- It is the output report to be paste in word file. Here i have to find changes and also delete the markets or variety whom last two day prices arenot available. Problem are I have to do daily removal of markets whom both day price are not available second,if a single day price is available change came as huge by considering blank as zero , so i have to do manually the Daily removal of markets whom both day prices are not available and also write NA (not available) in the price column whom one day price is available. Is it, any way where i can calculate the change in pivot itself and hide the blank automatically. Please find the enclosed template file Looking forward for your response asap. Regards. RAM GOPAL YADAV Contact-08130155401 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
$$Excel-Macros$$ Re: Help needed
right click to select all sheets, then use Find Feature. On Saturday, August 16, 2014 8:29:28 AM UTC+3, Kaushik wrote: Hi Team In the attached excel file I want to do the following to obtain the desired result 1. I want to find each cell in whole workbook and to see its repeating somewhere. 2. If it is repeating then I want a comment in that cell and the cell where it is flowing to so that it will be easy for me to identify where the number is flowing in whole workbook. Please find below sample :- Finding cell C24 with value R13468 in whole workbook [image: Inline image 1]ndonkbook Finding in whole workbook as follows:- We can see that value in Cell C24 of GRF 110_1 sheet appears in cell B69 of GR F 116_0 sheet. Similarly do for all the cells of the workbook and now insert a new worksheet in which it should have details of which cells are repeating and where they are flowing and vice versa. Many thanks in advance for your help. Please let me know if any further details needed. -- *Warm Regards,* *Kaushik Savla* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
$$Excel-Macros$$ Re: Help Needed
But what u want to do with this data ? prince On Wednesday, June 5, 2013 6:50:19 PM UTC+5:30, Patil M G wrote: HI Team Excel Experts I am learning Excel and new to Macro coding. I want to create attached INPUT FILE Format into Output Format...always INPUT FILE have huge data, difficult to do it manually could you please help me to generate macro or is their any other solution ( formula) to over come this problem -- Thank You Patil MG 91 99016 16995 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ Re: Help needed
=MID(A1,(FIND(5,A1)),6) Regards, Vijay On Fri, Apr 12, 2013 at 12:00 PM, Prince prince141...@gmail.com wrote: =IF(LEFT(A1,1)=B,LEFT(A1,6),) On Thursday, April 11, 2013 10:16:28 PM UTC+5:30, Kaushik wrote: Hi Team, I need a formula to find anything starting from 5 in a cell and to take 6 digit right of the cell starting from 5 as below. Eg. DataDesired Result ABC 500012 XYZ 500012 XYZ500134XYZ 500134 Regards, Kaushik -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- Regards, Vijay Kumar Aggarwal -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
$$Excel-Macros$$ Re: Help needed
=IF(LEFT(A1,1)=B,LEFT(A1,6),) On Thursday, April 11, 2013 10:16:28 PM UTC+5:30, Kaushik wrote: Hi Team, I need a formula to find anything starting from 5 in a cell and to take 6 digit right of the cell starting from 5 as below. Eg. DataDesired Result ABC 500012 XYZ 500012 XYZ500134XYZ 500134 Regards, Kaushik -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
$$Excel-Macros$$ Re: Help needed to write For/End loop using Range statement ...
Hi you can visit here to learn all loop in vba http://excelpoweruser.wordpress.com/2011/07/26/looping-in-vba/ Thanks Rajan. On Friday, 26 October 2012 02:26:27 UTC+5:30, Greg wrote: Hi, I would like your help in writing a simple macro that will perform a For/End loop around a .Range statement. I would like the cells in the Range statement to increment by 1 for X number of times. My problem is I do not know how to change the code so that the cells are incremented by the do loop. For example the following code places content in cells AP1 and AP2: With ActiveSheet .Range(AP1).FormulaR1C1 = 'Preferred_Address_Indicator .Range(AP2).Formula = =Switch2(Y2,B, AH2,H,NOT(AH2),O) End With How do I replace the AP1 and AP2 so that it uses a do loop? Thanks in advance for your assistance. -Greg -- 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: Help needed to create a function within a macro
Hi Henning deschka, Please paste this into C1. =SUMPRODUCT(--(($A$1:$A$10=1)+($B$1:$B$10=1)*($C$1:$C$1023400))) Regards Prince On Tuesday, October 9, 2012 6:56:51 PM UTC+5:30, Henning Deschka wrote: Hi NG, I need to insert a function into cell D1 with an Excel2007 macro that executes the following: A B C D row 1 12343 row 21 123444 row 31 43322 row 4 34 row 51 12 row 6 432123 row 7 43234 row 81 3 row 91 3 row 10 1 The entire table has to be considered by the function (A1:C10). Each line has to be evaluated on its own, eg A1:C1. If the contents of A or B are 1 AND the value of C is 23400, then the function has succeeded. If the function succeeds, the final result of the function has to be increased by 1. In this example, the function has succeeded in the following rows: row 2 row 3 row 9 In this example, the function was executed successfully three times - so the final result of the function is 3. Can someone please help by creating a function dealing with this problem? TIA, Henning -- 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: Help needed in sum
try this and drag the same at the end of ur range with criteria =SUMIFS($I$15:$I$24,$J$15:$J$24,N15,$K$15:$K$24,O15) regards prince On Monday, September 3, 2012 5:17:27 PM UTC+5:30, rambo wrote: Dear all, -- Regards Rambabu. G -- 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: Help needed- Converting JPG format file to Excel file via VBA
Hi Thanks for the link, however is it possible to do this job via VBA? Regards Shekhar Sharma On Fri, Apr 20, 2012 at 8:33 PM, ChilExcel chilexcel...@gmail.com wrote: Please see http://www.minipdf.com/ I tried it and it works fine ...jpg at xls Chilexcel 2012/4/20 Shekhar Sharma shekhar1...@gmail.com Hey Kris, Thanks for the quick response, however I am looking for the code for not just adding the image in excel. I want to use the the data available in that picture to further make the changes in excel. Example: I had the data set available in excel like, result out of 100: Student Name Exam1 Exam2 Exam3 Total Kris 65 70 50 185 Raju 70 65 70 190 Sanju 50 65 70 185 and provide this summary to the class teacher by printing this and removed the excel. Now after validating exam paper I relize, I have to update Exam1 marks for Sanju as 60 and Total as 195 and I scanned this paper to further making the adjustments in excel. Can you guys suggest me, how I can convert available information of the JPG/gif/PNG in excel for further changes as I don't want to prepare the excel again and then print. I want to use the scanned image for the correction. Thanks Shekhar Sharma On Fri, Apr 20, 2012 at 2:55 PM, Kris krishnak...@gmail.com wrote: See: http://www.xcelfiles.com/VBA_InsertImgs.html Kris -- 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 -- Visita ; http://sites.google.com/site/chilexcel/Home Visita ; http://www.youtube.com/user/timextag41 -- 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
$$Excel-Macros$$ Re: Help needed- Converting JPG format file to Excel file via VBA
See: http://www.xcelfiles.com/VBA_InsertImgs.html Kris -- 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
Re: $$Excel-Macros$$ Re: Help needed- Converting JPG format file to Excel file via VBA
Hey Kris, Thanks for the quick response, however I am looking for the code for not just adding the image in excel. I want to use the the data available in that picture to further make the changes in excel. Example: I had the data set available in excel like, result out of 100: Student Name Exam1 Exam2 Exam3 Total Kris 65 70 50 185 Raju 70 65 70 190 Sanju 50 65 70 185 and provide this summary to the class teacher by printing this and removed the excel. Now after validating exam paper I relize, I have to update Exam1 marks for Sanju as 60 and Total as 195 and I scanned this paper to further making the adjustments in excel. Can you guys suggest me, how I can convert available information of the JPG/gif/PNG in excel for further changes as I don't want to prepare the excel again and then print. I want to use the scanned image for the correction. Thanks Shekhar Sharma On Fri, Apr 20, 2012 at 2:55 PM, Kris krishnak...@gmail.com wrote: See: http://www.xcelfiles.com/VBA_InsertImgs.html Kris -- 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
Re: $$Excel-Macros$$ Re: Help needed- Converting JPG format file to Excel file via VBA
Please see http://www.minipdf.com/ I tried it and it works fine ...jpg at xls Chilexcel 2012/4/20 Shekhar Sharma shekhar1...@gmail.com Hey Kris, Thanks for the quick response, however I am looking for the code for not just adding the image in excel. I want to use the the data available in that picture to further make the changes in excel. Example: I had the data set available in excel like, result out of 100: Student Name Exam1 Exam2 Exam3 Total Kris 65 70 50 185 Raju 70 65 70 190 Sanju 50 65 70 185 and provide this summary to the class teacher by printing this and removed the excel. Now after validating exam paper I relize, I have to update Exam1 marks for Sanju as 60 and Total as 195 and I scanned this paper to further making the adjustments in excel. Can you guys suggest me, how I can convert available information of the JPG/gif/PNG in excel for further changes as I don't want to prepare the excel again and then print. I want to use the scanned image for the correction. Thanks Shekhar Sharma On Fri, Apr 20, 2012 at 2:55 PM, Kris krishnak...@gmail.com wrote: See: http://www.xcelfiles.com/VBA_InsertImgs.html Kris -- 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 -- Visita ; http://sites.google.com/site/chilexcel/Home Visita ; http://www.youtube.com/user/timextag41 -- 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
$$Excel-Macros$$ Re: Help Needed!
Hi Vasant, I am trying to create a macro to do this below task to avoid manual efforts. For more details please refer the below email. Here is my code- Sub Movefiles() Dim a As Integer Dim fso, f2 With Application.FileSearch .LookIn = C:\LLF\ Range(A1).Value .FileType = msoFileTypeAllFiles .Execute MsgBox Total Files Available is : (.FoundFiles.Count) a = WorksheetFunction.Sum((.FoundFiles.Count) / 50) If .FoundFiles.Count 50 Then On Error GoTo 1 MkDir C:\Amrahs ' change the path and name MsgBox (Folder Created) Exit Sub 1 MsgBox (Folder Already Exist!) Else If .FoundFiles.Count 50 Then Do While a 0 MkDir C:\Target\Amrahs a MsgBox (Folder Created) Loop End If End If End With End Sub Am getting error message in the highlighted line. Also this code is only use to create folders based on number of files available in the specified folder. If the folder contains 500 files then it should be divided by a constant number 50 and you will get 10. So 10 folders needs to be created. Additonally while creating folders the code should move 50 files to the first folder and the next 50 files to the second folder and so on. At last all the 500 files should be moved to the respective 10 folders. If the file count is 480 or 500 then the remaining files should be moved to the last folder. Please look into this and help me to overcome this issue since it is very much required as every time am doing it manually. Any idea or suggestion will be greatly appreciated. Thanks a lot! -Sharma On Mon, Aug 30, 2010 at 12:36 PM, amrahs k amrahs...@gmail.com wrote: Dear Experts, I have a problem to work on a folder where in I need to do manually to do the below task. I have a folder named as Calibration in C: drive. It contains 500 excel files. What I want to do is to create new folder1 and move 50 files to it. Then another 50 files to new folder2 till the folder gets empty (i.e) all the files moved to new folder. Can we do it using VBA. Please suggest me to solve this issue. Regards, Sharma -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ Re: Help needed- Macro to repeat lines 10000 times
Why can't you use Copy paste command. Why you require a macro for this. Regards, Kishan Reddy, K On Aug 18, 9:04 pm, kamal shah kamal...@gmail.com wrote: Hi group I have piece of XML for example below which i need to repeat it for 1 times May I request one of expert to develop a simple macro which will use Paste command and paste piece of lines for 1 times. Cheers Kamal P.S Sample XML TRACONCO1 NamCO17KARV G./NamCO17 StrAndNumCO122DU PONT/StrAndNumCO122 PosCodCO12365487/PosCodCO123 CitCO124ROME/CitCO124 CouCO125IT/CouCO125 TRACONCO1LNGIT/TRACONCO1LNG /TRACONCO1 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ Re: Help needed in changing this code
Just Try this code. Dim CELL As Variant Range(B2:B105).Select For Each CELL In Selection If IsEmpty(CELL) Then With CELL.Offset(0, -1).Interior .ColorIndex = 3 .Pattern = xlSolid .PatternColorIndex = xlAutomatic End With Else With CELL.Interior .ColorIndex = 10 .Pattern = xlSolid .PatternColorIndex = xlAutomatic End With End If Next You may need to change the colorindex as per your pallate. Regards, Kishan Reddy, K kishanreddy.kethire...@gmail.com On Aug 16, 6:05 am, Alexander Cargill zanderman1...@googlemail.com wrote: Hi all I have been working on the following piece of code to identify Blank Cells and turn them red: Range(B2:B105).Select Selection.SpecialCells(xlCellTypeBlanks).Select ActiveWindow.SmallScroll ToRight:=-1 With Selection.Interior .Pattern = xlSolid .PatternColorIndex = xlAutomatic .Color = 255 .TintAndShade = 0 .PatternTintAndShade = 0 End With Range(B15).Select I would like to expand the code to do the following: 1 expand this code so it searches the B column but instead off turning the Blank cells in column B red it turns the cells Ajacent to the blanks in column A Red 2 I would like to turn the cells that are adjacent to the cells that are not blank green If you could help with this I would be most greatful Alex Cargill -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
RE: $$Excel-Macros$$ Re: Help needed in changing this code
Absolutely perfect mate :P may thanks Alex cargill -Original Message- From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Kishan Reddy, K Sent: 16 August 2010 08:13 To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ Re: Help needed in changing this code Just Try this code. Dim CELL As Variant Range(B2:B105).Select For Each CELL In Selection If IsEmpty(CELL) Then With CELL.Offset(0, -1).Interior .ColorIndex = 3 .Pattern = xlSolid .PatternColorIndex = xlAutomatic End With Else With CELL.Interior .ColorIndex = 10 .Pattern = xlSolid .PatternColorIndex = xlAutomatic End With End If Next You may need to change the colorindex as per your pallate. Regards, Kishan Reddy, K kishanreddy.kethire...@gmail.com On Aug 16, 6:05 am, Alexander Cargill zanderman1...@googlemail.com wrote: Hi all I have been working on the following piece of code to identify Blank Cells and turn them red: Range(B2:B105).Select Selection.SpecialCells(xlCellTypeBlanks).Select ActiveWindow.SmallScroll ToRight:=-1 With Selection.Interior .Pattern = xlSolid .PatternColorIndex = xlAutomatic .Color = 255 .TintAndShade = 0 .PatternTintAndShade = 0 End With Range(B15).Select I would like to expand the code to do the following: 1 expand this code so it searches the B column but instead off turning the Blank cells in column B red it turns the cells Ajacent to the blanks in column A Red 2 I would like to turn the cells that are adjacent to the cells that are not blank green If you could help with this I would be most greatful Alex Cargill -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ Re: Help needed to calculate incentive
On Tue, May 4, 2010 at 11:40 PM, Rajeev Nandan rajeev1...@gmail.com wrote: Dear Group Member, Please help me to calculate incentive for each technician. I have tried to apply countifs but could not succeeded. Please suggest if there is any other way to calculate incentives else help me to apply COUNTIFS formula. Regards, Rajeev Nandan -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe Technician Incentive.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
RE: $$Excel-Macros$$ Re: Help needed to calculate incentive
Hi Rajeev, More info please. Dave Date: Tue, 4 May 2010 23:42:37 +0400 Subject: $$Excel-Macros$$ Re: Help needed to calculate incentive From: rajeev1...@gmail.com To: excel-macros@googlegroups.com On Tue, May 4, 2010 at 11:40 PM, Rajeev Nandan rajeev1...@gmail.com wrote: Dear Group Member, Please help me to calculate incentive for each technician. I have tried to apply countifs but could not succeeded. Please suggest if there is any other way to calculate incentives else help me to apply COUNTIFS formula. Regards, Rajeev Nandan -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe _ If It Exists, You'll Find it on SEEK. Australia's #1 job site http://clk.atdmt.com/NMN/go/157639755/direct/01/ -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ Re: Help Needed
Hi All I have data in my excel sheet as follows' *Status * *a* *b* *c* *d* *e* *g* *h* *i** *Work in Progress sfdf shdflsdf lflsdfj dfhdsfh ljhslhsdfla aa aa Closed fdfg ksgdfkgf kgafkgklghfks kgfkgsfdk kghsfdkgsdf khgdfksdf kjdshfkgfsdfhsdf Assigned sjfgsdfg ksgfsdg gsdfdgf klgfkgs gfkgf fgdfsgkgsdfksgdf kgafgsdf kgsdfgf in the above case i am only changing status column all the time usually i change status to *Work in Progress, Closed, Assigned, * **based on the status in the status column, my data has to move. If the status is *Work in Progress* data has to move Sheet2 (Entire Row), if its *Closed* data has to move to *Sheet3* and if is *Assigned* data has to move to *Sheet4* Please let me how i can do either by using formula or through writing Simple Macro -- Thank You Patil MG 9663374848 Life is Very Beautiful!!! ¨`•.•´¨) Always `•.¸(¨`•.•´¨) Keep (¨`•.•´¨)¸•´ Smiling! `•.¸.•´. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe Sample.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Re: help needed
Hi Saiprasath, Copy the data which you want to change automatically in second sheet and choose paste special - Paste Link. Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 10/7/09, sai prasath saiprasath.ex...@gmail.com wrote: Hi Friends. i need help for a project. my question is for example if i have 2 excel sheets if i change a value in first excel sheet automatically it should replicate in the second excel file also, for this do we need to use any macros or we can perform this by using any advance formule. it would be great if i get the answer. thanks in advance, Saiprasth --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: help needed
Hey Sai, You just have to use the formula, it's very easy ...you have to link the files together...I don think we need any macro for this thing... Suppose if you want the value of cell 'A1' of sheet 1 in the cell B1 of sheet2 then just got to B1 of sheet 2 and type = and then go to sheet 1 and select 'A1'. Try it ...it's very simple... I hope I answered ur query. Let us know if we can help u further on this Cheers!! ANISH On Wed, Oct 7, 2009 at 11:50 PM, sai prasath saiprasath.ex...@gmail.comwrote: Hi Friends. i need help for a project. my question is for example if i have 2 excel sheets if i change a value in first excel sheet automatically it should replicate in the second excel file also, for this do we need to use any macros or we can perform this by using any advance formule. it would be great if i get the answer. thanks in advance, Saiprasth --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Help Needed for Debit Credit entries
Dear Dilip, You provided good answer . I have two 1. 1st possible solution based on Identifying the rowsin earlier problem '' leaves the first data matched as it is. 2. Could you tell how to do this in case I have two columns on named Dr and other named Cr. Both Columns have matching figures. How to identify these equal figures.. Regards, Kumar _ From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Dilip Pandey Sent: Thursday, September 17, 2009 9:38 AM To: excel-macros@googlegroups.com Cc: excel-macros group; pradeep170...@gmail.com Subject: $$Excel-Macros$$ Re: Help Needed for Debit Credit entries Hi Pradeep (Deep) Attached workbook has the scenario provided by you along with two possible solutions based on identiying the rows and coloring of the rows. Thanks. -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 9/16/09, Deep pradeep170...@gmail.com wrote: Dear Freinds, I am attaching one file which contains debit credit amounts in same column. But previous column have D or C written which represents the amount is Debit or Credit [D for debit C for Credit] I want to nullify {neutralise} if debit credit amount is same. For example 00630033275492006033020060330OWN CHQ XFER DP C 1000 00630033275492006033020060330WDL TFR TRF TO 0099514300813 D 1000 That means this two rows get seperated or colour change or get delected of represented as Zero Value. This all work I have to do manually by searing each an every entry. The aim of this work is to find out those entries which do not have corresponding debit entries or viceversa. Is some solution is there in excel programing. If possible, please provide me. Thanks a lot in advance. Pradeep Agarwal pradeep170...@gmail.com pradeep.agra...@licindia.com --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Help Needed for Debit Credit entries
Thanks Kumar, And regarding your query, I would request to provide the spreadsheet containing the test scenario with the result, which you are looking for. Thanks. Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 9/24/09, Chandra Gupt Kumar kumar.bemlmum...@gmail.com wrote: Dear Dilip, You provided good answer . I have two 1. 1st possible solution based on “Identifying the rowsin earlier problem ’’ leaves the first data matched as it is. 2. Could you tell how to do this in case I have two columns on named Dr and other named Cr. Both Columns have matching figures. How to identify these equal figures.. Regards, Kumar -- *From:* excel-macros@googlegroups.com [mailto: excel-mac...@googlegroups.com] *On Behalf Of *Dilip Pandey *Sent:* Thursday, September 17, 2009 9:38 AM *To:* excel-macros@googlegroups.com *Cc:* excel-macros group; pradeep170...@gmail.com *Subject:* $$Excel-Macros$$ Re: Help Needed for Debit Credit entries Hi Pradeep (Deep) Attached workbook has the scenario provided by you along with two possible solutions based on identiying the rows and coloring of the rows. Thanks. -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 9/16/09, *Deep* pradeep170...@gmail.com wrote: Dear Freinds, I am attaching one file which contains debit credit amounts in same column. But previous column have D or C written which represents the amount is Debit or Credit [D for debit C for Credit] I want to nullify {neutralise} if debit credit amount is same. For example 00630033275492006033020060330OWN CHQ XFER DP C 1000 00630033275492006033020060330WDL TFR TRF TO 0099514300813 D 1000 That means this two rows get seperated or colour change or get delected of represented as Zero Value. This all work I have to do manually by searing each an every entry. *The aim of this work is to find out those entries which do not have corresponding debit entries or viceversa.* Is some solution is there in excel programing. If possible, please provide me. Thanks a lot in advance. Pradeep Agarwal pradeep170...@gmail.com pradeep.agra...@licindia.com --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Help Needed for Debit Credit entries
*please provide a sample file* Thanks Regards, Harmeet Singh Sent via BlackBerry Wireless On Wed, Sep 16, 2009 at 7:44 PM, Deep pradeep170...@gmail.com wrote: Dear Freinds, I am attaching one file which contains debit credit amounts in same column. But previous column have D or C written which represents the amount is Debit or Credit [D for debit C for Credit] I want to nullify {neutralise} if debit credit amount is same. For example 00630033275492006033020060330OWN CHQ XFER DP C 1000 00630033275492006033020060330WDL TFR TRF TO 0099514300813 D 1000 That means this two rows get seperated or colour change or get delected of represented as Zero Value. This all work I have to do manually by searing each an every entry. *The aim of this work is to find out those entries which do not have corresponding debit entries or viceversa.* Is some solution is there in excel programing. If possible, please provide me. Thanks a lot in advance. Pradeep Agarwal pradeep170...@gmail.com pradeep.agra...@licindia.com --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Help Needed for Debit Credit entries
Hi Pradeep (Deep) Attached workbook has the scenario provided by you along with two possible solutions based on identiying the rows and coloring of the rows. Thanks. -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 9/16/09, Deep pradeep170...@gmail.com wrote: Dear Freinds, I am attaching one file which contains debit credit amounts in same column. But previous column have D or C written which represents the amount is Debit or Credit [D for debit C for Credit] I want to nullify {neutralise} if debit credit amount is same. For example 00630033275492006033020060330OWN CHQ XFER DP C 1000 00630033275492006033020060330WDL TFR TRF TO 0099514300813 D 1000 That means this two rows get seperated or colour change or get delected of represented as Zero Value. This all work I have to do manually by searing each an every entry. *The aim of this work is to find out those entries which do not have corresponding debit entries or viceversa.* Is some solution is there in excel programing. If possible, please provide me. Thanks a lot in advance. Pradeep Agarwal pradeep170...@gmail.com pradeep.agra...@licindia.com --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~--- Deep-CC Number - By DILipandey.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Re: help needed
Hi. Select range and execute the following macro : Sub test() Dim c As Range For Each c In Selection If c.Value Then c.Value = Application.Clean(c.Value) c.Value = Application.Trim(c.Value) End If Next c End Sub Best regards. Daniel From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of ashish koul Sent: dimanche 6 septembre 2009 16:23 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ help needed hi i need a code or macro who will clean unwanted spaces and character in the colums conatings email ids like ashish k...@gmail.com. result should be ashishk...@gmail.com koulashish @gmail.com...result should be koulash...@gmail.com koul.ashish @gmail.com result should be koul.ash...@gmail.com thanks ashish --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 5,200 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: help needed
More precisely : Sub test() Dim c As Range For Each c In Selection If c.Value Then c.Value = Application.Clean(c.Value) c.Value = Application.Trim(c.Value) c.Value = Application.Substitute(c.Value, , ) End If Next c End Sub Daniel From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of ashish koul Sent: dimanche 6 septembre 2009 16:23 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ help needed hi i need a code or macro who will clean unwanted spaces and character in the colums conatings email ids like ashish k...@gmail.com. result should be ashishk...@gmail.com koulashish @gmail.com...result should be koulash...@gmail.com koul.ashish @gmail.com result should be koul.ash...@gmail.com thanks ashish --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 5,200 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: help needed
hi daniel i tried your code its working perfectly thanks but wht in this situation in attached sheet i want to remove all non wanted charters at the end of email ids... Thanks Ashish --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 5,200 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~--- example.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
$$Excel-Macros$$ Re: Help Needed
the zip is password protected Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Wed, Aug 12, 2009 at 5:42 PM, Iqbal Shaikh iqbal.sw...@gmail.com wrote: Hi All Can u help me for open the XL file which is in ZIP. Iqbal S --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 5,200 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: help Needed!
If i understand your query correctly , then the solution would be as follows = 1. write the formula in J2 ... = I2 - D2 2. Copy the cell J2 (Ctrl + C) 3. Select the range J2 to J121 4. Paste (Ctrl + V) but since this is a very very very beginner query,m i doubt i am right. So please elaborate if this is not what you want Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Wed, Aug 12, 2009 at 12:53 PM, Abdul Rehman stevejamesrica...@gmail.comwrote: Hi All, Can anyone guide me how to input formula in column J(file attached) to calculate the value. I am doing tht individually for each row. Would it be possible to write a formula for all the rows in one go -- Warm Regards, Abdul Rehman. Woods are lovely, dark and deep But I have promises to keep, And miles, miles and miles to go before I sleep. --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 5,200 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: help Needed!
Hi Abdul Can you please provide an example. your file has the folloing fields Time of Call Recorded (T1) Tech.Deputed Time Tech. Arrival Time Tech. Responding Time Work Start Time Work Finish Time (T2) Restoration Time (T2-T1) Restoration Time In Mins. can you tell us what should be the final result.. so that the formula can you given accordingly Regards Venkatesh On Wed, Aug 12, 2009 at 12:53 PM, Abdul Rehman stevejamesrica...@gmail.comwrote: Hi All, Can anyone guide me how to input formula in column J(file attached) to calculate the value. I am doing tht individually for each row. Would it be possible to write a formula for all the rows in one go -- Warm Regards, Abdul Rehman. Woods are lovely, dark and deep But I have promises to keep, And miles, miles and miles to go before I sleep. --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 5,200 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: help Needed!
Hi Vivek, Thank you for such a quick response. What I want to do is to calculate the response time for the complete sheet with a single formula. As you have noticed that I am right now using individual formula to get the figure in each cell. By the end of month this sheet will be about 400 long and then it becomes very tedious to input formula in each cell individually. S So I wanted to know if you can input a single formula that will calcuate the value for column J for all rows i.e. 2 to (say) 400. And would it be possible to conver these value into minutes?? Regards, Abdul Rahman. On Wed, Aug 12, 2009 at 12:21 PM, vivek agrawal vivek.agrawa...@gmail.comwrote: If i understand your query correctly , then the solution would be as follows = 1. write the formula in J2 ... = I2 - D2 2. Copy the cell J2 (Ctrl + C) 3. Select the range J2 to J121 4. Paste (Ctrl + V) but since this is a very very very beginner query,m i doubt i am right. So please elaborate if this is not what you want Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Wed, Aug 12, 2009 at 12:53 PM, Abdul Rehman stevejamesrica...@gmail.com wrote: Hi All, Can anyone guide me how to input formula in column J(file attached) to calculate the value. I am doing tht individually for each row. Would it be possible to write a formula for all the rows in one go -- Warm Regards, Abdul Rehman. Woods are lovely, dark and deep But I have promises to keep, And miles, miles and miles to go before I sleep. -- Warm Regards, Abdul Rehman. Woods are lovely, dark and deep But I have promises to keep, And miles, miles and miles to go before I sleep. --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 5,200 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Help Needed
Hi Iqbal, You need password to RAR file or password remover for RAR files…. Regards, Upendra Singh +91-9910227325, +91-9310760597 - There are 10 kinds of people: Those who understand binary and those who don’t. - From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Iqbal Shaikh Sent: Wednesday, August 12, 2009 5:43 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Help Needed Hi All Can u help me for open the XL file which is in ZIP. Iqbal S --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 5,200 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Help needed on MS Access user guide.
Hi Vinod, Please download from below Link.. MSPress_Step_By_Step_MS_Office_Access_2003_EBook.pdf http://rapidshare.com/files/248961528/MSPress_Step_By_Step_MS_Office_Access _2003_EBook.pdf Regards, Upendra Singh +91-9910227325, +91-9310760597 - There are 10 kinds of people: Those who understand binary and those who don't. - From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of vinod rao Sent: Thursday, August 06, 2009 1:44 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Help needed on MS Access user guide. Hello Team, Can someone help me in getting the MS access user manual or guide which help to understand?. Thanks in advance Regards Vinod --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 5,200 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Help Needed - Linking 2 workbooks
Hello, This is the solution (attachment files) as per the query I understood. (Pl. append data in 'Main.xlsx' the same will reflect in 'dupli.xlsx'.) If not happened please mail me back. I will show you the another way. Thanks regards, Dhananjay Pinjan (Mob. No. 9922255533) On 7/24/09, TAlgo trading.a...@gmail.com wrote: All, data on my workbook 'cricket.xlsx' is updated through a DDE link and located under g:\ drive I'm trying to link to same file from another machine so data can be updated on both the workbooks at the same time. my source file - 'G:\NT\Cricket.xlsx Target - 'G:\NT\[Cricket.xlsx]Sheet1'!B3 I'm trying to copy cell B3 to target workbook. Just the cell value doesnt update in target workbook..anythoughts? --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 5,200 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~--- Main.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet Dupli.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
$$Excel-Macros$$ Re: Help Needed !!!
Hems I have aquestion on how to use your form. I am just learing Excel. I made your form come up once from your sheet but I can not make it come up again. Thank you. Don From: Harmeet Singh harmeet.hew...@gmail.com To: Hems coolh...@gmail.com; excel-macros@googlegroups.com Sent: Tuesday, June 23, 2009 4:14:35 PM Subject: $$Excel-Macros$$ Re: Help Needed !!! On Tue, Jun 23, 2009 at 11:21 PM, Hems coolh...@gmail.com wrote: Hi Harmeet, Kindly help me with attached macro. I want view the call details after inserting call id in form 3. but its not happening, don't know any solution for it. and the call should not get logged if any of the field is empty from form1. Appreciate you can help to resolve this issue. Thanx in advance. Hems -- Forwarded message -- From: Hems coolh...@gmail.com Date: Wed, May 27, 2009 at 11:10 PM Subject: $$Excel-Macros$$ Help Needed !!! To: excel-macros@googlegroups.com Hi Friends, I have a master data file which contain customer info along with unique customer number. I want to see the customer details form after entering the customer number in form designed in macro. Is it possible to design such macro ? I am pretty novice in macro coding. Guys please help me. -- Hems ! ! ! -- Luv Hems ! ! ! I don't have the LICENSE to kill ; But then again I can't change my looks. -- Thanks Regards, Harmeet Singh Sent via BlackBerry Wireless --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Help Needed!!!!
1. Select all phone numbers and name the range as Phone_Number (Select the range from the first phone number till row number 65536) 2. Select the cell from where first phone number is ans name the cell as First_Phone_Number 3. Above steps to be followed only once 4. Click on the button It will change the format of all phone numbers to the correct phone. On Thu, Jun 11, 2009 at 1:52 PM, Ajay Varshney ajayvarshney21...@gmail.comwrote: Hi, Check the attached file. It has the solution. Macro : Sub Change_The_Format() Application.ScreenUpdating = False Range(Phone_Number).Select Selection.Copy Range(IU1).Select ActiveSheet.Paste Application.CutCopyMode = False Selection.Replace What:=(, Replacement:=, LookAt:=xlPart, _ SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _ ReplaceFormat:=False Selection.Replace What:=), Replacement:=, LookAt:=xlPart, _ SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _ ReplaceFormat:=False Selection.Replace What:= , Replacement:=, LookAt:=xlPart, _ SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _ ReplaceFormat:=False Selection.Replace What:=-, Replacement:=, LookAt:=xlPart, _ SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _ ReplaceFormat:=False Selection.Replace What:=-, Replacement:=, LookAt:=xlPart, _ SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _ ReplaceFormat:=False Selection.Columns.AutoFit Range(IV1).Select ActiveCell.FormulaR1C1 = =TEXT(RC255,(000) 000-) Range(IV6).Select Range(Selection, Selection.End(xlUp)).Select Selection.FillDown Selection.AutoFilter Range(IV1).Select ActiveSheet.Range($IV$1:$IV$6).AutoFilter Field:=1, Criteria1:= _ (000) 000- Range(IV2).Select Range(Selection, Selection.End(xlDown)).Select Selection.ClearContents Range(IV1).Select Selection.AutoFilter Range(IV1:IV6).Select Selection.Copy Range(First_Phone_Number).Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False Application.CutCopyMode = False Columns(IU:IV).Delete Shift:=xlToLeft Range(A1).Select Application.ScreenUpdating = True MsgBox Done, , Done End Sub On Wed, Jun 10, 2009 at 1:21 PM, amrahs k amrahs...@gmail.com wrote: Hi Ajay, This is Okay! and it is absolutely working fine. But I need a macro to pop up an error message for the incorrect phone format because am not going to enter any phone number in the required spreadsheet. I need to check for the phone number which was captured incorrect. There are large phone numbers has been captured or provided in the Excel file that am currently working upon. My job is to find out the incorrect phone number and correct the same. For this I required any macro that will give me an alert message when i run it. Thanks alot for your suggestion and views. Regards, Sharma On Wed, Jun 10, 2009 at 12:32 PM, Ajay Varshney ajayvarshney21...@gmail.com wrote: *Type phone number without any space, bracket, etc. then change the format of the cells. Rigt ClickFormat CellsNumber TabSelect Special in Cetegory Choose English (U.S.) in LanguageChoose Phone Number in Type Click Ok.* On Tue, Jun 9, 2009 at 5:08 PM, amrahs k amrahs...@gmail.com wrote: Dear Harmeet and Team, I have attached a sample file for your reference with my simple query. Could you please look into this and advice me to proceed further. Thanx in Advance, Regards, Sharma --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Help Needed!!!!
*Type phone number without any space, bracket, etc. then change the format of the cells. Rigt ClickFormat CellsNumber TabSelect Special in Cetegory Choose English (U.S.) in LanguageChoose Phone Number in Type Click Ok.* On Tue, Jun 9, 2009 at 5:08 PM, amrahs k amrahs...@gmail.com wrote: Dear Harmeet and Team, I have attached a sample file for your reference with my simple query. Could you please look into this and advice me to proceed further. Thanx in Advance, Regards, Sharma --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Help Needed!!!!
Can you simply format the cells to SPECIAL then choose PHONE NUMBER? Norman On Tue, Jun 9, 2009 at 7:38 AM, amrahs k amrahs...@gmail.com wrote: Dear Harmeet and Team, I have attached a sample file for your reference with my simple query. Could you please look into this and advice me to proceed further. Thanx in Advance, Regards, Sharma --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Help needed in email writing
Hi, check the below link to write the excel sheet to Word. The code in the article does not satisfy all your requirements, you might want to tweak the code according to your requirements. Also to know the details of saving word to PDF, you might want to check in some PDF forums too. They will have a good idea about the pdf versions and related dlls that you need to reference before writing the macro. http://funwithexcel.blogspot.com/2009/04/writing-excel-contents-into-file-dat.html But definitely you requirements needs some effort. Hope this helps. On Tue, May 19, 2009 at 3:03 PM, prashant kulkarni hope.pr...@gmail.comwrote: HI all, I have a sheet, from which i have to copy particualr data from the sheet, then paste it in the fixed place in word and save the file as *.pdf. there are hundreds of such cases to be dealt with. Is there any way to have amacro in place to do it in a faster way. In short :- 1) the macro should select the data (some selected rows) and copy it in the word. 2) after pasting the data, save the word file as PDF 3) get the next data. Any help would be great. Regards, Prashant -- http://funwithexcel.blogspot.com/ --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: help needed regarding protecting excel files
so kind of u Sharad .yeh if u can help me writing macro bt also the fact is m nt so familiar about macros and all. luking forward... On Sun, Nov 16, 2008 at 10:34 PM, Sharad Sharma [EMAIL PROTECTED]wrote: Hi Suneeta, One way of protcting all xl files in a folder is to write a macro which will individually set a password you specify for all files in that folder. If you insist I can write such macro for you. Sharad On 11/16/08, Sunita Paudel [EMAIL PROTECTED] wrote: *hi all i have been looking all mailz regarding excel that is help me to improve my skill on it since long time.. here i need small helpi have put all my excel works in one folder and i want to protect it puting password ( for folder ) can somone hlp me on this ?? thnx Suneeta * -- Sharad Sharma Mo: (+91) 98303 70814 --~--~-~--~~~---~--~~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com -~--~~~~--~~--~--~---