Re: $$Excel-Macros$$ Date Format Query
Yes rightly said. The file which has been downloaded from software isn't having proper systems date format. So I would like to make it in DD.MM. (2.2.4 digits) Kindly do the needful. On Mon, Jun 16, 2014 at 5:19 PM, Paul Schreiner schreiner_p...@att.net wrote: Guys: I started with the same response, until I noticed that I believe what he's saying is that the value in the cell is NOT an Excel date: He said: Now it is not in system's date format so, he cannot change the display format to display it in another date format. the solution using the parsing the string and re-assembling it as a valid date is what is necessary. *Paul* - *Do all the good you can,By all the means you can,In all the ways you can,In all the places you can,At all the times you can,To all the people you can,As long as ever you can. - John Wesley* - *From:* 'DELIN FRANCIS' via MS EXCEL AND VBA MACROS excel-macros@googlegroups.com *To:* excel-macros@googlegroups.com excel-macros@googlegroups.com *Sent:* Sunday, June 15, 2014 1:24 PM *Subject:* Re: $$Excel-Macros$$ Date Format Query Hi Pravin ... You can go to Format cell and custom the format of the date which ever result you need. furthermore you can see in the attachement. [image: cid:image001.gif@01C80A4D.0DE9E110] *Delin.F* On Sunday, 15 June 2014 4:54 PM, Vaibhav Joshi v...@vabs.in wrote: Hi You can change display format by going to cell property select custom and type dd.mm. If by doing so if date format does not change then select single column then press Data tab in Menu then press Next 2 times then select Date (DMY) and press finish button. Cheers!! On Thu, Jun 12, 2014 at 3:12 PM, Pravin Gunjal isk1...@gmail.com wrote: Hi, I wanted to convert the dates in this format *DD.MM.* Now it is not in system's date format ( MM/DD/ ) and it is displayed as DD/MM/ or as D/M/. Kindly help. Regards Pravin Gunjal. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- 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
Re: $$Excel-Macros$$ Data Fetching
Hi, Thanks for the providing me the solution. But I received sheet 1 file on daily basic in new sheet in that case this file is not working. it would be very helpful if you provide me solution on this Regards On 6/17/14, Vaibhav Joshi v...@vabs.in wrote: Hi Use this file. Cheers!! On Tue, Jun 17, 2014 at 1:22 AM, Vaibhav Joshi v...@vabs.in wrote: HI Since date format is not the same excel can search directly what you want, however macro in attached sheet can help you to fetch data one by one. You need to keep open sheet 1 sheet 2 (Only 2 sheets). Goto sheet 2 workbook, hit that blue button select the date which is in sheet one in column A e.g. cell A8 value will be fetched. Hope it helps. Cheers!! On Mon, Jun 16, 2014 at 7:16 PM, Jocky Beta jocky6...@gmail.com wrote: Hi vaibhav, Fist upon thanks for the reply. I will prefer both the way It would be very helpful If u help me on the same. Regards On 6/16/14, Vaibhav Joshi v...@vabs.in wrote: Hey How do you want to fetch? Formula or Macro? On Sun, Jun 15, 2014 at 11:27 PM, Jocky Beta jocky6...@gmail.com wrote: Hi Team, I want to fetch data from one sheet to another sheet by referring the data, Attached sheet will explain you what i want exactly. Request all of you to kindly help me on this Regards -- 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,
$$Excel-Macros$$ Help Needed
Hi Guys, I want to use formula on pivot table data. Kindly help me. -- Thanks £ Regards Rakesh Kumar +91-9650303464 -- 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. Differance.xlsx Description: MS-Excel 2007 spreadsheet
Re: $$Excel-Macros$$ Help Needed
fyi Warm Regards, Dhaval Shah M) 98240 35253 *E-mail : todhavals...@gmail.com todhavals...@gmail.com* On Tue, Jun 17, 2014 at 12:51 PM, Rakesh kumar rakesh.apt...@gmail.com wrote: Hi Guys, I want to use formula on pivot table data. Kindly help me. -- Thanks £ Regards Rakesh Kumar +91-9650303464 -- 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. Differance.xlsx Description: MS-Excel 2007 spreadsheet
Re: $$Excel-Macros$$ Data Fetching
I didnt get you what you are trying to say! On Tue, Jun 17, 2014 at 12:36 PM, Jocky Beta jocky6...@gmail.com wrote: Hi, Thanks for the providing me the solution. But I received sheet 1 file on daily basic in new sheet in that case this file is not working. it would be very helpful if you provide me solution on this Regards On 6/17/14, Vaibhav Joshi v...@vabs.in wrote: Hi Use this file. Cheers!! On Tue, Jun 17, 2014 at 1:22 AM, Vaibhav Joshi v...@vabs.in wrote: HI Since date format is not the same excel can search directly what you want, however macro in attached sheet can help you to fetch data one by one. You need to keep open sheet 1 sheet 2 (Only 2 sheets). Goto sheet 2 workbook, hit that blue button select the date which is in sheet one in column A e.g. cell A8 value will be fetched. Hope it helps. Cheers!! On Mon, Jun 16, 2014 at 7:16 PM, Jocky Beta jocky6...@gmail.com wrote: Hi vaibhav, Fist upon thanks for the reply. I will prefer both the way It would be very helpful If u help me on the same. Regards On 6/16/14, Vaibhav Joshi v...@vabs.in wrote: Hey How do you want to fetch? Formula or Macro? On Sun, Jun 15, 2014 at 11:27 PM, Jocky Beta jocky6...@gmail.com wrote: Hi Team, I want to fetch data from one sheet to another sheet by referring the data, Attached sheet will explain you what i want exactly. Request all of you to kindly help me on this Regards -- 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
Re: $$Excel-Macros$$ Date Format Query
hi.. if data imported is in date then by using data text t o column you can do easily.. Refer my earlier email.. On Tue, Jun 17, 2014 at 12:19 PM, Pravin Gunjal isk1...@gmail.com wrote: Yes rightly said. The file which has been downloaded from software isn't having proper systems date format. So I would like to make it in DD.MM. (2.2.4 digits) Kindly do the needful. On Mon, Jun 16, 2014 at 5:19 PM, Paul Schreiner schreiner_p...@att.net wrote: Guys: I started with the same response, until I noticed that I believe what he's saying is that the value in the cell is NOT an Excel date: He said: Now it is not in system's date format so, he cannot change the display format to display it in another date format. the solution using the parsing the string and re-assembling it as a valid date is what is necessary. *Paul* - *“Do all the good you can,By all the means you can,In all the ways you can,In all the places you can,At all the times you can,To all the people you can,As long as ever you can.” - John Wesley* - *From:* 'DELIN FRANCIS' via MS EXCEL AND VBA MACROS excel-macros@googlegroups.com *To:* excel-macros@googlegroups.com excel-macros@googlegroups.com *Sent:* Sunday, June 15, 2014 1:24 PM *Subject:* Re: $$Excel-Macros$$ Date Format Query Hi Pravin ... You can go to Format cell and custom the format of the date which ever result you need. furthermore you can see in the attachement. [image: cid:image001.gif@01C80A4D.0DE9E110] *Delin.F* On Sunday, 15 June 2014 4:54 PM, Vaibhav Joshi v...@vabs.in wrote: Hi You can change display format by going to cell property select custom and type dd.mm. If by doing so if date format does not change then select single column then press Data tab in Menu then press Next 2 times then select Date (DMY) and press finish button. Cheers!! On Thu, Jun 12, 2014 at 3:12 PM, Pravin Gunjal isk1...@gmail.com wrote: Hi, I wanted to convert the dates in this format *DD.MM.* Now it is not in system's date format ( MM/DD/ ) and it is displayed as DD/MM/ or as D/M/. Kindly help. Regards Pravin Gunjal. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- 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
Re: $$Excel-Macros$$ Help Needed
Thanks Brother, But how you Did this. Please explain the process. On Tue, Jun 17, 2014 at 1:02 PM, Dhaval Shah todhavals...@gmail.com wrote: fyi Warm Regards, Dhaval Shah M) 98240 35253 *E-mail : todhavals...@gmail.com todhavals...@gmail.com* On Tue, Jun 17, 2014 at 12:51 PM, Rakesh kumar rakesh.apt...@gmail.com wrote: Hi Guys, I want to use formula on pivot table data. Kindly help me. -- Thanks £ Regards Rakesh Kumar +91-9650303464 -- 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. -- Thanks £ Regards Rakesh Kumar +91-9650303464 -- 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$$ Needs help in Data validation
PFA -- Thanks £ Regards Rakesh Kumar +91-9650303464 -- 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. rrr.xlsx Description: MS-Excel 2007 spreadsheet
Re: $$Excel-Macros$$ Date Format Query
This is working perfectly as per my requirement. Thanks. Regards Pravin Gunjal. On Sun, Jun 15, 2014 at 10:54 PM, 'DELIN FRANCIS' via MS EXCEL AND VBA MACROS excel-macros@googlegroups.com wrote: Hi Pravin ... You can go to Format cell and custom the format of the date which ever result you need. furthermore you can see in the attachement. [image: cid:image001.gif@01C80A4D.0DE9E110] *Delin.F* On Sunday, 15 June 2014 4:54 PM, Vaibhav Joshi v...@vabs.in wrote: Hi You can change display format by going to cell property select custom and type dd.mm. If by doing so if date format does not change then select single column then press Data tab in Menu then press Next 2 times then select Date (DMY) and press finish button. Cheers!! On Thu, Jun 12, 2014 at 3:12 PM, Pravin Gunjal isk1...@gmail.com wrote: Hi, I wanted to convert the dates in this format *DD.MM.* Now it is not in system's date format ( MM/DD/ ) and it is displayed as DD/MM/ or as D/M/. Kindly help. Regards Pravin Gunjal. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- 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 a topic in the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this topic, visit https://groups.google.com/d/topic/excel-macros/KuYWzt64SjI/unsubscribe. To unsubscribe from this group and all its topics, 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
Re: $$Excel-Macros$$ Data Fetching
Hi every time I received new sheet from my colleague in. That situation your sheet not working Regards On 6/17/14, Vaibhav Joshi v...@vabs.in wrote: I didnt get you what you are trying to say! On Tue, Jun 17, 2014 at 12:36 PM, Jocky Beta jocky6...@gmail.com wrote: Hi, Thanks for the providing me the solution. But I received sheet 1 file on daily basic in new sheet in that case this file is not working. it would be very helpful if you provide me solution on this Regards On 6/17/14, Vaibhav Joshi v...@vabs.in wrote: Hi Use this file. Cheers!! On Tue, Jun 17, 2014 at 1:22 AM, Vaibhav Joshi v...@vabs.in wrote: HI Since date format is not the same excel can search directly what you want, however macro in attached sheet can help you to fetch data one by one. You need to keep open sheet 1 sheet 2 (Only 2 sheets). Goto sheet 2 workbook, hit that blue button select the date which is in sheet one in column A e.g. cell A8 value will be fetched. Hope it helps. Cheers!! On Mon, Jun 16, 2014 at 7:16 PM, Jocky Beta jocky6...@gmail.com wrote: Hi vaibhav, Fist upon thanks for the reply. I will prefer both the way It would be very helpful If u help me on the same. Regards On 6/16/14, Vaibhav Joshi v...@vabs.in wrote: Hey How do you want to fetch? Formula or Macro? On Sun, Jun 15, 2014 at 11:27 PM, Jocky Beta jocky6...@gmail.com wrote: Hi Team, I want to fetch data from one sheet to another sheet by referring the data, Attached sheet will explain you what i want exactly. Request all of you to kindly help me on this Regards -- 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
$$Excel-Macros$$ Auto update Data, Row Columns
Dear Experts, Please find attached file and please do the needful as per mentioned in the file. Thanks / Regards, Rajeev -- 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. autoupdate.xlsx Description: MS-Excel 2007 spreadsheet
Re: $$Excel-Macros$$ Data Fetching
Hi Try second file which i sent today, pl note..either data structure or heading should be unique.. I have prepared second sheet assuming data structure will be same..For working 1st file you need to have same headings in both input output file. Do let me know where exactly you are finding problem. Cheers!! On Tue, Jun 17, 2014 at 4:18 PM, Jocky Beta jocky6...@gmail.com wrote: Hi every time I received new sheet from my colleague in. That situation your sheet not working Regards On 6/17/14, Vaibhav Joshi v...@vabs.in wrote: I didnt get you what you are trying to say! On Tue, Jun 17, 2014 at 12:36 PM, Jocky Beta jocky6...@gmail.com wrote: Hi, Thanks for the providing me the solution. But I received sheet 1 file on daily basic in new sheet in that case this file is not working. it would be very helpful if you provide me solution on this Regards On 6/17/14, Vaibhav Joshi v...@vabs.in wrote: Hi Use this file. Cheers!! On Tue, Jun 17, 2014 at 1:22 AM, Vaibhav Joshi v...@vabs.in wrote: HI Since date format is not the same excel can search directly what you want, however macro in attached sheet can help you to fetch data one by one. You need to keep open sheet 1 sheet 2 (Only 2 sheets). Goto sheet 2 workbook, hit that blue button select the date which is in sheet one in column A e.g. cell A8 value will be fetched. Hope it helps. Cheers!! On Mon, Jun 16, 2014 at 7:16 PM, Jocky Beta jocky6...@gmail.com wrote: Hi vaibhav, Fist upon thanks for the reply. I will prefer both the way It would be very helpful If u help me on the same. Regards On 6/16/14, Vaibhav Joshi v...@vabs.in wrote: Hey How do you want to fetch? Formula or Macro? On Sun, Jun 15, 2014 at 11:27 PM, Jocky Beta jocky6...@gmail.com wrote: Hi Team, I want to fetch data from one sheet to another sheet by referring the data, Attached sheet will explain you what i want exactly. Request all of you to kindly help me on this Regards -- 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
Re: $$Excel-Macros$$ Repeat Header Rows in prints for specific sheets
thanks a lot bro, this is awesome and that's i need very-2 thanks bro On Thu, Jun 12, 2014 at 10:22 PM, Vaibhav Joshi v...@vabs.in wrote: PFA You need to customize send key letters to get desired output. Cheers!! On Thu, Jun 12, 2014 at 5:34 PM, Rohan Young rohan.j...@gmail.com wrote: its already set on both side printing by default but when i am taking print through that its coming on one side printing On Thu, Jun 12, 2014 at 5:24 PM, Vaibhav Joshi v...@vabs.in wrote: You need to set duplex printing option as default before printing.. On Thu, Jun 12, 2014 at 5:10 PM, Rohan Young rohan.j...@gmail.com wrote: one more thing if you can add on this that is both side printing coz our organization preferred that or excel could take own-self the setting of both side printing as default thanks On Thu, Jun 12, 2014 at 5:06 PM, Rohan Young rohan.j...@gmail.com wrote: please also solve my query of folders of mails logbook regds On Thu, Jun 12, 2014 at 5:05 PM, Rohan Young rohan.j...@gmail.com wrote: thanks a lot bro On Thu, Jun 12, 2014 at 4:33 PM, Vaibhav Joshi v...@vabs.in wrote: PFA Cheers!! .*show(Time)* On Thu, Jun 12, 2014 at 4:02 PM, Rohan Young rohan.j...@gmail.com wrote: no bro, i want Repeat Top row should come in print on every individual sheet's first 6 pages. from page 7 i dont need Repeat Top Row in prints it should come in print without Repeat Top Rows in remaining pages. Same is for rest of the sheets. Thanks On Thu, Jun 12, 2014 at 3:27 PM, Vaibhav Joshi v...@vabs.in wrote: If there is sheets 1 to 10..You want to repeat 1st row of sheet 1 on all pages of sheet 1,2,3 etc.. it it correct?? On Thu, Jun 12, 2014 at 2:33 PM, Rohan Young rohan.j...@gmail.com wrote: hi, i am talking about the Repeat Top Rows not header or footer thanks On Wed, Jun 11, 2014 at 10:42 PM, Vaibhav Joshi v...@vabs.in wrote: Check this link.: http://www.mrexcel.com/forum/excel-questions/456534-excel-visual-basic-applications-change-header-each-page.html Cheers On Jun 11, 2014 9:39 PM, Rohan Young rohan.j...@gmail.com wrote: On Wed, Jun 11, 2014 at 3:11 PM, Rohan Young rohan.j...@gmail.com wrote: Dear Group, I need to repeat header rows in prints in specific sheets after that no need to print header rows on remaining sheets. Thanks in advance ROHAN -- Dear Group, I need to repeat header rows in prints in specific sheets after that no need to print header rows on remaining sheets. Thanks in advance ROHAN -- -- 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
$$Excel-Macros$$ Urgent required Python Developer - San Jose, CA
Please respond to *gurjant.si...@damcosoft.com gurjant.si...@damcosoft.com* *Position: Python DeveloperLocation: San Jose, CADuration: 6 months, possibility of extension* Required Skills: •4+ years Python experience. •2+ years Django •2+ years JS with experience on MV* frameworks such as backbone.js or angular.js •Release to Production Experience. •2+Years RDBMS experience. •Experience in developing REST APIs. Thanks and Regards, Gurjant Singh - (Gary) Technical Recruiter +1 212 389 9503 ext 208 E: gurjant.si...@damcosoft.com *NY Office: *112 W 34th St, 18th Floor, New York, NY 10120 *NJ Office: *894 Green Street, Suite B, Iselin, NJ 08830 Corporate: www.damcosoft.com *[image: Description: cid:image002.jpg@01CEDAE3.C3BE19D0]* *[image: Description: cid:image006.jpg@01CEDAE5.F56ED350]* *P** Please consider the planet before printing | Switch off as you go |**q**Recycle always |* *Your child deserves a better world* *CONFIDENTIALITY NOTICE:** This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message* -- 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$$ Want Excel formula to Omit saturday sunday!
Hi Expert, I want excel formula for below scenario. Date-9=result If result=saturday or sunday then omit saturday or sunday and consider monday. Extample1 02/June/14 - 9=Saturday, May 24, 2014 Want to omit this saturday and sunday want result as Monday, May 26,2014 Extample2 03/June/14 - 9=Sunday, May 25, 2014 Want to omit this sunday and want result as Monday, May 26,2014 Regards, Pankaj -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Want Excel formula to Omit saturday sunday!
Here we can make use of a couple of different concepts: #1) Excel stores dates as numbers (the number of days since 1/1/1900). So, if your date (June 3, 2014) is in cell A1, the date 9 days previous to that is A1-9 #2) The Excel function Weekday() returns the day number of the weekday. the function has optional parameters that let you establish the first day of the week. So, =WEEKDAY(A1-9) will return Sunday=1 through Saturday = 7 but if you use WEEKDAY(A1-9,2) then it will make Monday=1 and Saturday and Sunday are 6 and 7(Friday =5) So, if we test to see if the result of A1-9 is = 5, we can use the date. If it is 6, then it's a Saturday and you need to add 2 days. Otherwise, add 1 day. You end up with a formula like: =IF(WEEKDAY(A1-9,2)=5,A1-9, IF(WEEKDAY(A1-9,2)=6,A1-9+2,A1-9+1)) Of course you could simplify it with: =IF(WEEKDAY(A1-9,2)=5,A1-9, IF(WEEKDAY(A1-9,2)=6,A1-7,A1-8)) Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - From: pankaj khairanar pankajkh...@gmail.com To: excel-macros@googlegroups.com Sent: Tuesday, June 17, 2014 10:28 AM Subject: $$Excel-Macros$$ Want Excel formula to Omit saturday sunday! Hi Expert, I want excel formula for below scenario. Date-9=result If result=saturday or sunday then omit saturday or sunday and consider monday. Extample1 02/June/14 - 9=Saturday, May 24, 2014 Want to omit this saturday and sunday want result as Monday, May 26,2014 Extample2 03/June/14 - 9=Sunday, May 25, 2014 Want to omit this sunday and want result as Monday, May 26,2014 Regards, Pankaj -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
$$Excel-Macros$$ Urgent required .Net developer - Dublin, OH
*Please respond to gurjant.si...@damcosoft.com gurjant.si...@damcosoft.com* *Position: .Net developerLocation: Dublin, OHDuration: 3 to 6 months (Extendable)* Visa: US/GC/EAD only Revised skills: What we would need: 1. Object Oriented Programming 2. .NET C# a. Generics, Collections, LINQ b. File IO – Text, XML etc. c. Regular Expressions 3. VSTO using C# 4. Design Patterns 5. WCF Services, Web Services Good to have a. SQL Database b. ASP.NET MVC c. JavaScript / JQuery Thanks and Regards, Gurjant Singh - (Gary) Technical Recruiter +1 212 389 9503 ext 208 E: gurjant.si...@damcosoft.com *NY Office: *112 W 34th St, 18th Floor, New York, NY 10120 *NJ Office: *894 Green Street, Suite B, Iselin, NJ 08830 Corporate: www.damcosoft.com *[image: Description: cid:image002.jpg@01CEDAE3.C3BE19D0]* *[image: Description: cid:image006.jpg@01CEDAE5.F56ED350]* *P** Please consider the planet before printing | Switch off as you go |**q**Recycle always |* *Your child deserves a better world* *CONFIDENTIALITY NOTICE:** This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Want Excel formula to Omit saturday sunday!
Thanks Paul! Got the solution and as well knowledge! Regards, Pankaj On Tuesday, June 17, 2014 8:43:44 PM UTC+5:30, Paul Schreiner wrote: Here we can make use of a couple of different concepts: #1) Excel stores dates as numbers (the number of days since 1/1/1900). So, if your date (June 3, 2014) is in cell A1, the date 9 days previous to that is A1-9 #2) The Excel function Weekday() returns the day number of the weekday. the function has optional parameters that let you establish the first day of the week. So, =WEEKDAY(A1-9) will return Sunday=1 through Saturday = 7 but if you use WEEKDAY(A1-9,2) then it will make Monday=1 and Saturday and Sunday are 6 and 7(Friday =5) So, if we test to see if the result of A1-9 is = 5, we can use the date. If it is 6, then it's a Saturday and you need to add 2 days. Otherwise, add 1 day. You end up with a formula like: =IF(WEEKDAY(A1-9,2)=5,A1-9, IF(WEEKDAY(A1-9,2)=6,A1-9+2,A1-9+1)) Of course you could simplify it with: =IF(WEEKDAY(A1-9,2)=5,A1-9, IF(WEEKDAY(A1-9,2)=6,A1-7,A1-8)) *Paul* - *“Do all the good you can,By all the means you can,In all the ways you can,In all the places you can,At all the times you can,To all the people you can,As long as ever you can.” - John Wesley* - *From:* pankaj khairanar panka...@gmail.com javascript: *To:* excel-...@googlegroups.com javascript: *Sent:* Tuesday, June 17, 2014 10:28 AM *Subject:* $$Excel-Macros$$ Want Excel formula to Omit saturday sunday! Hi Expert, I want excel formula for below scenario. Date-9=result If result=saturday or sunday then omit saturday or sunday and consider monday. Extample1 02/June/14 - 9=Saturday, May 24, 2014 Want to omit this saturday and sunday want result as Monday, May 26,2014 Extample2 03/June/14 - 9=Sunday, May 25, 2014 Want to omit this sunday and want result as Monday, May 26,2014 Regards, Pankaj -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros...@googlegroups.com javascript:. To post to this group, send email to excel-...@googlegroups.com javascript:. 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$$ Want Excel formula to Omit saturday sunday!
Networkdays( stdate, end date,[holidays] Thanks Regards Hari Kumar Our strength grows from our weakness. On Jun 17, 2014 10:28 AM, pankaj khairanar pankajkh...@gmail.com wrote: Hi Expert, I want excel formula for below scenario. Date-9=result If result=saturday or sunday then omit saturday or sunday and consider monday. Extample1 02/June/14 - 9=Saturday, May 24, 2014 Want to omit this saturday and sunday want result as Monday, May 26,2014 Extample2 03/June/14 - 9=Sunday, May 25, 2014 Want to omit this sunday and want result as Monday, May 26,2014 Regards, Pankaj -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
$$Excel-Macros$$ Urgent required Java developer (Scala) - Indianapolis,IN
*Please respond to gurjant.si...@damcosoft.com gurjant.si...@damcosoft.com* *Position: Java developer (Scala)Location: Indianapolis,INDuration: 6-12 Months* *Position: 10* This is an immediate requirement and interview can happen immediately with next day join date. JD: Strong functional programming knowledge, Scala Strong SQL knowledge, MySQL experience Strong experience with JMS, RESTful webservices Proficiency building unit tests Proficiency building and deploying cloud-based applications, preferably using AWS optional - experieince with ElasticSearch, RDS, SQS Experience with continuous integration tools like Jenkins or CircleCI Experience with PLAY framework Thanks and Regards, Gurjant Singh - (Gary) Technical Recruiter +1 212 389 9503 ext 208 E: gurjant.si...@damcosoft.com *NY Office: *112 W 34th St, 18th Floor, New York, NY 10120 *NJ Office: *894 Green Street, Suite B, Iselin, NJ 08830 Corporate: www.damcosoft.com *[image: Description: cid:image002.jpg@01CEDAE3.C3BE19D0]* *[image: Description: cid:image006.jpg@01CEDAE5.F56ED350]* *P** Please consider the planet before printing | Switch off as you go |**q**Recycle always |* *Your child deserves a better world* *CONFIDENTIALITY NOTICE:** This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message* -- 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.
