Re: $$Excel-Macros$$ VBA code for convert numbers (RS to USD AED to USD)
Dear champs Above as per my explanation one thing remember that conversion rate is MY RATE which is mention in sheet.As per my requirement it will be change.so Pls fix that cell in vba code then i will change whenever possible. I would appreciate very much if someone can help me on this. Thank you Amar On Sat, Oct 25, 2014 at 10:41 AM, amar takale amartak...@gmail.com wrote: Dear Excel Champs I required VBA code for numbers convert in column.here are attached sheet 1) In Main (INR) sheet there are tab INR to USD,If I click that button then all numbers (column D to I) convert Rs to usd which is extract from Raw (INR) sheet.this is link numbers from Raw (INR) so pls provide me that code it button must put in Main (INR) sheet not in raw sheet. Converstion code direct convert numbers in Main (INR) which is link numbers 2) same process for Main (AED) as per above explanation. So pls help me on that issue asap. Regards Amar -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ VBA code for convert numbers (RS to USD AED to USD)
Need more explanation... in your first sheet there are many number and link each other. so explain more. On Sat, Oct 25, 2014 at 11:48 AM, amar takale amartak...@gmail.com wrote: Dear champs Above as per my explanation one thing remember that conversion rate is MY RATE which is mention in sheet.As per my requirement it will be change.so Pls fix that cell in vba code then i will change whenever possible. I would appreciate very much if someone can help me on this. Thank you Amar On Sat, Oct 25, 2014 at 10:41 AM, amar takale amartak...@gmail.com wrote: Dear Excel Champs I required VBA code for numbers convert in column.here are attached sheet 1) In Main (INR) sheet there are tab INR to USD,If I click that button then all numbers (column D to I) convert Rs to usd which is extract from Raw (INR) sheet.this is link numbers from Raw (INR) so pls provide me that code it button must put in Main (INR) sheet not in raw sheet. Converstion code direct convert numbers in Main (INR) which is link numbers 2) same process for Main (AED) as per above explanation. So pls help me on that issue asap. Regards Amar -- 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. -- PramodSingh -- 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$$ VBA code for convert numbers (RS to USD AED to USD)
Dear Pramod In sample sheet there are in both main sheet which is linked data from raw sheet thats links numbers are only converted. Regards Amar On Sat, Oct 25, 2014 at 12:19 PM, Pramod Singh pramod...@gmail.com wrote: Need more explanation... in your first sheet there are many number and link each other. so explain more. On Sat, Oct 25, 2014 at 11:48 AM, amar takale amartak...@gmail.com wrote: Dear champs Above as per my explanation one thing remember that conversion rate is MY RATE which is mention in sheet.As per my requirement it will be change.so Pls fix that cell in vba code then i will change whenever possible. I would appreciate very much if someone can help me on this. Thank you Amar On Sat, Oct 25, 2014 at 10:41 AM, amar takale amartak...@gmail.com wrote: Dear Excel Champs I required VBA code for numbers convert in column.here are attached sheet 1) In Main (INR) sheet there are tab INR to USD,If I click that button then all numbers (column D to I) convert Rs to usd which is extract from Raw (INR) sheet.this is link numbers from Raw (INR) so pls provide me that code it button must put in Main (INR) sheet not in raw sheet. Converstion code direct convert numbers in Main (INR) which is link numbers 2) same process for Main (AED) as per above explanation. So pls help me on that issue asap. Regards Amar -- 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. -- PramodSingh -- 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
Re: $$Excel-Macros$$ Happy Diwali
Very happy Diwali and prosperous new year to all friends.. On Oct 25, 2014 10:39 AM, amar takale amartak...@gmail.com wrote: Dear All excel champs Wishing you a very happy and prosperous Diwali to all my friends. Regards Amar -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Please help on VBA- adjustments of a table with data
Hi ivavok , Please find the attached file as per your requirement... On Fri, Oct 24, 2014 at 5:31 PM, ivavok ivana.vokrouhlik...@gmail.com wrote: Hello, I would be grateful for help. I have had some break using VBA and I now need to get the table attached adjusted in a certain way to be able to work with it later on: 1/ keep the first row with headings 2/ insert a new column after the first column and name it: Type 3/ always take the content /text/ of the middle blue row (here: Home/Rent and Utilities) and put it into the new column for each row until you reach another Type and always then delete this row. 4/ delete column named Payee 5/ transform format of cells of the column named Amount into numbers so that I can do calculation with this..I guess the currency has to be deleted or it can be kept as Accounting format but the main issue is that it has to be a number to be worked on later (in a pivot table). I have attached two files- data is the primary source. data_final is the aim;) Thank you very much for your help Ivana -- 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. -- PramodSingh -- 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. data_final.xlsb Description: application/vnd.ms-excel.sheet.binary.macroenabled.12
$$Excel-Macros$$ Automatic update excel file from website
Dear Excel Gurus, I am trying to update my excel sheet which contains the TIN number of some of the registered tax payers with their contact details and address. I can do it manually by putting the TIN number in the below mentioned website and then copy paste the details in the excel file. But is there any way to do it automatically with the help of macros / VBA??? https://www.odishatreasury.gov.in/echallan/ChallanSubmission.do?deptcode=COM In the above mentioned website if you put the TIN number (for e.g. 21031209766) then it will give the details and can I make it an automatically copy paste the data in my excel sheet??? Can it be possible with web query??? Please help .. BS -- 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$$ VBA code for convert numbers (RS to USD AED to USD)
Hi Amar, After change value. link should remove and paste value multiply with conversion.?? Regards Pramod On Sat, Oct 25, 2014 at 12:29 PM, amar takale amartak...@gmail.com wrote: Dear Pramod In sample sheet there are in both main sheet which is linked data from raw sheet thats links numbers are only converted. Regards Amar On Sat, Oct 25, 2014 at 12:19 PM, Pramod Singh pramod...@gmail.com wrote: Need more explanation... in your first sheet there are many number and link each other. so explain more. On Sat, Oct 25, 2014 at 11:48 AM, amar takale amartak...@gmail.com wrote: Dear champs Above as per my explanation one thing remember that conversion rate is MY RATE which is mention in sheet.As per my requirement it will be change.so Pls fix that cell in vba code then i will change whenever possible. I would appreciate very much if someone can help me on this. Thank you Amar On Sat, Oct 25, 2014 at 10:41 AM, amar takale amartak...@gmail.com wrote: Dear Excel Champs I required VBA code for numbers convert in column.here are attached sheet 1) In Main (INR) sheet there are tab INR to USD,If I click that button then all numbers (column D to I) convert Rs to usd which is extract from Raw (INR) sheet.this is link numbers from Raw (INR) so pls provide me that code it button must put in Main (INR) sheet not in raw sheet. Converstion code direct convert numbers in Main (INR) which is link numbers 2) same process for Main (AED) as per above explanation. So pls help me on that issue asap. Regards Amar -- 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. -- PramodSingh -- 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
Re: $$Excel-Macros$$ VBA code for convert numbers (RS to USD AED to USD)
If link value paste special value then it not useful for me. On Sat, Oct 25, 2014 at 2:29 PM, Pramod Singh pramod...@gmail.com wrote: Hi Amar, After change value. link should remove and paste value multiply with conversion.?? Regards Pramod On Sat, Oct 25, 2014 at 12:29 PM, amar takale amartak...@gmail.com wrote: Dear Pramod In sample sheet there are in both main sheet which is linked data from raw sheet thats links numbers are only converted. Regards Amar On Sat, Oct 25, 2014 at 12:19 PM, Pramod Singh pramod...@gmail.com wrote: Need more explanation... in your first sheet there are many number and link each other. so explain more. On Sat, Oct 25, 2014 at 11:48 AM, amar takale amartak...@gmail.com wrote: Dear champs Above as per my explanation one thing remember that conversion rate is MY RATE which is mention in sheet.As per my requirement it will be change.so Pls fix that cell in vba code then i will change whenever possible. I would appreciate very much if someone can help me on this. Thank you Amar On Sat, Oct 25, 2014 at 10:41 AM, amar takale amartak...@gmail.com wrote: Dear Excel Champs I required VBA code for numbers convert in column.here are attached sheet 1) In Main (INR) sheet there are tab INR to USD,If I click that button then all numbers (column D to I) convert Rs to usd which is extract from Raw (INR) sheet.this is link numbers from Raw (INR) so pls provide me that code it button must put in Main (INR) sheet not in raw sheet. Converstion code direct convert numbers in Main (INR) which is link numbers 2) same process for Main (AED) as per above explanation. So pls help me on that issue asap. Regards Amar -- 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. -- PramodSingh -- 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.
Re: $$Excel-Macros$$ VBA code for convert numbers (RS to USD AED to USD)
Hi Amar, Please find the attached file as per your requirement. On Sat, Oct 25, 2014 at 2:29 PM, Pramod Singh pramod...@gmail.com wrote: Hi Amar, After change value. link should remove and paste value multiply with conversion.?? Regards Pramod On Sat, Oct 25, 2014 at 12:29 PM, amar takale amartak...@gmail.com wrote: Dear Pramod In sample sheet there are in both main sheet which is linked data from raw sheet thats links numbers are only converted. Regards Amar On Sat, Oct 25, 2014 at 12:19 PM, Pramod Singh pramod...@gmail.com wrote: Need more explanation... in your first sheet there are many number and link each other. so explain more. On Sat, Oct 25, 2014 at 11:48 AM, amar takale amartak...@gmail.com wrote: Dear champs Above as per my explanation one thing remember that conversion rate is MY RATE which is mention in sheet.As per my requirement it will be change.so Pls fix that cell in vba code then i will change whenever possible. I would appreciate very much if someone can help me on this. Thank you Amar On Sat, Oct 25, 2014 at 10:41 AM, amar takale amartak...@gmail.com wrote: Dear Excel Champs I required VBA code for numbers convert in column.here are attached sheet 1) In Main (INR) sheet there are tab INR to USD,If I click that button then all numbers (column D to I) convert Rs to usd which is extract from Raw (INR) sheet.this is link numbers from Raw (INR) so pls provide me that code it button must put in Main (INR) sheet not in raw sheet. Converstion code direct convert numbers in Main (INR) which is link numbers 2) same process for Main (AED) as per above explanation. So pls help me on that issue asap. Regards Amar -- 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. -- PramodSingh -- 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
Re: $$Excel-Macros$$ VBA code for convert numbers (RS to USD AED to USD)
Dear Pramod Thanks very much brother I will check it revert back you Regards Amar On Sat, Oct 25, 2014 at 2:49 PM, Pramod Singh pramod...@gmail.com wrote: Hi Amar, Please find the attached file as per your requirement. On Sat, Oct 25, 2014 at 2:29 PM, Pramod Singh pramod...@gmail.com wrote: Hi Amar, After change value. link should remove and paste value multiply with conversion.?? Regards Pramod On Sat, Oct 25, 2014 at 12:29 PM, amar takale amartak...@gmail.com wrote: Dear Pramod In sample sheet there are in both main sheet which is linked data from raw sheet thats links numbers are only converted. Regards Amar On Sat, Oct 25, 2014 at 12:19 PM, Pramod Singh pramod...@gmail.com wrote: Need more explanation... in your first sheet there are many number and link each other. so explain more. On Sat, Oct 25, 2014 at 11:48 AM, amar takale amartak...@gmail.com wrote: Dear champs Above as per my explanation one thing remember that conversion rate is MY RATE which is mention in sheet.As per my requirement it will be change.so Pls fix that cell in vba code then i will change whenever possible. I would appreciate very much if someone can help me on this. Thank you Amar On Sat, Oct 25, 2014 at 10:41 AM, amar takale amartak...@gmail.com wrote: Dear Excel Champs I required VBA code for numbers convert in column.here are attached sheet 1) In Main (INR) sheet there are tab INR to USD,If I click that button then all numbers (column D to I) convert Rs to usd which is extract from Raw (INR) sheet.this is link numbers from Raw (INR) so pls provide me that code it button must put in Main (INR) sheet not in raw sheet. Converstion code direct convert numbers in Main (INR) which is link numbers 2) same process for Main (AED) as per above explanation. So pls help me on that issue asap. Regards Amar -- 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. -- PramodSingh -- 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,
Re: $$Excel-Macros$$ Automatic update excel file from website
Share the with excel file ... which text / details you want extract... On Sat, Oct 25, 2014 at 2:17 PM, B Sharma sharma@gmail.com wrote: Dear Excel Gurus, I am trying to update my excel sheet which contains the TIN number of some of the registered tax payers with their contact details and address. I can do it manually by putting the TIN number in the below mentioned website and then copy paste the details in the excel file. But is there any way to do it automatically with the help of macros / VBA??? https://www.odishatreasury.gov.in/echallan/ChallanSubmission.do?deptcode=COM In the above mentioned website if you put the TIN number (for e.g. 21031209766) then it will give the details and can I make it an automatically copy paste the data in my excel sheet??? Can it be possible with web query??? Please help .. BS -- 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. -- PramodSingh -- 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$$ Produce CSV file as a output file by using the values/Data's from the Excel worksheet
Dear guru's, Still am waiting for your valuable comments..pls help me. Regards, Lax -- 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$$ MIS Executive
Hi All i am search job for Sr. MIS Executive any jop please sent me. anilmaurya...@gmail.com Thanks Regards Anil Kumar Maurya Mob. 8882545343 -- 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. AnilResume.doc Description: MS-Word document
$$Excel-Macros$$ Produce CSV file as a output file by using the values/Data's from the Excel worksheet
Pls help me.. -- 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$$ Produce CSV file as a output file by using the values/Data's from the Excel worksheet
hi can you explain how data is fetched for this 2.. For w12 W13??? + *I did not do this for you. God is here working through me for you.* On Sat, Oct 25, 2014 at 9:15 PM, Laxmanan M laxflyflow...@gmail.com wrote: Pls help me.. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Produce CSV file as a output file by using the values/Data's from the Excel worksheet
Hi Laxman Can you save all data in one file. And then explain which is ur input tab. And how is your output Need more explain. Pramod On 25 Oct 2014 21:15, Laxmanan M laxflyflow...@gmail.com wrote: Pls help me.. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Re: How can one control data entry and truly protect a verified entry
Color me confused. SheetSelectionChange event? where? This is a typical input i have: CODE B_n:Cells(Frow, Fcol).Select' force location Tytle = Enter charges: Avar = Application.InputBox(Tytle) ' returns type text If Avar = FALSE Then GoTo B_n ActiveCell.FormulaR1C1 = Val(Avar) Chrg = Val(Avar): ColChg = ColChg + Chrg Fcol = Fcol + 1 '$C$9 \CODE I control Frow and Fcol,which does the locking i wanted,as user cannot do anything except input data exactly where i want. I save the row data at the end, and give options at the start for what is next. Now,it would be useful to be able to position that input box, as well as change the font of the text in the box. And, i think lastly, have the app automatically run when the XLS program is launched. Thanks, Robert Baer PS: have yet to test the FALSE part (ie: one clicks on Cancel in the input box. On Wednesday, October 22, 2014 11:41:41 AM UTC-7, Paul Schreiner wrote: I hate to throw a wrench into the monkeyworks, but: you were trying to use the SheetSelectionChange event. which actually runs for ANY sheet in your workbook, not just a specific sheet. which might be a bit confusing if you have multiple sheets, and you're using the event macro to lock the cells, then it would actually lock the cells the other sheets as well.. Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range) If you only want the macro to run on a specific sheet, you can either test the Sh object for the sheet name. Or you can create a similar event macro in the sheet module called: Private Sub Worksheet_SelectionChange(ByVal Target As Range) Next, if you're wanting to lock cells A1:P9, you could use something like: Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range) Dim Targ As Range For Each Targ In Target If (Not Intersect(Targ, Sh.Range(A1:P8)) Is Nothing) Then Sh.Range(A9).Select Exit For End If Next Targ End Sub One thing I've run into is that if you select multiple cells, the Target variable becomes an array instead of a simple object. So I use the Targ variable to loop through the Target selection array. This works if you select a single cell or multiple. In this case, I look for the intersection of the selected cell and the locked range. If the cell is within the blocked range, it returns the range. (or Not nothing) in which case I selce another cell (which, incidentally calls this event again) The nice thing about this is that if you wish to change the values of the blocked cells using VBA, you don't actually select the cell, you simply have to use something like: Range(A2).value = Test something else you need to be aware of is that the Target variable a range variable, but the address is in absolute terms. That is, if you select cell A9, Target.Address is $A$9 So, if you want to test to see if the selected cell is A9, you could use either: If (Targ.Address = $A$9) then or even: If (Targ.Row = 9) and (Targ.Column = 1) then *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:* Robert Baer robertg...@gmail.com javascript: *To:* excel-...@googlegroups.com javascript: *Sent:* Wednesday, October 22, 2014 12:57 PM *Subject:* Re: $$Excel-Macros$$ Re: How can one control data entry and truly protect a verified entry WOW! That works! Thanks a lot! Attempted to try: Private Sub Workbook_SheetSelectionChange(ByVal WkSh As Object, ByVal AmAt As Excel.Range) ' Supposedly runs when a sheet selection (cell?) is changed. whatName = WkSh.Name: wheregot = AmAt If wheregot CellLoc Then X = X ' set as a breakpont; NEVER happens End If End Sub ..which never executed, so that idea was DOA. The Application.InputBox() is perfect. Thanks again. On Wednesday, October 22, 2014 2:00:11 AM UTC-7, Vabz wrote: you can use this to work on VBA Sub RB() Dim Avar As String, Nvar As Long Dim Frow As Integer, Fcol As Integer ' Start row data entry Frow = 9: Fcol = 1 ' aka A Cells(Frow, Fcol).Select Avar = Application.InputBox(Enter value!!, Type:=3) ' want to wait for user entry; obviously i now have a wait working, BUT. ' stays in this loop forever; user CANNOT enter anything! ActiveCell.FormulaR1C1 = UCase$(Avar) Fcol = Fcol + 1 'now $B$9 Nvar = 0 While Nvar = 0 Nvar = ActiveCell.FormulaR1C1 ' check alfa? Wend End Sub + *I did not do this for you. God is here working through me for you.* On Tue, Oct 21, 2014 at
Re: $$Excel-Macros$$ Please help on VBA- adjustments of a table with data
Hi pramodb35, Thank you very much for your help! It is almost perfect;) Please have a look at the file attached. I have tried it for more rows for each type and it does not work correctly in that case:( The type is then not correctly copied in each row of column type. I cannot figure out what should be changed. The second thing is that I am sorry in my data file, there are figures with no space between thousands, however, there is (for example 3 000,00 EUR instead of 3000,00 EUR). Moreover, when I use the suggested macro, zeros after a decimal comma are deleted and then the number becomes higher;) e.g. 3000,00 EUR is finally 30 EUR;) I would be really grateful if you could help me with these updates too.. Thank you in advance! Ivana Dne sobota, 25. října 2014 10:08:50 UTC+2 pramodb35 napsal(a): Hi ivavok , Please find the attached file as per your requirement... On Fri, Oct 24, 2014 at 5:31 PM, ivavok ivana.vok...@gmail.com javascript: wrote: Hello, I would be grateful for help. I have had some break using VBA and I now need to get the table attached adjusted in a certain way to be able to work with it later on: 1/ keep the first row with headings 2/ insert a new column after the first column and name it: Type 3/ always take the content /text/ of the middle blue row (here: Home/Rent and Utilities) and put it into the new column for each row until you reach another Type and always then delete this row. 4/ delete column named Payee 5/ transform format of cells of the column named Amount into numbers so that I can do calculation with this..I guess the currency has to be deleted or it can be kept as Accounting format but the main issue is that it has to be a number to be worked on later (in a pivot table). I have attached two files- data is the primary source. data_final is the aim;) Thank you very much for your help Ivana -- 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. -- PramodSingh -- 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. data_final.xlsb Description: application/vnd.ms-excel.sheet.binary.macroenabled.12
$$Excel-Macros$$ Macro needed to move multiple choice questions into an excel row with a fixed format
Hi all, I need to convert multiple choice questions into a rows in an excel file in a fixed format. . The file currently looks like this: Column A 1. Question1 goes here a. Answer 1 b. Answer 2 *c. Answer 3 - the * indicates this is the correct answer d. Answer 4 2. Question2 goes here *a. Answer 1 b. Answer 2 c. Answer 3 d. Answer 4 I would like to use a macro to somehow convert these items (there are 50-70 on each worksheet and i have 14 worksheets) into this: AB C D E F G HI J MC Question1 Answer 1 Incorrect Answer 2 Incorrect Answer 3 Correct Answer 4 Incorrect MC Question2 Answer 1 Correct Answer 2 Incorrect Answer 3 Incorrect Answer 4 Incorrect Note the format adds MC to column A. other changes: - the questions are no longer numbered - the answers are not longer labeled with letter choices - the the column after each answer indicates if the answer is Correct or Incorrect - the * is removed from the correct choice. I can record a macro for one sheet that would work for the others, but that would take a long time and I am certain that you folks can find a far more efficient and elegant macro for a problem like this. Thanks In Advance! Noam -- 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$$ Produce CSV file as a output file by using the values/Data's from the Excel worksheet
Hi pramod and vabz, Thanks for the help. Here I have give the file sample datais the data file and we can apply the code in the same file.the format file is just the output file data format means the output file should have the data's in the same format of the format.this file should save as .csv extension of the macro ran file. Simply saying that the data's of the sample file should save as a .csv output file with format of format file attached in the same post. Thanks, Lax -- 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$$ Produce CSV file as a output file by using the values/Data's from the Excel worksheet
Check this... Click blue button to run macro.. When prompted select month name in data sheet, in your case it will be cell AP3 (cell highlighted with green color for current example, you can select any other month too) you will get output file as desired.. Note, i have kept same file / sheet name in my code you may need to amend it as you needed... Cheers!! + *I did not do this for you. God is here working through me for you.* On Sun, Oct 26, 2014 at 12:15 AM, Laxmanan M laxflyflow...@gmail.com wrote: Hi pramod and vabz, Thanks for the help. Here I have give the file sample datais the data file and we can apply the code in the same file.the format file is just the output file data format means the output file should have the data's in the same format of the format.this file should save as .csv extension of the macro ran file. Simply saying that the data's of the sample file should save as a .csv output file with format of format file attached in the same post. Thanks, Lax -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. Sample Data.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Need Help - How to Move multiple worksheets by Tab COlor
what exactly you are trying to achieve? + *I did not do this for you. God is here working through me for you.* On Fri, Oct 24, 2014 at 8:46 PM, Nilkanth Raval nilkanth.ra...@gmail.com wrote: Dear Sir, I need your help in Moving Multiple worksheets by tab color. I write the below code, but gives me an error. Please help me. Sub MoveSheetsbyTabcolor() Dim wsNames() As String Dim wsColor() As Integer Dim ws As Worksheet Dim ind As Integer Dim Oldwkb As Workbook Set Oldwkb = ActiveWorkbook Dim wkb As Workbook Set wkb = Workbooks.Add Oldwkb.Activate ReDim wsNames(0) ReDim wsColor(0) wsNames(0) = ActiveSheet.Name wsColor(0) = ActiveSheet.Tab.ColorIndex For Each ws In ThisWorkbook.Sheets If ws.Tab.ColorIndex = wsColor(0) And ws.Visible = xlSheetVisible Then ReDim Preserve wsNames(UBound(wsNames) + 1) ReDim Preserve wsColor(UBound(wsColor) + 1) wsNames(UBound(wsNames)) = ws.Name wsColor(UBound(wsColor)) = ws.Tab.ColorIndex End If Next ws Sheets(wsNames).Select Sheets(wsNames).Copy After:=wkb.Worksheets(wkb.Worksheets.Count) Call Delete_Empty_Sheets Set wkb = Nothing Set Oldwkb = Nothing ActiveSheet.Select End Sub *Thanks,* *Nilkanth Raval* *Think Before You Print.Consider ENVIRONMENT.* *“SAVE TREES, SAVE EARTH” * *“All appears to change when we change!”* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ automatically expanding stock/forex prices
can you share you existing code with sample input data output data.. + *I did not do this for you. God is here working through me for you.* On Fri, Oct 24, 2014 at 1:41 AM, paidtosignups1 paidtosign...@gmail.com wrote: How do you do an excel spreadsheet, where each new price of a stock /forex appears every 5 seconds, it doesn't update current price, but rather moves down one cell in the same colum and enters that new price. For example. it is january 1, 00:00:00 hours we have no record, then at at 00:00:05 the price is automatically appears (or I manually refresh) in cell A1. Then 5 seconds later the new price apears in A2, then in A3, then A4, A5, A6, and so on. So the amount of data keeps expanding, so formula results and graphs next to them also keep changing/expanding. How can it be created, so stock/forex markets can be analysed with excel's tons of formulas, and the nearly infinite compinations of them? -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Need Help - How to Move multiple worksheets by Tab COlor
check this: http://www.ozgrid.com/VBA/group-sheets.htm revert if you need help... + *I did not do this for you. God is here working through me for you.* On Sun, Oct 26, 2014 at 1:34 AM, Vaibhav Joshi v...@vabs.in wrote: what exactly you are trying to achieve? + *I did not do this for you. God is here working through me for you.* On Fri, Oct 24, 2014 at 8:46 PM, Nilkanth Raval nilkanth.ra...@gmail.com wrote: Dear Sir, I need your help in Moving Multiple worksheets by tab color. I write the below code, but gives me an error. Please help me. Sub MoveSheetsbyTabcolor() Dim wsNames() As String Dim wsColor() As Integer Dim ws As Worksheet Dim ind As Integer Dim Oldwkb As Workbook Set Oldwkb = ActiveWorkbook Dim wkb As Workbook Set wkb = Workbooks.Add Oldwkb.Activate ReDim wsNames(0) ReDim wsColor(0) wsNames(0) = ActiveSheet.Name wsColor(0) = ActiveSheet.Tab.ColorIndex For Each ws In ThisWorkbook.Sheets If ws.Tab.ColorIndex = wsColor(0) And ws.Visible = xlSheetVisible Then ReDim Preserve wsNames(UBound(wsNames) + 1) ReDim Preserve wsColor(UBound(wsColor) + 1) wsNames(UBound(wsNames)) = ws.Name wsColor(UBound(wsColor)) = ws.Tab.ColorIndex End If Next ws Sheets(wsNames).Select Sheets(wsNames).Copy After:=wkb.Worksheets(wkb.Worksheets.Count) Call Delete_Empty_Sheets Set wkb = Nothing Set Oldwkb = Nothing ActiveSheet.Select End Sub *Thanks,* *Nilkanth Raval* *Think Before You Print.Consider ENVIRONMENT.* *“SAVE TREES, SAVE EARTH” * *“All appears to change when we change!”* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Need Help - How to Move multiple worksheets by Tab COlor
Hi Nilkanth, PFA Regards 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/d/optout. For Nilkanth.xlsm Description: application/vnd.ms-excel.sheet.macroenabled.12
Re: $$Excel-Macros$$ Produce CSV file as a output file by using the values/Data's from the Excel worksheet
Dear Vabz, Thanks for this challenging task..I ran this in my machine and it is working as expected..No words to say thanks..One small Q..After ran this the output file is getting genereated perfectly.But when close my macro i need to clear this result cells and i again make this file as fresh one..Also It would be helpful if i have the Pop up msg whcih is saying your file is stored in the Specified path once after the .Csv file generation.BcozOutput file is generated without any notification. Thanks, Lax On Sunday, October 26, 2014 1:29:35 AM UTC+5:30, Vabz wrote: Check this... Click blue button to run macro.. When prompted select month name in data sheet, in your case it will be cell AP3 (cell highlighted with green color for current example, you can select any other month too) you will get output file as desired.. Note, i have kept same file / sheet name in my code you may need to amend it as you needed... Cheers!! + *I did not do this for you. God is here working through me for you.* On Sun, Oct 26, 2014 at 12:15 AM, Laxmanan M laxfly...@gmail.com javascript: wrote: Hi pramod and vabz, Thanks for the help. Here I have give the file sample datais the data file and we can apply the code in the same file.the format file is just the output file data format means the output file should have the data's in the same format of the format.this file should save as .csv extension of the macro ran file. Simply saying that the data's of the sample file should save as a .csv output file with format of format file attached in the same post. Thanks, Lax -- 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.