$$Excel-Macros$$ Files / Folders Sharing Query - reg.
Dear Premor, I could able to learn something about VBA-Macros after joining this group only.. and before that even I didn't think that it that excel could do such a nice work for users. As I do not know in deep about VBA, I would request you to please do me a favor in this regard. Thank you, Regards Pravin Gunjal. -- Forwarded message -- From: De Premor d...@premor.net Date: Thu, Jul 11, 2013 at 11:01 AM Subject: Re: $$Excel-Macros$$ Files / Folders Sharing Query - reg. To: excel-macros@googlegroups.com Why didn't you write your own code, i was send enough sample code for create that, i think this is the time for you to find your own fish. Rgds, [dp] Pada 11/07/2013 12:08, Pravin Gunjal menulis: Dear Premor, Before save code is working fine and creating a backup, if you arrange the same code by removing error line, would be helpful for me. Pl do the needful. Thanks, 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/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
Fwd: $$Excel-Macros$$ Files / Folders Sharing Query - reg.
*Dear Premor,* * * *Please accept my sincere thanks for doing so much of work for me..* * * *Regards* *Pravin Gunjal.* -- Forwarded message -- From: Pravin Gunjal isk1...@gmail.com Date: Thu, Jul 11, 2013 at 11:29 AM Subject: $$Excel-Macros$$ Files / Folders Sharing Query - reg. To: excel-macros@googlegroups.com Dear Premor, I could able to learn something about VBA-Macros after joining this group only.. and before that even I didn't think that it that excel could do such a nice work for users. As I do not know in deep about VBA, I would request you to please do me a favor in this regard. Thank you, Regards Pravin Gunjal. -- Forwarded message -- From: De Premor d...@premor.net Date: Thu, Jul 11, 2013 at 11:01 AM Subject: Re: $$Excel-Macros$$ Files / Folders Sharing Query - reg. To: excel-macros@googlegroups.com Why didn't you write your own code, i was send enough sample code for create that, i think this is the time for you to find your own fish. Rgds, [dp] Pada 11/07/2013 12:08, Pravin Gunjal menulis: Dear Premor, Before save code is working fine and creating a backup, if you arrange the same code by removing error line, would be helpful for me. Pl do the needful. Thanks, 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/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
Fwd: $$Excel-Macros$$ Vlookup function using with match columns
Dear Friends, It is possible to lookup the values for the left side and second value, third value Is their any other ways or functions to get the results.? 1. Shall we can get the left side result by using vlookup function? 2. Shall we can get the second value result by using vlookup function? Thanks in advance. -- Forwarded message -- From: Prafull Jadhav prafulltjad...@gmail.com Date: 10 July 2013 16:52 Subject: Re: $$Excel-Macros$$ Vlookup function using with match columns To: excel-macros@googlegroups.com Dear Murli, You can just give ref of column,,, for example if you want B column then put (B:B). =VLOOKUP($L24,$A$3:$D$6,COLUMN(B:B),0) On Wed, Jul 10, 2013 at 4:43 PM, Muralidhar E emuralidha...@gmail.comwrote: Hi, Dear friends, Thank u With the same i want to know using column columns *2.This is using columns or column function* =vlookup(lookup_value, Table array,*columns or column(array)*,range lookup). I want to know how can we use both these functions. 1. Shall we can get the left side result by using vlookup function? 2. Shall we can get the second value result by using vlookup function? Thanks in advance. On 10 July 2013 16:34, Prafull Jadhav prafulltjad...@gmail.com wrote: Dear Murli, Find the same Regards, Prafull Jadhav. On Wed, Jul 10, 2013 at 3:59 PM, Muralidhar E emuralidha...@gmail.comwrote: Dear friends, Good afternoon, I need a help and I want to know how to use vlookup function by using match and columns function. How it is works? Plz, share with me. *1.This is using match function* =vlookup(lookup_value,Table array*,match(lookup_value,lookup_array,match type),*range lookup). *2.This is using columns or column function* =vlookup(lookup_value, Table array,*columns or column(array)*,range lookup). I want to know how can we use both these functions. 1. Shall we can get the left side result by using vlookup function? 2. Shall we can get the second value result by using vlookup function? *Note:* It is more helpful with sharing date by examples. Thanks in advance. -- Forwarded message -- From: Muralidhar E emuralidha...@gmail.com Date: 10 July 2013 15:30 Subject: $$Excel-Macros$$ Vlookup function using with match columns To: excel-macros@googlegroups.com Dear friends, Good afternoon, I need a help and I want to know how to use vlookup function by using match and columns function. How it is works? Plz, share with me. *1.This is using match function* =vlookup(lookup_value,Table array*,match(lookup_value,lookup_array,match type),*range lookup). *2.This is using columns function* =vlookup(lookup_value, Table array,*columns(array)*,range lookup). I want to know how can we use both these functions. 1. Shall we can get the left side result by using vlookup function? 2. Shall we can get the second value result by using vlookup function? *Note:* It is more helpful with sharing date by examples. Thanks in advance. -- *Thanks Regards,* ** *Muralidhar E.* Think different Do Different Make different -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- *Thanks Regards,* ** *Muralidhar E.* Think different Do Different Make different -- 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
$$Excel-Macros$$ Too many cell formats
Dear All, I am trying to change the format of a cell in an excel sheet. It gives me a pop-up box as 'Too many cell formats', which is not allowing me to change the format. Could you please help me solving that issue ? Many thanks, Kaushal Rgds, Kaushal -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ Too many cell formats
This problem occurs when the workbook contains more than approximately 4,000 different combinations of cell formats in Excel 2003 or 64,000 in Excel 2007 and higher. A combination is defined as a unique set of formatting elements that are applied to a cell. A combination includes all font formatting (for example: typeface, font size, italic, bold, and underline), borders (for example: location, weight, and color), cell patterns, number formatting, alignment, and cell protection. If two or more cells share exactly the same formatting, they use one formatting combination. However, if there are any differences in formatting between the cells, each cell uses a different combination. On Thu, Jul 11, 2013 at 2:09 PM, Kaushal Kumar kaushal.anal...@live.comwrote: Dear All, I am trying to change the format of a cell in an excel sheet. It gives me a pop-up box as 'Too many cell formats', which is not allowing me to change the format. Could you please help me solving that issue ? Many thanks, Kaushal Rgds, Kaushal -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
$$Excel-Macros$$ Difference Between Iferror Iserror
Hi Group, Kindly let us know the difference between Iserror iferror in excel Regards Raj Bharti -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ Difference Between Iferror Iserror
both are same. in 2003 there was iferror and in 2007 it replaced by iserror. On Thu, Jul 11, 2013 at 4:09 PM, Raj Kumar rajlu...@gmail.com wrote: Hi Group, Kindly let us know the difference between Iserror iferror in excel Regards Raj Bharti -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
$$Excel-Macros$$ excel time tracking
hi friends, anybody have excel time tracking format?? i want to track my employee details in excel.. if i enter my employee id number means his it will come automatically pls send asap... regards Kannan V -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
$$Excel-Macros$$ Need Cab Roster Data
Dear Seniors, Does any one have any type of CAB or Transport Roster Data. if yes, then please share. I need it on urgent basis. Please Help..!! Thanks, Ashish -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
$$Excel-Macros$$ Query in Pivot Table
Dear Experts, I have a query related to Pivot Table. Pls refer to attachment. -- Regards, Rakesh Kumar Sharma Contact: +91-9971024741 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. Query on PIVOT.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Query in Pivot Table
Dear Rakesh, please see attachment. in case of place months in ascending order. you have to do it manually. right click on any month and move it to left, right, to beginning or to end. Regards, Waseem Saifi On 7/11/13, Rakesh Kumar Sharma rakeshks@gmail.com wrote: Dear Experts, I have a query related to Pivot Table. Pls refer to attachment. -- Regards, Rakesh Kumar Sharma Contact: +91-9971024741 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. Query on PIVOT.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Macro to remove a timestamp in a date
Please share your file mentioning all your requirements..I'll try.. On 7/8/13, srsev6 srs...@gmail.com wrote: Thank you Enrique. How do I set this up in a code to be able to use in a command button? I am familiar with codes in visual basic but not an expert by any means in writing them. On Wednesday, July 3, 2013 7:15:00 PM UTC-5, Enrique Martin wrote: you can use = text(cell,dd mmm ), this will give time in text format. On Thu, Jul 4, 2013 at 3:17 AM, srsev6 srs...@gmail.com javascript:wrote: Hi all, I have already posted this once but can not locate it so I apologize for the duplicate post. I hope someone can answer my question. I run dates out of a database which uses access. The dates I pull out have a timestamp. The timestamp hinders my formulas in my excel spreadsheets. I pull hundreds of dates at one time. Is there a macro I can use in a template that will remove the timestamp from the date on a range of cells so I don't have to keep using =int(cell)? I would like to create an excel template that has a command button I can click and run to remove the timestamp. Thank you all for your help. SRSEV6 -- 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.comjavascript: . Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Regards, Anoop Sr. Developer Facebook ID - https://www.facebook.com/anooop.k.sharma -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Regards, Anoop Sr. Developer Facebook ID - https://www.facebook.com/anooop.k.sharma -- 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
Re: $$Excel-Macros$$ Macro to remove a timestamp in a date
Thanks for your help Enrique. I have attached the file. In column D Forecast_Date is the column I want to apply the code to. I have added a command button I would like to click on to have the code run. If you double click in a cell under column D you will see there is a date stamp. No matter how I format it the date stamp remains. This is a small sample of many reports I pull in a day and have to review the data. Removing the date stamp quickly will make life so much easier for me. Thanks again for your help. On Thursday, July 11, 2013 10:37:12 AM UTC-5, Enrique Martin wrote: Please share your file mentioning all your requirements..I'll try.. On 7/8/13, srsev6 srs...@gmail.com javascript: wrote: Thank you Enrique. How do I set this up in a code to be able to use in a command button? I am familiar with codes in visual basic but not an expert by any means in writing them. On Wednesday, July 3, 2013 7:15:00 PM UTC-5, Enrique Martin wrote: you can use = text(cell,dd mmm ), this will give time in text format. On Thu, Jul 4, 2013 at 3:17 AM, srsev6 srs...@gmail.com javascript:wrote: Hi all, I have already posted this once but can not locate it so I apologize for the duplicate post. I hope someone can answer my question. I run dates out of a database which uses access. The dates I pull out have a timestamp. The timestamp hinders my formulas in my excel spreadsheets. I pull hundreds of dates at one time. Is there a macro I can use in a template that will remove the timestamp from the date on a range of cells so I don't have to keep using =int(cell)? I would like to create an excel template that has a command button I can click and run to remove the timestamp. Thank you all for your help. SRSEV6 -- 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.comjavascript: . Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Regards, Anoop Sr. Developer Facebook ID - https://www.facebook.com/anooop.k.sharma -- 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.comjavascript:. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Regards, Anoop Sr. Developer Facebook ID - https://www.facebook.com/anooop.k.sharma -- 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
Re: $$Excel-Macros$$ Macro to remove a timestamp in a date
try this Sub sample() Dim cl As Range For Each cl In Range(d2:d Range(d1048576).End(xlUp).Row) cl.NumberFormat = @ cl.Value = Application.WorksheetFunction.Text(cl.Value, dd mmm ) Next End Sub see if it helps On Thu, Jul 11, 2013 at 9:43 PM, srsev6 srs...@gmail.com wrote: Thanks for your help Enrique. I have attached the file. In column D Forecast_Date is the column I want to apply the code to. I have added a command button I would like to click on to have the code run. If you double click in a cell under column D you will see there is a date stamp. No matter how I format it the date stamp remains. This is a small sample of many reports I pull in a day and have to review the data. Removing the date stamp quickly will make life so much easier for me. Thanks again for your help. On Thursday, July 11, 2013 10:37:12 AM UTC-5, Enrique Martin wrote: Please share your file mentioning all your requirements..I'll try.. On 7/8/13, srsev6 srs...@gmail.com wrote: Thank you Enrique. How do I set this up in a code to be able to use in a command button? I am familiar with codes in visual basic but not an expert by any means in writing them. On Wednesday, July 3, 2013 7:15:00 PM UTC-5, Enrique Martin wrote: you can use = text(cell,dd mmm ), this will give time in text format. On Thu, Jul 4, 2013 at 3:17 AM, srsev6 srs...@gmail.com javascript:wrote: Hi all, I have already posted this once but can not locate it so I apologize for the duplicate post. I hope someone can answer my question. I run dates out of a database which uses access. The dates I pull out have a timestamp. The timestamp hinders my formulas in my excel spreadsheets. I pull hundreds of dates at one time. Is there a macro I can use in a template that will remove the timestamp from the date on a range of cells so I don't have to keep using =int(cell)? I would like to create an excel template that has a command button I can click and run to remove the timestamp. Thank you all for your help. SRSEV6 -- 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/**discussexcelhttps://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-macroshttp://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/**groups/opt_outhttps://groups.google.com/groups/opt_out. -- Regards, Anoop Sr. Developer Facebook ID - https://www.facebook.com/**anooop.k.sharmahttps://www.facebook.com/anooop.k.sharma -- 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/**discussexcelhttps://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. To post to this group, send email to excel-...@googlegroups.com. Visit this group at
Re: $$Excel-Macros$$ Query in Pivot Table
use this formula in c2 =DATE(YEAR(B2),MONTH(B2),1) and fill it down then try to sort the columns of pivot table On Thu, Jul 11, 2013 at 6:36 PM, Waseem Saifi waseemsa...@gmail.com wrote: Dear Rakesh, please see attachment. in case of place months in ascending order. you have to do it manually. right click on any month and move it to left, right, to beginning or to end. Regards, Waseem Saifi On 7/11/13, Rakesh Kumar Sharma rakeshks@gmail.com wrote: Dear Experts, I have a query related to Pivot Table. Pls refer to attachment. -- Regards, Rakesh Kumar Sharma Contact: +91-9971024741 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- *Regards* * * *Ashish Koul* *Visit* *My Excel Blog http://www.excelvbamacros.com/* Like Us on Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897 Join Us on Facebook http://www.facebook.com/groups/163491717053198/ P Before printing, think about the environment. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ excel time tracking
check these templates http://office.microsoft.com/en-in/excel-help/use-the-excel-timecard-template-for-quick-and-easy-time-tracking-HA001113313.aspx http://www.citehr.com/344268-effective-attendance-tracker-2011-login-log-out.html http://office.microsoft.com/en-in/templates/employee-time-sheet-TC101877403.aspx Regards Ashish Koul On Thu, Jul 11, 2013 at 5:07 PM, Kannan Excel kannan.ex...@gmail.comwrote: hi friends, anybody have excel time tracking format?? i want to track my employee details in excel.. if i enter my employee id number means his it will come automatically pls send asap... regards Kannan V -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- *Regards* * * *Ashish Koul* *Visit* *My Excel Blog http://www.excelvbamacros.com/* Like Us on Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897 Join Us on Facebook http://www.facebook.com/groups/163491717053198/ P Before printing, think about the environment. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ Difference Between Iferror Iserror
visit the link http://www.professionalexcel.com/2011/06/replace-iferror-with-ifiserror/ On Thu, Jul 11, 2013 at 4:31 PM, Prafull Jadhav prafulltjad...@gmail.comwrote: both are same. in 2003 there was iferror and in 2007 it replaced by iserror. On Thu, Jul 11, 2013 at 4:09 PM, Raj Kumar rajlu...@gmail.com wrote: Hi Group, Kindly let us know the difference between Iserror iferror in excel Regards Raj Bharti -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- *Regards* * * *Ashish Koul* *Visit* *My Excel Blog http://www.excelvbamacros.com/* Like Us on Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897 Join Us on Facebook http://www.facebook.com/groups/163491717053198/ P Before printing, think about the environment. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
$$Excel-Macros$$ This Formula to span number of nights (from Date of Arrival to Date of Departure) not working!
Hi all, I recently posted a topic to solve an issue regarding the span of total number of nights spent in specific columns. The forum members were really helpful, particularly De Premor! Link is here: https://groups.google.com/forum/#!searchin/excel-macros/Formula$20to$20span$20number$20of$20nights|sort:relevance/excel-macros/zje07zleFUw/jE_2RFYKnO8J However, when I have added new dates in the columns, it seems the formula is behaving strangely. I am attaching the Excel file so that you can get an idea of the problem. The cells highlighted in yellow are the correct entries but the formula also fills the irrelevant columns with numbers. My data contains dates from July 2011 to June 2013...so I need the formula to work consistently for all the months mentioned in the columns. Can anyone help by pointing out how to modify the formula accordingly? -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. DOA.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Macro to remove a timestamp in a date
Thanks Ashish but the dates don't always fall in column D and are not always just two columns. How can I change this portion to search the entire sheet? I tried several options to no avail. For Each cl In Range(d2:d Range(d1048576).End(xlUp).Row) On Thursday, July 11, 2013 11:47:18 AM UTC-5, ashish wrote: try this Sub sample() Dim cl As Range For Each cl In Range(d2:d Range(d1048576).End(xlUp).Row) cl.NumberFormat = @ cl.Value = Application.WorksheetFunction.Text(cl.Value, dd mmm ) Next End Sub see if it helps On Thu, Jul 11, 2013 at 9:43 PM, srsev6 srs...@gmail.com javascript:wrote: Thanks for your help Enrique. I have attached the file. In column D Forecast_Date is the column I want to apply the code to. I have added a command button I would like to click on to have the code run. If you double click in a cell under column D you will see there is a date stamp. No matter how I format it the date stamp remains. This is a small sample of many reports I pull in a day and have to review the data. Removing the date stamp quickly will make life so much easier for me. Thanks again for your help. On Thursday, July 11, 2013 10:37:12 AM UTC-5, Enrique Martin wrote: Please share your file mentioning all your requirements..I'll try.. On 7/8/13, srsev6 srs...@gmail.com wrote: Thank you Enrique. How do I set this up in a code to be able to use in a command button? I am familiar with codes in visual basic but not an expert by any means in writing them. On Wednesday, July 3, 2013 7:15:00 PM UTC-5, Enrique Martin wrote: you can use = text(cell,dd mmm ), this will give time in text format. On Thu, Jul 4, 2013 at 3:17 AM, srsev6 srs...@gmail.com javascript:wrote: Hi all, I have already posted this once but can not locate it so I apologize for the duplicate post. I hope someone can answer my question. I run dates out of a database which uses access. The dates I pull out have a timestamp. The timestamp hinders my formulas in my excel spreadsheets. I pull hundreds of dates at one time. Is there a macro I can use in a template that will remove the timestamp from the date on a range of cells so I don't have to keep using =int(cell)? I would like to create an excel template that has a command button I can click and run to remove the timestamp. Thank you all for your help. SRSEV6 -- 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/**discussexcelhttps://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-macroshttp://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/**groups/opt_outhttps://groups.google.com/groups/opt_out. -- Regards, Anoop Sr. Developer Facebook ID - https://www.facebook.com/**anooop.k.sharmahttps://www.facebook.com/anooop.k.sharma -- 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/**discussexcelhttps://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.
$$Excel-Macros$$ pulling data from a validation list
How do i pull values from a validation list ? i am trying to do a simple nutritional planer. i have a list contaning nutiotional contains of different foods pr. 100g so lets say that i use data validation to create a dropdown and i click apple i want to pull the remaining information which is also in the sheet into rows Amount I Kcal I Fat I Carbs I Protein ect. so that i can put in the amount and it will calculate the rest this is a pretty basic thing, i know and yes there are lot Vlookup examples on the net but i cant get it to work so i need a detailed answer 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/groups/opt_out.
Re: $$Excel-Macros$$ Macro to remove a timestamp in a date
Try this, this will search a whole used range in sheet, that will be very slow if you have a big data *Private Sub CommandButton1_Click()** **Dim Rng As Range** **For Each Rng In ActiveSheet.UsedRange** **If IsDate(Rng.Value) Then Rng.Value = Format(Rng.Value, dd mmm )** **Next** **End Sub* Rgds, [dp] Pada 12/07/2013 1:45, srsev6 menulis: Thanks Ashish but the dates don't always fall in column D and are not always just two columns. How can I change this portion to search the entire sheet? I tried several options to no avail. For Each cl In Range(d2:d Range(d1048576).End(xlUp).Row) On Thursday, July 11, 2013 11:47:18 AM UTC-5, ashish wrote: try this Sub sample() Dim cl As Range For Each cl In Range(d2:d Range(d1048576).End(xlUp).Row) cl.NumberFormat = @ cl.Value = Application.WorksheetFunction.Text(cl.Value, dd mmm ) Next End Sub see if it helps On Thu, Jul 11, 2013 at 9:43 PM, srsev6 srs...@gmail.com javascript: wrote: Thanks for your help Enrique. I have attached the file. In column D Forecast_Date is the column I want to apply the code to. I have added a command button I would like to click on to have the code run. If you double click in a cell under column D you will see there is a date stamp. No matter how I format it the date stamp remains. This is a small sample of many reports I pull in a day and have to review the data. Removing the date stamp quickly will make life so much easier for me. Thanks again for your help. On Thursday, July 11, 2013 10:37:12 AM UTC-5, Enrique Martin wrote: Please share your file mentioning all your requirements..I'll try.. On 7/8/13, srsev6 srs...@gmail.com wrote: Thank you Enrique. How do I set this up in a code to be able to use in a command button? I am familiar with codes in visual basic but not an expert by any means in writing them. On Wednesday, July 3, 2013 7:15:00 PM UTC-5, Enrique Martin wrote: you can use = text(cell,dd mmm ), this will give time in text format. On Thu, Jul 4, 2013 at 3:17 AM, srsev6 srs...@gmail.com javascript:wrote: Hi all, I have already posted this once but can not locate it so I apologize for the duplicate post. I hope someone can answer my question. I run dates out of a database which uses access. The dates I pull out have a timestamp. The timestamp hinders my formulas in my excel spreadsheets. I pull hundreds of dates at one time. Is there a macro I can use in a template that will remove the timestamp from the date on a range of cells so I don't have to keep using =int(cell)? I would like to create an excel template that has a command button I can click and run to remove the timestamp. Thank you all for your help. SRSEV6 -- 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 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
Re: $$Excel-Macros$$ This Formula to span number of nights (from Date of Arrival to Date of Departure) not working!
Hi Ali, Its me Again :-D There is only 1 mistake in your new formulas For Example (See the cell i've Bold) =IF($B2$I2,Error Input,IF(TEXT(U$1,ymm)=TEXT($B2,ymm),IF(TEXT(U$1,ymm)=TEXT($I2,ymm),$I2-1,U$1)-$B2+1,IF(TEXT(U$1,ymm)=TEXT($I2,ymm),DAY($I2)-1,IF(AND(TEXT(U$1,ymm)TEXT(*$K2*,ymm),TEXT(U$1,ymm)TEXT($I2,ymm)),DAY(U$1),0 That should be *$B2 not $K2* Rgds, [dp] Pada 12/07/2013 0:16, Ali menulis: Hi all, I recently posted a topic to solve an issue regarding the span of total number of nights spent in specific columns. The forum members were really helpful, particularly De Premor! Link is here: https://groups.google.com/forum/#!searchin/excel-macros/Formula$20to$20span$20number$20of$20nights|sort:relevance/excel-macros/zje07zleFUw/jE_2RFYKnO8J https://groups.google.com/forum/#%21searchin/excel-macros/Formula$20to$20span$20number$20of$20nights%7Csort:relevance/excel-macros/zje07zleFUw/jE_2RFYKnO8J However, when I have added new dates in the columns, it seems the formula is behaving strangely. I am attaching the Excel file so that you can get an idea of the problem. The cells highlighted in yellow are the correct entries but the formula also fills the irrelevant columns with numbers. My data contains dates from July 2011 to June 2013...so I need the formula to work consistently for all the months mentioned in the columns. Can anyone help by pointing out how to modify the formula accordingly? -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. DOA-1.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Macro to remove a timestamp in a date
WOW!! Look at all these wonderful people coming to my aid. Thank you all so much for your help. DP this formula worked well except that it put a 1/0/1900 date in all my blank cells. I used part of Ashish's formulas to keep that from happening and now your code works perfectly. Private Sub CommandButton1_Click() Dim Rng As Range For Each Rng In ActiveSheet.UsedRange *Rng.NumberFormat = mm/dd/* If IsDate(Rng.Value) Then Rng.Value = Format(Rng.Value, mm/dd/) Next End Sub All of you are so wonderful (Enrique, Ashish, and DP) and saved me so much time. I can't thank you enough. Thank you Thank you Thank you Thank you Thank you On Thursday, July 11, 2013 3:39:08 PM UTC-5, De Premor wrote: Try this, this will search a whole used range in sheet, that will be very slow if you have a big data *Private Sub CommandButton1_Click()** **Dim Rng As Range** **For Each Rng In ActiveSheet.UsedRange** **If IsDate(Rng.Value) Then Rng.Value = Format(Rng.Value, dd mmm )** **Next** **End Sub* Rgds, [dp] Pada 12/07/2013 1:45, srsev6 menulis: Thanks Ashish but the dates don't always fall in column D and are not always just two columns. How can I change this portion to search the entire sheet? I tried several options to no avail. For Each cl In Range(d2:d Range(d1048576).End(xlUp).Row) On Thursday, July 11, 2013 11:47:18 AM UTC-5, ashish wrote: try this Sub sample() Dim cl As Range For Each cl In Range(d2:d Range(d1048576).End(xlUp).Row) cl.NumberFormat = @ cl.Value = Application.WorksheetFunction.Text(cl.Value, dd mmm ) Next End Sub see if it helps On Thu, Jul 11, 2013 at 9:43 PM, srsev6 srs...@gmail.com wrote: Thanks for your help Enrique. I have attached the file. In column D Forecast_Date is the column I want to apply the code to. I have added a command button I would like to click on to have the code run. If you double click in a cell under column D you will see there is a date stamp. No matter how I format it the date stamp remains. This is a small sample of many reports I pull in a day and have to review the data. Removing the date stamp quickly will make life so much easier for me. Thanks again for your help. On Thursday, July 11, 2013 10:37:12 AM UTC-5, Enrique Martin wrote: Please share your file mentioning all your requirements..I'll try.. On 7/8/13, srsev6 srs...@gmail.com wrote: Thank you Enrique. How do I set this up in a code to be able to use in a command button? I am familiar with codes in visual basic but not an expert by any means in writing them. On Wednesday, July 3, 2013 7:15:00 PM UTC-5, Enrique Martin wrote: you can use = text(cell,dd mmm ), this will give time in text format. On Thu, Jul 4, 2013 at 3:17 AM, srsev6 srs...@gmail.com javascript:wrote: Hi all, I have already posted this once but can not locate it so I apologize for the duplicate post. I hope someone can answer my question. I run dates out of a database which uses access. The dates I pull out have a timestamp. The timestamp hinders my formulas in my excel spreadsheets. I pull hundreds of dates at one time. Is there a macro I can use in a template that will remove the timestamp from the date on a range of cells so I don't have to keep using =int(cell)? I would like to create an excel template that has a command button I can click and run to remove the timestamp. Thank you all for your help. SRSEV6 -- 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.comjavascript: . Visit this group at http://groups.google.com/group/excel-macros. For more
Re: $$Excel-Macros$$ Help Needed
HI DP many thanks for the solution..for my query and its working and serving my purpose 100% thanks Patil M G On Wed, Jul 10, 2013 at 7:22 PM, De Premor d...@premor.net wrote: Hi Patil, PFA Please Run Procedure named *GenerateFromTemplate * Rgds, [dp]* * Pada 10/07/2013 18:30, Patil MG menulis: HI Experts this was my previous Question 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 for my above query i got a solution from Paul.please find the attached Xls files (INPUT FILE FORMAT and Output Format (Solution) now my question is can we do this visa verse i mean im attaching another 2 Excel files - Sample Input File - 34 Sample OUT Put File - Form Book 34 I want solution for Sample Input File - 34 like Sample OUT Put File - Form Book 34 could you please help me to generate macro or is their any other solution ( formula) to over come this problem On Wed, Jun 5, 2013 at 6:50 PM, Patil MG mailpati...@gmail.com 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. -- 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. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and
Re: $$Excel-Macros$$ Macro to remove a timestamp in a date
You're welcome, We're happy to hear that your problem solved. But we have one problem here, 1/0/1900 is not a date, we will never meet that case in real world If i ask to you, What month before January ? That should be December, and that month is 12 not Zero ;-) Rgds, [dp] Pada 12/07/2013 5:42, srsev6 menulis: WOW!! Look at all these wonderful people coming to my aid. Thank you all so much for your help. DP this formula worked well except that it put a 1/0/1900 date in all my blank cells. I used part of Ashish's formulas to keep that from happening and now your code works perfectly. Private Sub CommandButton1_Click() Dim Rng As Range For Each Rng In ActiveSheet.UsedRange *Rng.NumberFormat = mm/dd/* If IsDate(Rng.Value) Then Rng.Value = Format(Rng.Value, mm/dd/) Next End Sub All of you are so wonderful (Enrique, Ashish, and DP) and saved me so much time. I can't thank you enough. Thank you Thank you Thank you Thank you Thank you On Thursday, July 11, 2013 3:39:08 PM UTC-5, De Premor wrote: Try this, this will search a whole used range in sheet, that will be very slow if you have a big data *Private Sub CommandButton1_Click()** **Dim Rng As Range** **For Each Rng In ActiveSheet.UsedRange** **If IsDate(Rng.Value) Then Rng.Value = Format(Rng.Value, dd mmm )** **Next** **End Sub* Rgds, [dp] Pada 12/07/2013 1:45, srsev6 menulis: Thanks Ashish but the dates don't always fall in column D and are not always just two columns. How can I change this portion to search the entire sheet? I tried several options to no avail. For Each cl In Range(d2:d Range(d1048576).End(xlUp).Row) On Thursday, July 11, 2013 11:47:18 AM UTC-5, ashish wrote: try this Sub sample() Dim cl As Range For Each cl In Range(d2:d Range(d1048576).End(xlUp).Row) cl.NumberFormat = @ cl.Value = Application.WorksheetFunction.Text(cl.Value, dd mmm ) Next End Sub see if it helps On Thu, Jul 11, 2013 at 9:43 PM, srsev6 srs...@gmail.com wrote: Thanks for your help Enrique. I have attached the file. In column D Forecast_Date is the column I want to apply the code to. I have added a command button I would like to click on to have the code run. If you double click in a cell under column D you will see there is a date stamp. No matter how I format it the date stamp remains. This is a small sample of many reports I pull in a day and have to review the data. Removing the date stamp quickly will make life so much easier for me. Thanks again for your help. On Thursday, July 11, 2013 10:37:12 AM UTC-5, Enrique Martin wrote: Please share your file mentioning all your requirements..I'll try.. On 7/8/13, srsev6 srs...@gmail.com wrote: Thank you Enrique. How do I set this up in a code to be able to use in a command button? I am familiar with codes in visual basic but not an expert by any means in writing them. On Wednesday, July 3, 2013 7:15:00 PM UTC-5, Enrique Martin wrote: you can use = text(cell,dd mmm ), this will give time in text format. On Thu, Jul 4, 2013 at 3:17 AM, srsev6 srs...@gmail.com javascript:wrote: Hi all, I have already posted this once but can not locate it so I apologize for the duplicate post. I hope someone can answer my question. I run dates out of a database which uses access. The dates I pull out have a timestamp. The timestamp hinders my formulas in my excel spreadsheets. I pull hundreds of dates at one time. Is there a macro I can use in a template that will remove the timestamp from the date on a range of cells so I don't have to keep using =int(cell)? I would like to create an excel template that has a command button I can click and run to remove the timestamp. Thank you all for your help.
$$Excel-Macros$$ SEARCH OPTION DOUBT
hi, pls find the attached file, 2nd sheet is master data... 1st sheet is searching data... if i enter employee id in 1st sheet 2nd sheet data want to come automatically... pls do the needful urgent base regards Kannan -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. TEST1.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
