Re: $$Excel-Macros$$ Highlighted rows will be copy and paste in Sheet 2
Hey Ashu, Please Find Attached file. I hope it is what you expecting. Regards, Mahesh On Wed, Sep 3, 2014 at 9:11 PM, Ashu k direct2as...@gmail.com wrote: Dear Sir, I have Data Table in Sheet 1, I want that, when i highlight rows in sheet 1, these highlighted rows will copy and paste in Sheet 2. Data will be pasted and over lap the data in sheet 2. Example : If I highlight row 1, 5, 8, then these rows was copy from sheet 1 and paste on sheet 2 on same rows no. 1, 5, 8. Example attached. please Help. Regards Ashu -- 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. Solved_CopyHilightedRows.xlsm Description: application/vnd.ms-excel.sheet.macroenabled.12
Re: $$Excel-Macros$$ Highlighted rows will be copy and paste in Sheet 2
Dear Ashish Sir, Sheet is provided by you is working perfect. Accurate Solution. Thanks a lot Sir. Regards Ashu -- 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$$ Auto filter issue
Hi, Anybody revert on this please!!! *Thanks Regards,Sunil Kumar Yadav* On Wed, Sep 3, 2014 at 6:51 PM, Sunil Kumar Yadav sk.yadav7...@gmail.com wrote: Sorry sir, but i think u r not understand what i want, may be in this my mistake...i tell you again! please find the enclosed file...1)correct 2)Incorrect and 3)your coding file. i have mentioned coding in both file in modulepls run and check status column of both file. In incorrect file, when filter not found GPRS against 5 then filled correct in all row...that is wrong in correct file, when filter found GPRS against 5 then skip other rows(2,3,10,9 etc) means blank...that is right. now i want when filter not found GPRS against 5 then do the skip other rows(2,3,10,9 etc) means blank. *Thanks Regards,Sunil Kumar Yadav* On Wed, Sep 3, 2014 at 3:56 PM, Vaibhav Joshi v...@vabs.in wrote: Hi Check this module 2. Cheers!! On Wed, Sep 3, 2014 at 2:15 PM, Sunil Kumar Yadav sk.yadav7...@gmail.com wrote: Actually i want first step auto filter, do the filter Column H (in this filter 3,4 and update the correct in column I) then again filter column D (in this filter GPRS all type) and in same time second filter column H (in this filter 5) Now update correct in status column. my question is when filter GPRS in column D after that software not found 5 in Column H then macro fill correct in all number against like 2,6,7,8...i want to 2,6,7,8 etc not fill it, if 5 not found than macro running stop it. *Thanks Regards,Sunil Kumar Yadav* On Tue, Sep 2, 2014 at 8:22 PM, Vaibhav Joshi v...@vabs.in wrote: share sample book explain step by step what you want to do.. Cheers!! On Tue, Sep 2, 2014 at 6:48 PM, Sunil Kumar Yadav sk.yadav7...@gmail.com wrote: Hi Friends, Please guide me on my second query I have recorded macro on auto filter and modified the 2 conditions but when GPRS not found against 5, in this situation filter fills correct in all row of status column, i want to set such condition when GPRS not found against 5 then process work on next step/or close without fill correct in all row. in sample word how can set 3 or 4 conditions on different columns in auto filter. Look Table formate: Len CalltypeStatus(autofile) 3GPRSIncorrect 4Roaming Correct 5Local GPRS Correct 9Cross Incorrect etc ActiveSheet.Range($A$1:$AC$102).AutoFilter Field:=13, Criteria1:=Array( _ 4, 3), Operator:=xlFilterValues Range(N1:N102).Cells.SpecialCells(xlCellTypeBlanks).Select Range(N1:N102).Cells.SpecialCells(xlCellTypeBlanks).Value = Correct Selection.AutoFilter Range(I1).Select Selection.AutoFilter ActiveSheet.Range($A$1:$AC$102).AutoFilter Field:=9, Criteria1:==*GPRS*, Operator:=xlAnd Range(M1).Select ActiveSheet.Range($A$1:$AC$102).AutoFilter Field:=13, Criteria1:=5, Operator:=xlFilterValues Range(N1:N102).Cells.SpecialCells(xlCellTypeBlanks).Select Range(N1:N102).Cells.SpecialCells(xlCellTypeBlanks).Value = Correct *Thanks Regards, Sunil Kumar Yadav* -- 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)
Re: $$Excel-Macros$$ Highlighted rows will be copy and paste in Sheet 2
Dear Mahesh Sir, Thanks for providing support. Code is provided by you is not meet my requirement. Your code is copy Highlighted Rows from Sheet 1 and delete whole data in sheet 2 then after pasted the data. But my requirement is different. Code is provided by Ashish Sir is working perfect. Thanks again for your help and support. Regards Ashu. -- 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$$ Auto filter issue
It means if you find GPRS 5 then only you want to paste Correct am i right? On Wed, Sep 3, 2014 at 6:51 PM, Sunil Kumar Yadav sk.yadav7...@gmail.com wrote: Sorry sir, but i think u r not understand what i want, may be in this my mistake...i tell you again! please find the enclosed file...1)correct 2)Incorrect and 3)your coding file. i have mentioned coding in both file in modulepls run and check status column of both file. In incorrect file, when filter not found GPRS against 5 then filled correct in all row...that is wrong in correct file, when filter found GPRS against 5 then skip other rows(2,3,10,9 etc) means blank...that is right. now i want when filter not found GPRS against 5 then do the skip other rows(2,3,10,9 etc) means blank. *Thanks Regards,Sunil Kumar Yadav* On Wed, Sep 3, 2014 at 3:56 PM, Vaibhav Joshi v...@vabs.in wrote: Hi Check this module 2. Cheers!! On Wed, Sep 3, 2014 at 2:15 PM, Sunil Kumar Yadav sk.yadav7...@gmail.com wrote: Actually i want first step auto filter, do the filter Column H (in this filter 3,4 and update the correct in column I) then again filter column D (in this filter GPRS all type) and in same time second filter column H (in this filter 5) Now update correct in status column. my question is when filter GPRS in column D after that software not found 5 in Column H then macro fill correct in all number against like 2,6,7,8...i want to 2,6,7,8 etc not fill it, if 5 not found than macro running stop it. *Thanks Regards,Sunil Kumar Yadav* On Tue, Sep 2, 2014 at 8:22 PM, Vaibhav Joshi v...@vabs.in wrote: share sample book explain step by step what you want to do.. Cheers!! On Tue, Sep 2, 2014 at 6:48 PM, Sunil Kumar Yadav sk.yadav7...@gmail.com wrote: Hi Friends, Please guide me on my second query I have recorded macro on auto filter and modified the 2 conditions but when GPRS not found against 5, in this situation filter fills correct in all row of status column, i want to set such condition when GPRS not found against 5 then process work on next step/or close without fill correct in all row. in sample word how can set 3 or 4 conditions on different columns in auto filter. Look Table formate: Len CalltypeStatus(autofile) 3GPRSIncorrect 4Roaming Correct 5Local GPRS Correct 9Cross Incorrect etc ActiveSheet.Range($A$1:$AC$102).AutoFilter Field:=13, Criteria1:=Array( _ 4, 3), Operator:=xlFilterValues Range(N1:N102).Cells.SpecialCells(xlCellTypeBlanks).Select Range(N1:N102).Cells.SpecialCells(xlCellTypeBlanks).Value = Correct Selection.AutoFilter Range(I1).Select Selection.AutoFilter ActiveSheet.Range($A$1:$AC$102).AutoFilter Field:=9, Criteria1:==*GPRS*, Operator:=xlAnd Range(M1).Select ActiveSheet.Range($A$1:$AC$102).AutoFilter Field:=13, Criteria1:=5, Operator:=xlFilterValues Range(N1:N102).Cells.SpecialCells(xlCellTypeBlanks).Select Range(N1:N102).Cells.SpecialCells(xlCellTypeBlanks).Value = Correct *Thanks Regards, Sunil Kumar Yadav* -- 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)
Re: $$Excel-Macros$$ Auto filter issue
yes but first filter 5 against filter GPRS by contains(all type GPRS), if GPRS not found then sub procedure close or find it then fill Correct. but my create procedure when GPRS not found then fill correct against all number like 6,7,8,9,12 etc. that is wrong. *Thanks Regards,Sunil Kumar Yadav* On Thu, Sep 4, 2014 at 1:27 PM, Vaibhav Joshi v...@vabs.in wrote: It means if you find GPRS 5 then only you want to paste Correct am i right? On Wed, Sep 3, 2014 at 6:51 PM, Sunil Kumar Yadav sk.yadav7...@gmail.com wrote: Sorry sir, but i think u r not understand what i want, may be in this my mistake...i tell you again! please find the enclosed file...1)correct 2)Incorrect and 3)your coding file. i have mentioned coding in both file in modulepls run and check status column of both file. In incorrect file, when filter not found GPRS against 5 then filled correct in all row...that is wrong in correct file, when filter found GPRS against 5 then skip other rows(2,3,10,9 etc) means blank...that is right. now i want when filter not found GPRS against 5 then do the skip other rows(2,3,10,9 etc) means blank. *Thanks Regards,Sunil Kumar Yadav* On Wed, Sep 3, 2014 at 3:56 PM, Vaibhav Joshi v...@vabs.in wrote: Hi Check this module 2. Cheers!! On Wed, Sep 3, 2014 at 2:15 PM, Sunil Kumar Yadav sk.yadav7...@gmail.com wrote: Actually i want first step auto filter, do the filter Column H (in this filter 3,4 and update the correct in column I) then again filter column D (in this filter GPRS all type) and in same time second filter column H (in this filter 5) Now update correct in status column. my question is when filter GPRS in column D after that software not found 5 in Column H then macro fill correct in all number against like 2,6,7,8...i want to 2,6,7,8 etc not fill it, if 5 not found than macro running stop it. *Thanks Regards,Sunil Kumar Yadav* On Tue, Sep 2, 2014 at 8:22 PM, Vaibhav Joshi v...@vabs.in wrote: share sample book explain step by step what you want to do.. Cheers!! On Tue, Sep 2, 2014 at 6:48 PM, Sunil Kumar Yadav sk.yadav7...@gmail.com wrote: Hi Friends, Please guide me on my second query I have recorded macro on auto filter and modified the 2 conditions but when GPRS not found against 5, in this situation filter fills correct in all row of status column, i want to set such condition when GPRS not found against 5 then process work on next step/or close without fill correct in all row. in sample word how can set 3 or 4 conditions on different columns in auto filter. Look Table formate: Len CalltypeStatus(autofile) 3GPRSIncorrect 4Roaming Correct 5Local GPRS Correct 9Cross Incorrect etc ActiveSheet.Range($A$1:$AC$102).AutoFilter Field:=13, Criteria1:=Array( _ 4, 3), Operator:=xlFilterValues Range(N1:N102).Cells.SpecialCells(xlCellTypeBlanks).Select Range(N1:N102).Cells.SpecialCells(xlCellTypeBlanks).Value = Correct Selection.AutoFilter Range(I1).Select Selection.AutoFilter ActiveSheet.Range($A$1:$AC$102).AutoFilter Field:=9, Criteria1:==*GPRS*, Operator:=xlAnd Range(M1).Select ActiveSheet.Range($A$1:$AC$102).AutoFilter Field:=13, Criteria1:=5, Operator:=xlFilterValues Range(N1:N102).Cells.SpecialCells(xlCellTypeBlanks).Select Range(N1:N102).Cells.SpecialCells(xlCellTypeBlanks).Value = Correct *Thanks Regards, Sunil Kumar Yadav* -- 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 @
Re: $$Excel-Macros$$ Auto filter issue
Ok, i goofed up in last stat.. Check this now.. On Thu, Sep 4, 2014 at 1:51 PM, Sunil Kumar Yadav sk.yadav7...@gmail.com wrote: yes but first filter 5 against filter GPRS by contains(all type GPRS), if GPRS not found then sub procedure close or find it then fill Correct. but my create procedure when GPRS not found then fill correct against all number like 6,7,8,9,12 etc. that is wrong. *Thanks Regards,Sunil Kumar Yadav* On Thu, Sep 4, 2014 at 1:27 PM, Vaibhav Joshi v...@vabs.in wrote: It means if you find GPRS 5 then only you want to paste Correct am i right? On Wed, Sep 3, 2014 at 6:51 PM, Sunil Kumar Yadav sk.yadav7...@gmail.com wrote: Sorry sir, but i think u r not understand what i want, may be in this my mistake...i tell you again! please find the enclosed file...1)correct 2)Incorrect and 3)your coding file. i have mentioned coding in both file in modulepls run and check status column of both file. In incorrect file, when filter not found GPRS against 5 then filled correct in all row...that is wrong in correct file, when filter found GPRS against 5 then skip other rows(2,3,10,9 etc) means blank...that is right. now i want when filter not found GPRS against 5 then do the skip other rows(2,3,10,9 etc) means blank. *Thanks Regards,Sunil Kumar Yadav* On Wed, Sep 3, 2014 at 3:56 PM, Vaibhav Joshi v...@vabs.in wrote: Hi Check this module 2. Cheers!! On Wed, Sep 3, 2014 at 2:15 PM, Sunil Kumar Yadav sk.yadav7...@gmail.com wrote: Actually i want first step auto filter, do the filter Column H (in this filter 3,4 and update the correct in column I) then again filter column D (in this filter GPRS all type) and in same time second filter column H (in this filter 5) Now update correct in status column. my question is when filter GPRS in column D after that software not found 5 in Column H then macro fill correct in all number against like 2,6,7,8...i want to 2,6,7,8 etc not fill it, if 5 not found than macro running stop it. *Thanks Regards,Sunil Kumar Yadav* On Tue, Sep 2, 2014 at 8:22 PM, Vaibhav Joshi v...@vabs.in wrote: share sample book explain step by step what you want to do.. Cheers!! On Tue, Sep 2, 2014 at 6:48 PM, Sunil Kumar Yadav sk.yadav7...@gmail.com wrote: Hi Friends, Please guide me on my second query I have recorded macro on auto filter and modified the 2 conditions but when GPRS not found against 5, in this situation filter fills correct in all row of status column, i want to set such condition when GPRS not found against 5 then process work on next step/or close without fill correct in all row. in sample word how can set 3 or 4 conditions on different columns in auto filter. Look Table formate: Len CalltypeStatus(autofile) 3GPRSIncorrect 4Roaming Correct 5Local GPRS Correct 9Cross Incorrect etc ActiveSheet.Range($A$1:$AC$102).AutoFilter Field:=13, Criteria1:=Array( _ 4, 3), Operator:=xlFilterValues Range(N1:N102).Cells.SpecialCells(xlCellTypeBlanks).Select Range(N1:N102).Cells.SpecialCells(xlCellTypeBlanks).Value = Correct Selection.AutoFilter Range(I1).Select Selection.AutoFilter ActiveSheet.Range($A$1:$AC$102).AutoFilter Field:=9, Criteria1:==*GPRS*, Operator:=xlAnd Range(M1).Select ActiveSheet.Range($A$1:$AC$102).AutoFilter Field:=13, Criteria1:=5, Operator:=xlFilterValues Range(N1:N102).Cells.SpecialCells(xlCellTypeBlanks).Select Range(N1:N102).Cells.SpecialCells(xlCellTypeBlanks).Value = Correct *Thanks Regards, Sunil Kumar Yadav* -- 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
Re: $$Excel-Macros$$ Auto filter issue
yeah :-), it is absolutely working as per my requirement. Thank you so much! :-) *Thanks Regards,Sunil Kumar Yadav* On Thu, Sep 4, 2014 at 3:13 PM, Vaibhav Joshi v...@vabs.in wrote: Ok, i goofed up in last stat.. Check this now.. On Thu, Sep 4, 2014 at 1:51 PM, Sunil Kumar Yadav sk.yadav7...@gmail.com wrote: yes but first filter 5 against filter GPRS by contains(all type GPRS), if GPRS not found then sub procedure close or find it then fill Correct. but my create procedure when GPRS not found then fill correct against all number like 6,7,8,9,12 etc. that is wrong. *Thanks Regards,Sunil Kumar Yadav* On Thu, Sep 4, 2014 at 1:27 PM, Vaibhav Joshi v...@vabs.in wrote: It means if you find GPRS 5 then only you want to paste Correct am i right? On Wed, Sep 3, 2014 at 6:51 PM, Sunil Kumar Yadav sk.yadav7...@gmail.com wrote: Sorry sir, but i think u r not understand what i want, may be in this my mistake...i tell you again! please find the enclosed file...1)correct 2)Incorrect and 3)your coding file. i have mentioned coding in both file in modulepls run and check status column of both file. In incorrect file, when filter not found GPRS against 5 then filled correct in all row...that is wrong in correct file, when filter found GPRS against 5 then skip other rows(2,3,10,9 etc) means blank...that is right. now i want when filter not found GPRS against 5 then do the skip other rows(2,3,10,9 etc) means blank. *Thanks Regards,Sunil Kumar Yadav* On Wed, Sep 3, 2014 at 3:56 PM, Vaibhav Joshi v...@vabs.in wrote: Hi Check this module 2. Cheers!! On Wed, Sep 3, 2014 at 2:15 PM, Sunil Kumar Yadav sk.yadav7...@gmail.com wrote: Actually i want first step auto filter, do the filter Column H (in this filter 3,4 and update the correct in column I) then again filter column D (in this filter GPRS all type) and in same time second filter column H (in this filter 5) Now update correct in status column. my question is when filter GPRS in column D after that software not found 5 in Column H then macro fill correct in all number against like 2,6,7,8...i want to 2,6,7,8 etc not fill it, if 5 not found than macro running stop it. *Thanks Regards,Sunil Kumar Yadav* On Tue, Sep 2, 2014 at 8:22 PM, Vaibhav Joshi v...@vabs.in wrote: share sample book explain step by step what you want to do.. Cheers!! On Tue, Sep 2, 2014 at 6:48 PM, Sunil Kumar Yadav sk.yadav7...@gmail.com wrote: Hi Friends, Please guide me on my second query I have recorded macro on auto filter and modified the 2 conditions but when GPRS not found against 5, in this situation filter fills correct in all row of status column, i want to set such condition when GPRS not found against 5 then process work on next step/or close without fill correct in all row. in sample word how can set 3 or 4 conditions on different columns in auto filter. Look Table formate: Len CalltypeStatus(autofile) 3GPRSIncorrect 4Roaming Correct 5Local GPRS Correct 9Cross Incorrect etc ActiveSheet.Range($A$1:$AC$102).AutoFilter Field:=13, Criteria1:=Array( _ 4, 3), Operator:=xlFilterValues Range(N1:N102).Cells.SpecialCells(xlCellTypeBlanks).Select Range(N1:N102).Cells.SpecialCells(xlCellTypeBlanks).Value = Correct Selection.AutoFilter Range(I1).Select Selection.AutoFilter ActiveSheet.Range($A$1:$AC$102).AutoFilter Field:=9, Criteria1:==*GPRS*, Operator:=xlAnd Range(M1).Select ActiveSheet.Range($A$1:$AC$102).AutoFilter Field:=13, Criteria1:=5, Operator:=xlFilterValues Range(N1:N102).Cells.SpecialCells(xlCellTypeBlanks).Select Range(N1:N102).Cells.SpecialCells(xlCellTypeBlanks).Value = Correct *Thanks Regards, Sunil Kumar Yadav* -- 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$$ Auto filter issue
cheers!! On Thu, Sep 4, 2014 at 3:43 PM, Sunil Kumar Yadav sk.yadav7...@gmail.com wrote: yeah :-), it is absolutely working as per my requirement. Thank you so much! :-) *Thanks Regards, Sunil Kumar Yadav* On Thu, Sep 4, 2014 at 3:13 PM, Vaibhav Joshi v...@vabs.in wrote: Ok, i goofed up in last stat.. Check this now.. On Thu, Sep 4, 2014 at 1:51 PM, Sunil Kumar Yadav sk.yadav7...@gmail.com wrote: yes but first filter 5 against filter GPRS by contains(all type GPRS), if GPRS not found then sub procedure close or find it then fill Correct. but my create procedure when GPRS not found then fill correct against all number like 6,7,8,9,12 etc. that is wrong. *Thanks Regards,Sunil Kumar Yadav* On Thu, Sep 4, 2014 at 1:27 PM, Vaibhav Joshi v...@vabs.in wrote: It means if you find GPRS 5 then only you want to paste Correct am i right? On Wed, Sep 3, 2014 at 6:51 PM, Sunil Kumar Yadav sk.yadav7...@gmail.com wrote: Sorry sir, but i think u r not understand what i want, may be in this my mistake...i tell you again! please find the enclosed file...1)correct 2)Incorrect and 3)your coding file. i have mentioned coding in both file in modulepls run and check status column of both file. In incorrect file, when filter not found GPRS against 5 then filled correct in all row...that is wrong in correct file, when filter found GPRS against 5 then skip other rows(2,3,10,9 etc) means blank...that is right. now i want when filter not found GPRS against 5 then do the skip other rows(2,3,10,9 etc) means blank. *Thanks Regards,Sunil Kumar Yadav* On Wed, Sep 3, 2014 at 3:56 PM, Vaibhav Joshi v...@vabs.in wrote: Hi Check this module 2. Cheers!! On Wed, Sep 3, 2014 at 2:15 PM, Sunil Kumar Yadav sk.yadav7...@gmail.com wrote: Actually i want first step auto filter, do the filter Column H (in this filter 3,4 and update the correct in column I) then again filter column D (in this filter GPRS all type) and in same time second filter column H (in this filter 5) Now update correct in status column. my question is when filter GPRS in column D after that software not found 5 in Column H then macro fill correct in all number against like 2,6,7,8...i want to 2,6,7,8 etc not fill it, if 5 not found than macro running stop it. *Thanks Regards,Sunil Kumar Yadav* On Tue, Sep 2, 2014 at 8:22 PM, Vaibhav Joshi v...@vabs.in wrote: share sample book explain step by step what you want to do.. Cheers!! On Tue, Sep 2, 2014 at 6:48 PM, Sunil Kumar Yadav sk.yadav7...@gmail.com wrote: Hi Friends, Please guide me on my second query I have recorded macro on auto filter and modified the 2 conditions but when GPRS not found against 5, in this situation filter fills correct in all row of status column, i want to set such condition when GPRS not found against 5 then process work on next step/or close without fill correct in all row. in sample word how can set 3 or 4 conditions on different columns in auto filter. Look Table formate: Len CalltypeStatus(autofile) 3GPRSIncorrect 4Roaming Correct 5Local GPRS Correct 9Cross Incorrect etc ActiveSheet.Range($A$1:$AC$102).AutoFilter Field:=13, Criteria1:=Array( _ 4, 3), Operator:=xlFilterValues Range(N1:N102).Cells.SpecialCells(xlCellTypeBlanks).Select Range(N1:N102).Cells.SpecialCells(xlCellTypeBlanks).Value = Correct Selection.AutoFilter Range(I1).Select Selection.AutoFilter ActiveSheet.Range($A$1:$AC$102).AutoFilter Field:=9, Criteria1:==*GPRS*, Operator:=xlAnd Range(M1).Select ActiveSheet.Range($A$1:$AC$102).AutoFilter Field:=13, Criteria1:=5, Operator:=xlFilterValues Range(N1:N102).Cells.SpecialCells(xlCellTypeBlanks).Select Range(N1:N102).Cells.SpecialCells(xlCellTypeBlanks).Value = Correct *Thanks Regards, Sunil Kumar Yadav* -- 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
Re: $$Excel-Macros$$ Assign already open workbooks name to variables using wildcard
I'm not sure what you're expecting with the wildcard. perhaps you could give specific examples? The Workbook object contains all of the open workbooks. You can loop through the Workbook object and save the filenames in a variable or array, like: Option Explicit Sub ListOpenWorkbooks() Dim wb As Workbook Dim wbArray ReDim wbArray(0) For Each wb In Workbooks ReDim Preserve wbArray(UBound(wbArray) + 1) wbArray(UBound(wbArray)) = wb.Name Next wb End Sub if you're wanting to assign all filenames with a common name structure to a single variable, then you're either going to have to use an array or concatenate the names. also note: in your example: File1 =ForecastLastUpdated_*.xls* File2 = ForecastLastUpdated_ReferenceInformation*.xls* then name: ForecastLastUpdated_ReferenceInformation*.xls* also is a match for: ForecastLastUpdated_*.xls* 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: Nitin Balodi nitinbal...@live.com To: excel-macros@googlegroups.com excel-macros@googlegroups.com Sent: Thursday, September 4, 2014 1:58 AM Subject: $$Excel-Macros$$ Assign already open workbooks name to variables using wildcard Hi Experts, I require your help in another problem. I have n excel files already opened but want to assign file name to variables like File1 = ForecastLastUpdated_*.xls* File2 = ForecastLastUpdated_ReferenceInformation*.xls* Highlighted in red are file name pattern and will be using these variables to perform specific functions for files. Thanks for your help and support. Regards. Yours Sincerely, Nitin Balodi -- 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$$ Auto filter issue
Vaibhav Bhai, Superb solutions according to the requirement. Regards Ashish On 4 September 2014 15:57, Vaibhav Joshi v...@vabs.in wrote: cheers!! On Thu, Sep 4, 2014 at 3:43 PM, Sunil Kumar Yadav sk.yadav7...@gmail.com wrote: yeah :-), it is absolutely working as per my requirement. Thank you so much! :-) *Thanks Regards, Sunil Kumar Yadav* On Thu, Sep 4, 2014 at 3:13 PM, Vaibhav Joshi v...@vabs.in wrote: Ok, i goofed up in last stat.. Check this now.. On Thu, Sep 4, 2014 at 1:51 PM, Sunil Kumar Yadav sk.yadav7...@gmail.com wrote: yes but first filter 5 against filter GPRS by contains(all type GPRS), if GPRS not found then sub procedure close or find it then fill Correct. but my create procedure when GPRS not found then fill correct against all number like 6,7,8,9,12 etc. that is wrong. *Thanks Regards,Sunil Kumar Yadav* On Thu, Sep 4, 2014 at 1:27 PM, Vaibhav Joshi v...@vabs.in wrote: It means if you find GPRS 5 then only you want to paste Correct am i right? On Wed, Sep 3, 2014 at 6:51 PM, Sunil Kumar Yadav sk.yadav7...@gmail.com wrote: Sorry sir, but i think u r not understand what i want, may be in this my mistake...i tell you again! please find the enclosed file...1)correct 2)Incorrect and 3)your coding file. i have mentioned coding in both file in modulepls run and check status column of both file. In incorrect file, when filter not found GPRS against 5 then filled correct in all row...that is wrong in correct file, when filter found GPRS against 5 then skip other rows(2,3,10,9 etc) means blank...that is right. now i want when filter not found GPRS against 5 then do the skip other rows(2,3,10,9 etc) means blank. *Thanks Regards,Sunil Kumar Yadav* On Wed, Sep 3, 2014 at 3:56 PM, Vaibhav Joshi v...@vabs.in wrote: Hi Check this module 2. Cheers!! On Wed, Sep 3, 2014 at 2:15 PM, Sunil Kumar Yadav sk.yadav7...@gmail.com wrote: Actually i want first step auto filter, do the filter Column H (in this filter 3,4 and update the correct in column I) then again filter column D (in this filter GPRS all type) and in same time second filter column H (in this filter 5) Now update correct in status column. my question is when filter GPRS in column D after that software not found 5 in Column H then macro fill correct in all number against like 2,6,7,8...i want to 2,6,7,8 etc not fill it, if 5 not found than macro running stop it. *Thanks Regards,Sunil Kumar Yadav* On Tue, Sep 2, 2014 at 8:22 PM, Vaibhav Joshi v...@vabs.in wrote: share sample book explain step by step what you want to do.. Cheers!! On Tue, Sep 2, 2014 at 6:48 PM, Sunil Kumar Yadav sk.yadav7...@gmail.com wrote: Hi Friends, Please guide me on my second query I have recorded macro on auto filter and modified the 2 conditions but when GPRS not found against 5, in this situation filter fills correct in all row of status column, i want to set such condition when GPRS not found against 5 then process work on next step/or close without fill correct in all row. in sample word how can set 3 or 4 conditions on different columns in auto filter. Look Table formate: Len CalltypeStatus(autofile) 3GPRSIncorrect 4Roaming Correct 5Local GPRS Correct 9Cross Incorrect etc ActiveSheet.Range($A$1:$AC$102).AutoFilter Field:=13, Criteria1:=Array( _ 4, 3), Operator:=xlFilterValues Range(N1:N102).Cells.SpecialCells(xlCellTypeBlanks).Select Range(N1:N102).Cells.SpecialCells(xlCellTypeBlanks).Value = Correct Selection.AutoFilter Range(I1).Select Selection.AutoFilter ActiveSheet.Range($A$1:$AC$102).AutoFilter Field:=9, Criteria1:==*GPRS*, Operator:=xlAnd Range(M1).Select ActiveSheet.Range($A$1:$AC$102).AutoFilter Field:=13, Criteria1:=5, Operator:=xlFilterValues Range(N1:N102).Cells.SpecialCells(xlCellTypeBlanks).Select Range(N1:N102).Cells.SpecialCells(xlCellTypeBlanks).Value = Correct *Thanks Regards, Sunil Kumar Yadav* -- 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
Re: $$Excel-Macros$$ Auto filter issue
Yes, Vaibhav Bhai is rock in VBA, his coding explanation is very sample for understanding. *Thanks Regards,Sunil Kumar Yadav* On Thu, Sep 4, 2014 at 5:23 PM, Ashish Kumar kumar.ashish...@gmail.com wrote: Vaibhav Bhai, Superb solutions according to the requirement. Regards Ashish On 4 September 2014 15:57, Vaibhav Joshi v...@vabs.in wrote: cheers!! On Thu, Sep 4, 2014 at 3:43 PM, Sunil Kumar Yadav sk.yadav7...@gmail.com wrote: yeah :-), it is absolutely working as per my requirement. Thank you so much! :-) *Thanks Regards, Sunil Kumar Yadav* On Thu, Sep 4, 2014 at 3:13 PM, Vaibhav Joshi v...@vabs.in wrote: Ok, i goofed up in last stat.. Check this now.. On Thu, Sep 4, 2014 at 1:51 PM, Sunil Kumar Yadav sk.yadav7...@gmail.com wrote: yes but first filter 5 against filter GPRS by contains(all type GPRS), if GPRS not found then sub procedure close or find it then fill Correct. but my create procedure when GPRS not found then fill correct against all number like 6,7,8,9,12 etc. that is wrong. *Thanks Regards,Sunil Kumar Yadav* On Thu, Sep 4, 2014 at 1:27 PM, Vaibhav Joshi v...@vabs.in wrote: It means if you find GPRS 5 then only you want to paste Correct am i right? On Wed, Sep 3, 2014 at 6:51 PM, Sunil Kumar Yadav sk.yadav7...@gmail.com wrote: Sorry sir, but i think u r not understand what i want, may be in this my mistake...i tell you again! please find the enclosed file...1)correct 2)Incorrect and 3)your coding file. i have mentioned coding in both file in modulepls run and check status column of both file. In incorrect file, when filter not found GPRS against 5 then filled correct in all row...that is wrong in correct file, when filter found GPRS against 5 then skip other rows(2,3,10,9 etc) means blank...that is right. now i want when filter not found GPRS against 5 then do the skip other rows(2,3,10,9 etc) means blank. *Thanks Regards,Sunil Kumar Yadav* On Wed, Sep 3, 2014 at 3:56 PM, Vaibhav Joshi v...@vabs.in wrote: Hi Check this module 2. Cheers!! On Wed, Sep 3, 2014 at 2:15 PM, Sunil Kumar Yadav sk.yadav7...@gmail.com wrote: Actually i want first step auto filter, do the filter Column H (in this filter 3,4 and update the correct in column I) then again filter column D (in this filter GPRS all type) and in same time second filter column H (in this filter 5) Now update correct in status column. my question is when filter GPRS in column D after that software not found 5 in Column H then macro fill correct in all number against like 2,6,7,8...i want to 2,6,7,8 etc not fill it, if 5 not found than macro running stop it. *Thanks Regards,Sunil Kumar Yadav* On Tue, Sep 2, 2014 at 8:22 PM, Vaibhav Joshi v...@vabs.in wrote: share sample book explain step by step what you want to do.. Cheers!! On Tue, Sep 2, 2014 at 6:48 PM, Sunil Kumar Yadav sk.yadav7...@gmail.com wrote: Hi Friends, Please guide me on my second query I have recorded macro on auto filter and modified the 2 conditions but when GPRS not found against 5, in this situation filter fills correct in all row of status column, i want to set such condition when GPRS not found against 5 then process work on next step/or close without fill correct in all row. in sample word how can set 3 or 4 conditions on different columns in auto filter. Look Table formate: Len CalltypeStatus(autofile) 3GPRSIncorrect 4Roaming Correct 5Local GPRS Correct 9Cross Incorrect etc ActiveSheet.Range($A$1:$AC$102).AutoFilter Field:=13, Criteria1:=Array( _ 4, 3), Operator:=xlFilterValues Range(N1:N102).Cells.SpecialCells(xlCellTypeBlanks).Select Range(N1:N102).Cells.SpecialCells(xlCellTypeBlanks).Value = Correct Selection.AutoFilter Range(I1).Select Selection.AutoFilter ActiveSheet.Range($A$1:$AC$102).AutoFilter Field:=9, Criteria1:==*GPRS*, Operator:=xlAnd Range(M1).Select ActiveSheet.Range($A$1:$AC$102).AutoFilter Field:=13, Criteria1:=5, Operator:=xlFilterValues Range(N1:N102).Cells.SpecialCells(xlCellTypeBlanks).Select Range(N1:N102).Cells.SpecialCells(xlCellTypeBlanks).Value = Correct *Thanks Regards, Sunil Kumar Yadav* -- 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)
RE: $$Excel-Macros$$ Assign already open workbooks name to variables using wildcard
Hi Paul, Thanks for your response. When the macro executes, it opens a folder and have 5 excel files in it. I am not sure which workbook will be assigned when I type WorkBooks(1).activate or WorkBook(2).activate and so on. I want to assign a variable to specific workbook. Workbook names are not same and will have timestamp of their extraction date and time. File1 = ForecastLastUpdated_*File2 = ForecastLastUpdated_ReferenceInformation* I hope it explains the criteria. Regards. Yours Sincerely,Nitin Balodi Date: Thu, 4 Sep 2014 03:33:36 -0700 From: schreiner_p...@att.net Subject: Re: $$Excel-Macros$$ Assign already open workbooks name to variables using wildcard To: excel-macros@googlegroups.com I'm not sure what you're expecting with the wildcard. perhaps you could give specific examples? The Workbook object contains all of the open workbooks. You can loop through the Workbook object and save the filenames in a variable or array, like: Option Explicit Sub ListOpenWorkbooks() Dim wb As Workbook Dim wbArray ReDim wbArray(0) For Each wb In Workbooks ReDim Preserve wbArray(UBound(wbArray) + 1) wbArray(UBound(wbArray)) = wb.Name Next wb End Sub if you're wanting to assign all filenames with a common name structure to a single variable, then you're either going to have to use an array or concatenate the names. also note:in your example:File1 = ForecastLastUpdated_*.xls* File2 = ForecastLastUpdated_ReferenceInformation*.xls* then name: ForecastLastUpdated_ReferenceInformation*.xls*also is a match for:ForecastLastUpdated_*.xls* 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: Nitin Balodi nitinbal...@live.com To: excel-macros@googlegroups.com excel-macros@googlegroups.com Sent: Thursday, September 4, 2014 1:58 AM Subject: $$Excel-Macros$$ Assign already open workbooks name to variables using wildcard Hi Experts, I require your help in another problem. I have n excel files already opened but want to assign file name to variables like File1 = ForecastLastUpdated_*.xls* File2 = ForecastLastUpdated_ReferenceInformation*.xls* Highlighted in red are file name pattern and will be using these variables to perform specific functions for files. Thanks for your help and support. Regards. Yours Sincerely,Nitin Balodi -- 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.
Re: $$Excel-Macros$$ Assign already open workbooks name to variables using wildcard
So, your macro opens all of the (5) workbooks in the folder. You can still use the loop I've described and use if/elseif/endif like: Sub ListOpenWorkbooks() Dim wb As Workbook Dim file1, file2, file3, file4, file5 For Each wb In Workbooks If (Left(wb.Name, Len(ForecastLastUpdated_ReferenceInformation_)) = _ ForecastLastUpdated_ReferenceInformation_) Then file1 = wb.Name ElseIf (Left(wb.Name, Len(ForecastLastUpdated_)) = _ ForecastLastUpdated_) Then file2 = wb.Name ElseIf (Left(wb.Name, Len(filename3_)) = _ filename3_) Then file3 = wb.Name ElseIf (Left(wb.Name, Len(filename4_)) = _ filename4_) Then file4 = wb.Name ElseIf (Left(wb.Name, Len(filename5_)) = _ filename5_) Then file5 = wb.Name End If Next wb End Sub Keep in mind that especially with the filename in your example, which name gets tested FIRST is important: If you were to reverse the first two names, then the selection wouldn't work as intended. 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: Nitin Balodi nitinbal...@live.com To: excel-macros@googlegroups.com excel-macros@googlegroups.com Sent: Thursday, September 4, 2014 8:12 AM Subject: RE: $$Excel-Macros$$ Assign already open workbooks name to variables using wildcard Hi Paul, Thanks for your response. When the macro executes, it opens a folder and have 5 excel files in it. I am not sure which workbook will be assigned when I type WorkBooks(1).activate or WorkBook(2).activate and so on. I want to assign a variable to specific workbook. Workbook names are not same and will have timestamp of their extraction date and time. File1 = ForecastLastUpdated_* File2 = ForecastLastUpdated_ReferenceInformation* I hope it explains the criteria. Regards. Yours Sincerely, Nitin Balodi Date: Thu, 4 Sep 2014 03:33:36 -0700 From: schreiner_p...@att.net Subject: Re: $$Excel-Macros$$ Assign already open workbooks name to variables using wildcard To: excel-macros@googlegroups.com I'm not sure what you're expecting with the wildcard. perhaps you could give specific examples? The Workbook object contains all of the open workbooks. You can loop through the Workbook object and save the filenames in a variable or array, like: Option Explicit Sub ListOpenWorkbooks() Dim wb As Workbook Dim wbArray ReDim wbArray(0) For Each wb In Workbooks ReDim Preserve wbArray(UBound(wbArray) + 1) wbArray(UBound(wbArray)) = wb.Name Next wb End Sub if you're wanting to assign all filenames with a common name structure to a single variable, then you're either going to have to use an array or concatenate the names. also note: in your example: File1 =ForecastLastUpdated_*.xls* File2 = ForecastLastUpdated_ReferenceInformation*.xls* then name: ForecastLastUpdated_ReferenceInformation*.xls* also is a match for: ForecastLastUpdated_*.xls* 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: Nitin Balodi nitinbal...@live.com To: excel-macros@googlegroups.com excel-macros@googlegroups.com Sent: Thursday, September 4, 2014 1:58 AM Subject: $$Excel-Macros$$ Assign already open workbooks name to variables using wildcard Hi Experts, I require your help in another problem. I have n excel files already opened but want to assign file name to variables like File1 = ForecastLastUpdated_*.xls* File2 = ForecastLastUpdated_ReferenceInformation*.xls* Highlighted in red are file name pattern and will be using these variables to perform specific functions for files. Thanks for your help and support. Regards. Yours Sincerely, Nitin Balodi -- 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
$$Excel-Macros$$ Re: Shortcut key for Border
very easy just create ALL BORDER in the quick access toolbar and choose the key assigned by excel to that toolbar On Wednesday, 12 October 2011 12:19:29 UTC+5, ankit wrote: Dear All, I need shortcut key for all border.plz help me. Regards, Ankit -- 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: Shortcut key for Border
Anyways.. its Ctr + Shift + 7 . Cheers!! On Thu, Sep 4, 2014 at 8:27 PM, GENIUS izharra...@gmail.com wrote: very easy just create ALL BORDER in the quick access toolbar and choose the key assigned by excel to that toolbar On Wednesday, 12 October 2011 12:19:29 UTC+5, ankit wrote: Dear All, I need shortcut key for all border.plz help me. Regards, Ankit -- 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$$ Auto filter issue
Thanks, I did not do this for you. God is here working through me for you. On Thu, Sep 4, 2014 at 5:35 PM, Sunil Kumar Yadav sk.yadav7...@gmail.com wrote: Yes, Vaibhav Bhai is rock in VBA, his coding explanation is very sample for understanding. *Thanks Regards, Sunil Kumar Yadav* On Thu, Sep 4, 2014 at 5:23 PM, Ashish Kumar kumar.ashish...@gmail.com wrote: Vaibhav Bhai, Superb solutions according to the requirement. Regards Ashish On 4 September 2014 15:57, Vaibhav Joshi v...@vabs.in wrote: cheers!! On Thu, Sep 4, 2014 at 3:43 PM, Sunil Kumar Yadav sk.yadav7...@gmail.com wrote: yeah :-), it is absolutely working as per my requirement. Thank you so much! :-) *Thanks Regards, Sunil Kumar Yadav* On Thu, Sep 4, 2014 at 3:13 PM, Vaibhav Joshi v...@vabs.in wrote: Ok, i goofed up in last stat.. Check this now.. On Thu, Sep 4, 2014 at 1:51 PM, Sunil Kumar Yadav sk.yadav7...@gmail.com wrote: yes but first filter 5 against filter GPRS by contains(all type GPRS), if GPRS not found then sub procedure close or find it then fill Correct. but my create procedure when GPRS not found then fill correct against all number like 6,7,8,9,12 etc. that is wrong. *Thanks Regards, Sunil Kumar Yadav* On Thu, Sep 4, 2014 at 1:27 PM, Vaibhav Joshi v...@vabs.in wrote: It means if you find GPRS 5 then only you want to paste Correct am i right? On Wed, Sep 3, 2014 at 6:51 PM, Sunil Kumar Yadav sk.yadav7...@gmail.com wrote: Sorry sir, but i think u r not understand what i want, may be in this my mistake...i tell you again! please find the enclosed file...1)correct 2)Incorrect and 3)your coding file. i have mentioned coding in both file in modulepls run and check status column of both file. In incorrect file, when filter not found GPRS against 5 then filled correct in all row...that is wrong in correct file, when filter found GPRS against 5 then skip other rows(2,3,10,9 etc) means blank...that is right. now i want when filter not found GPRS against 5 then do the skip other rows(2,3,10,9 etc) means blank. *Thanks Regards,Sunil Kumar Yadav* On Wed, Sep 3, 2014 at 3:56 PM, Vaibhav Joshi v...@vabs.in wrote: Hi Check this module 2. Cheers!! On Wed, Sep 3, 2014 at 2:15 PM, Sunil Kumar Yadav sk.yadav7...@gmail.com wrote: Actually i want first step auto filter, do the filter Column H (in this filter 3,4 and update the correct in column I) then again filter column D (in this filter GPRS all type) and in same time second filter column H (in this filter 5) Now update correct in status column. my question is when filter GPRS in column D after that software not found 5 in Column H then macro fill correct in all number against like 2,6,7,8...i want to 2,6,7,8 etc not fill it, if 5 not found than macro running stop it. *Thanks Regards, Sunil Kumar Yadav* On Tue, Sep 2, 2014 at 8:22 PM, Vaibhav Joshi v...@vabs.in wrote: share sample book explain step by step what you want to do.. Cheers!! On Tue, Sep 2, 2014 at 6:48 PM, Sunil Kumar Yadav sk.yadav7...@gmail.com wrote: Hi Friends, Please guide me on my second query I have recorded macro on auto filter and modified the 2 conditions but when GPRS not found against 5, in this situation filter fills correct in all row of status column, i want to set such condition when GPRS not found against 5 then process work on next step/or close without fill correct in all row. in sample word how can set 3 or 4 conditions on different columns in auto filter. Look Table formate: Len CalltypeStatus(autofile) 3GPRSIncorrect 4Roaming Correct 5Local GPRS Correct 9Cross Incorrect etc ActiveSheet.Range($A$1:$AC$102).AutoFilter Field:=13, Criteria1:=Array( _ 4, 3), Operator:=xlFilterValues Range(N1:N102).Cells.SpecialCells(xlCellTypeBlanks).Select Range(N1:N102).Cells.SpecialCells(xlCellTypeBlanks).Value = Correct Selection.AutoFilter Range(I1).Select Selection.AutoFilter ActiveSheet.Range($A$1:$AC$102).AutoFilter Field:=9, Criteria1:==*GPRS*, Operator:=xlAnd Range(M1).Select ActiveSheet.Range($A$1:$AC$102).AutoFilter Field:=13, Criteria1:=5, Operator:=xlFilterValues Range(N1:N102).Cells.SpecialCells(xlCellTypeBlanks).Select Range(N1:N102).Cells.SpecialCells(xlCellTypeBlanks).Value = Correct *Thanks Regards, Sunil Kumar Yadav* -- 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.
$$Excel-Macros$$ Text file to excel
Dear expert, I want to open the text file in excel (copy all the data from text file) and have to do some computation on excel and again I need to save the excel file to text file. I need to know how to open the text file (or how to copy the data from text file) and how to save the excel data to text file. Required your help one that. Thanks Regards, Ganesh N -- 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$$ Blank Cell Issue
Hi Everyone! I am working on a sheet where I have the Product listed in Column A, app in Column B and Cat 1 in Column C. These 3 columns are fine. The issue I run into is column 4 and Column 5 have values that don't line up with column 6. Basically, I don't want to have to drag all the values for Column 6 up to meet Column 4. The attachment is an example of what the sheet currently looks like versus what I want it to look like. The sheet I am working on has thousands of these and I need a quick and easy way to align everything. Appreciate any assistance. Best, LJ -- 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. Blank Cell Issue.xlsx Description: MS-Excel 2007 spreadsheet
Re: $$Excel-Macros$$ Blank Cell Issue
Hi LJ, Just select the data - ctrl + G - special - blanks - ok - right click - delete - Shift cells up. Thanks Regards Ganesh N On Thu, Sep 4, 2014 at 10:27 PM, LJ ljasonmil...@gmail.com wrote: Hi Everyone! I am working on a sheet where I have the Product listed in Column A, app in Column B and Cat 1 in Column C. These 3 columns are fine. The issue I run into is column 4 and Column 5 have values that don't line up with column 6. Basically, I don't want to have to drag all the values for Column 6 up to meet Column 4. The attachment is an example of what the sheet currently looks like versus what I want it to look like. The sheet I am working on has thousands of these and I need a quick and easy way to align everything. Appreciate any assistance. Best, LJ -- 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$$ Blank Cell Issue
Ganesh, Thanks for the reply. When I do that the other products beneath are left without values in columns 4 and 6. On Thursday, September 4, 2014 1:08:02 PM UTC-4, Ganesh N wrote: Hi LJ, Just select the data - ctrl + G - special - blanks - ok - right click - delete - Shift cells up. Thanks Regards Ganesh N On Thu, Sep 4, 2014 at 10:27 PM, LJ ljason...@gmail.com javascript: wrote: Hi Everyone! I am working on a sheet where I have the Product listed in Column A, app in Column B and Cat 1 in Column C. These 3 columns are fine. The issue I run into is column 4 and Column 5 have values that don't line up with column 6. Basically, I don't want to have to drag all the values for Column 6 up to meet Column 4. The attachment is an example of what the sheet currently looks like versus what I want it to look like. The sheet I am working on has thousands of these and I need a quick and easy way to align everything. Appreciate any assistance. Best, LJ -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros...@googlegroups.com javascript:. To post to this group, send email to excel-...@googlegroups.com javascript:. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Text file to excel
I'm sure I must be misunderstanding the question. Assuming your text file has a .txt extension: Why don't you simply: launch Excel File-Open Change file types to: Text Files (*.prn;*.txt;*.csv) do whatever formatting is applicable when saving, the file should default to .txt so, what am I missing in this question? 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: Ganesh N ganeshg...@gmail.com To: excel-macros@googlegroups.com excel-macros@googlegroups.com Sent: Thursday, September 4, 2014 11:44 AM Subject: $$Excel-Macros$$ Text file to excel Dear expert, I want to open the text file in excel (copy all the data from text file) and have to do some computation on excel and again I need to save the excel file to text file. I need to know how to open the text file (or how to copy the data from text file) and how to save the excel data to text file. Required your help one that. Thanks Regards, Ganesh N -- 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$$ Blank Cell Issue
Dear LJ, Can you please share the little detail about your requirement ? with some other sample ? Thanks Regards, Ganesh N On Thu, Sep 4, 2014 at 10:40 PM, LJ ljasonmil...@gmail.com wrote: Ganesh, Thanks for the reply. When I do that the other products beneath are left without values in columns 4 and 6. On Thursday, September 4, 2014 1:08:02 PM UTC-4, Ganesh N wrote: Hi LJ, Just select the data - ctrl + G - special - blanks - ok - right click - delete - Shift cells up. Thanks Regards Ganesh N On Thu, Sep 4, 2014 at 10:27 PM, LJ ljason...@gmail.com wrote: Hi Everyone! I am working on a sheet where I have the Product listed in Column A, app in Column B and Cat 1 in Column C. These 3 columns are fine. The issue I run into is column 4 and Column 5 have values that don't line up with column 6. Basically, I don't want to have to drag all the values for Column 6 up to meet Column 4. The attachment is an example of what the sheet currently looks like versus what I want it to look like. The sheet I am working on has thousands of these and I need a quick and easy way to align everything. Appreciate any assistance. Best, LJ -- 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. To post to this group, send email to excel-...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Text file to excel
Dear Paul, Thanks for your reply. your rite but i have to open by macro because i have to do some automation after i open the .txt file to excel. Kindly help me how to open the .txt file using macro. I mean code to open and save the same. Thanks Regards, Ganesh N On Thu, Sep 4, 2014 at 10:45 PM, Paul Schreiner schreiner_p...@att.net wrote: I'm sure I must be misunderstanding the question. Assuming your text file has a .txt extension: Why don't you simply: launch Excel File-Open Change file types to: Text Files (*.prn;*.txt;*.csv) do whatever formatting is applicable when saving, the file should default to .txt so, what am I missing in this question? *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:* Ganesh N ganeshg...@gmail.com *To:* excel-macros@googlegroups.com excel-macros@googlegroups.com *Sent:* Thursday, September 4, 2014 11:44 AM *Subject:* $$Excel-Macros$$ Text file to excel Dear expert, I want to open the text file in excel (copy all the data from text file) and have to do some computation on excel and again I need to save the excel file to text file. I need to know how to open the text file (or how to copy the data from text file) and how to save the excel data to text file. Required your help one that. Thanks Regards, Ganesh N -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this
$$Excel-Macros$$ Re: Blank Cell Issue
I update the attached sheet. As you can see there are additional values in the first 3 columns that will be affected if everything is shifted upward by using the F5 solution. Thanks again for any help. Best, LJ On Thursday, September 4, 2014 12:57:11 PM UTC-4, LJ wrote: Hi Everyone! I am working on a sheet where I have the Product listed in Column A, app in Column B and Cat 1 in Column C. These 3 columns are fine. The issue I run into is column 4 and Column 5 have values that don't line up with column 6. Basically, I don't want to have to drag all the values for Column 6 up to meet Column 4. The attachment is an example of what the sheet currently looks like versus what I want it to look like. The sheet I am working on has thousands of these and I need a quick and easy way to align everything. Appreciate any assistance. Best, LJ -- 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. Blank Cell Issue.xlsx Description: MS-Excel 2007 spreadsheet
Re: $$Excel-Macros$$ Text file to excel
Have you tried recording a macro? When I recorded macros, I came up with: Sub Open_Macro() Workbooks.OpenText Filename:=C:\temp\mfg_appl_log.txt, Origin:=437, _ StartRow:=1, DataType:=xlDelimited, TextQualifier:=xlDoubleQuote, _ ConsecutiveDelimiter:=False, Tab:=True, Semicolon:=False, Comma:=False _ , Space:=False, Other:=True, OtherChar:=|, _ FieldInfo:=Array(Array(1, 1), Array(2, 1), Array(3, 1), Array(4, 1), _ Array(5, 1), Array(6, 1), Array(7, 1), Array(8, 1)), _ TrailingMinusNumbers:=True End Sub Sub Save_Macro() ActiveWorkbook.Save End Sub 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: Ganesh N ganeshg...@gmail.com To: excel-macros@googlegroups.com excel-macros@googlegroups.com Sent: Thursday, September 4, 2014 1:20 PM Subject: Re: $$Excel-Macros$$ Text file to excel Dear Paul, Thanks for your reply. your rite but i have to open by macro because i have to do some automation after i open the .txt file to excel. Kindly help me how to open the .txt file using macro. I mean code to open and save the same. Thanks Regards, Ganesh N On Thu, Sep 4, 2014 at 10:45 PM, Paul Schreiner schreiner_p...@att.net wrote: I'm sure I must be misunderstanding the question. Assuming your text file has a .txt extension: Why don't you simply: launch Excel File-Open Change file types to: Text Files (*.prn;*.txt;*.csv) do whatever formatting is applicable when saving, the file should default to .txt so, what am I missing in this question? 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: Ganesh N ganeshg...@gmail.com To: excel-macros@googlegroups.com excel-macros@googlegroups.com Sent: Thursday, September 4, 2014 11:44 AM Subject: $$Excel-Macros$$ Text file to excel Dear expert, I want to open the text file in excel (copy all the data from text file) and have to do some computation on excel and again I need to save the excel file to text file. I need to know how to open the text file (or how to copy the data from text file) and how to save the excel data to text file. Required your help one that. Thanks Regards, Ganesh N -- 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.
Re: $$Excel-Macros$$ Blank Cell Issue
Hi LJ, Follow the below mentioned simple steps to pull up the values of Column G. - Select the data G2 to G1048576 (mean to say: select the G column data from G2 to till last the column, Don't select G1 to G1048576) - Press F5 - Click on Special button - Select Blanks - Press OK - Press Ctrl with (-) minus sign. - Select Shift Cells UP - OK 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.
Re: $$Excel-Macros$$ Solution Requested
Hi Joshi, PFA. On Thu, Sep 4, 2014 at 10:20 PM, Nagendra Joshi nitin620@gmail.com wrote: Dear Team, Please find the enclosed file which contains many sheets but i need a solution regarding the first second sheet. First sheet is a dump which is directly entered by the field executives, now what is want is if Status column value is Issued in first sheet then automatically need to reflect those particular rows in the second sheet according to their header formation. Looking for your help VBA query or Excel function both are requested .. Regards, Nagendra Joshi 9555636358 -- 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. 2. Nroth Material Rev. Issued Qty.xlsb Description: application/vnd.ms-excel.sheet.binary.macroenabled.12
Re: $$Excel-Macros$$ Text file to excel
Thanks Paul. Let me check on this. Regards, Ganesh N On Thu, Sep 4, 2014 at 11:29 PM, Paul Schreiner schreiner_p...@att.net wrote: Have you tried recording a macro? When I recorded macros, I came up with: Sub Open_Macro() Workbooks.OpenText Filename:=C:\temp\mfg_appl_log.txt, Origin:=437, _ StartRow:=1, DataType:=xlDelimited, TextQualifier:=xlDoubleQuote, _ ConsecutiveDelimiter:=False, Tab:=True, Semicolon:=False, Comma:=False _ , Space:=False, Other:=True, OtherChar:=|, _ FieldInfo:=Array(Array(1, 1), Array(2, 1), Array(3, 1), Array(4, 1), _ Array(5, 1), Array(6, 1), Array(7, 1), Array(8, 1)), _ TrailingMinusNumbers:=True End Sub Sub Save_Macro() ActiveWorkbook.Save End Sub *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:* Ganesh N ganeshg...@gmail.com *To:* excel-macros@googlegroups.com excel-macros@googlegroups.com *Sent:* Thursday, September 4, 2014 1:20 PM *Subject:* Re: $$Excel-Macros$$ Text file to excel Dear Paul, Thanks for your reply. your rite but i have to open by macro because i have to do some automation after i open the .txt file to excel. Kindly help me how to open the .txt file using macro. I mean code to open and save the same. Thanks Regards, Ganesh N On Thu, Sep 4, 2014 at 10:45 PM, Paul Schreiner schreiner_p...@att.net wrote: I'm sure I must be misunderstanding the question. Assuming your text file has a .txt extension: Why don't you simply: launch Excel File-Open Change file types to: Text Files (*.prn;*.txt;*.csv) do whatever formatting is applicable when saving, the file should default to .txt so, what am I missing in this question? *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:* Ganesh N ganeshg...@gmail.com *To:* excel-macros@googlegroups.com excel-macros@googlegroups.com *Sent:* Thursday, September 4, 2014 11:44 AM *Subject:* $$Excel-Macros$$ Text file to excel Dear expert, I want to open the text file in excel (copy all the data from text file) and have to do some computation on excel and again I need to save the excel file to text file. I need to know how to open the text file (or how to copy the data from text file) and how to save the excel data to text file. Required your help one that. Thanks Regards, Ganesh N -- 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
$$Excel-Macros$$ Need some help with VBA and Userform Please
Okay so I tried to do this on my own. Which in someways was good learned somethings. On the flip side I have aged 30 years and have pulled half my hair out. I have tried to get the information to input on the form put I can not get it in how I would like it. It is all going in the same row and It should be like the example below starting at row 6 and using 3 rows 5 columns input the data, then the next one that gets input would skip a row and fill in 3 rows and 5 columns. This pattern will continue down the page. Hopefully someone can edit my current code to work in this fashion. A6 = txtAssignmentName A7 = txtDate A8 = txtAssignmentType D6 = txtPointsReceived E6 = txtPointsPossible SKIP Row 9 A10 = txtAssignmentName A11 = txtDate A12 = txtAssignmentType D10 = txtPointsReceived E10 = txtPointsPossible And repeat this down the page for every new entry Here is what I have which inputs everything in 1 row and poorly done as I am guessing at how to do this Private Sub cmdSubmit_Click() Application.ScreenUpdating = False Dim rNextCl As Range Dim NextRw As Long With Sheet1'find next empty row using Column A NextRw = .Cells(Rows.Count, 2) _ .End(xlUp).Offset(1, 0).Row 'This information starts at row 6 and goes down in groups of 3 rows and skips a row, so there is a 'blank row between the groups of 3 rows. .Cells(NextRw, 1).Value = Me.txtAssignmentName.Value 'this would go in A6 .Cells(NextRw, 2).Value = Me.txtDate 'this would go in A7 .Cells(NextRw, 3).Value = Me.txtAssignmentType.Value 'this would go in A8 .Cells(NextRw, 4).Value = Me.txtPointsReceived.Value 'this would go in D6 would be nice if the default if left blank would input a - in the sheet .Cells(NextRw, 5).Value = Me.txtPointsPossible.Value 'this would go in E6 'So this information would be Row 6:8 Then when I want to input another assignment it would 'skip a row and input the data. Not sure if it pushes the previous data down. End With 'confirm data transferred Unload Me End Sub -- 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$$ Assign already open workbooks name to variables using wildcard
HI Paul., Thanks for your ideas, it worked. As suggested by you, I have changed naming convention so that each filename must be unique. Really appreciated. Regards. Yours Sincerely,Nitin Balodi Date: Thu, 4 Sep 2014 06:17:46 -0700 From: schreiner_p...@att.net Subject: Re: $$Excel-Macros$$ Assign already open workbooks name to variables using wildcard To: excel-macros@googlegroups.com So, your macro opens all of the (5) workbooks in the folder.You can still use the loop I've described and use if/elseif/endif like: Sub ListOpenWorkbooks() Dim wb As Workbook Dim file1, file2, file3, file4, file5 For Each wb In Workbooks If (Left(wb.Name, Len(ForecastLastUpdated_ReferenceInformation_)) = _ ForecastLastUpdated_ReferenceInformation_) Then file1 = wb.Name ElseIf (Left(wb.Name, Len(ForecastLastUpdated_)) = _ ForecastLastUpdated_) Then file2 = wb.Name ElseIf (Left(wb.Name, Len(filename3_)) = _ filename3_) Then file3 = wb.Name ElseIf (Left(wb.Name, Len(filename4_)) = _ filename4_) Then file4 = wb.Name ElseIf (Left(wb.Name, Len(filename5_)) = _ filename5_) Then file5 = wb.Name End If Next wb End SubKeep in mind that especially with the filename in your example,which name gets tested FIRST is important:If you were to reverse the first two names, then the selection wouldn't work as intended. 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: Nitin Balodi nitinbal...@live.com To: excel-macros@googlegroups.com excel-macros@googlegroups.com Sent: Thursday, September 4, 2014 8:12 AM Subject: RE: $$Excel-Macros$$ Assign already open workbooks name to variables using wildcard Hi Paul,Thanks for your response. When the macro executes, it opens a folder and have 5 excel files in it. I am not sure which workbook will be assigned when I type WorkBooks(1).activate or WorkBook(2).activate and so on.I want to assign a variable to specific workbook. Workbook names are not same and will have timestamp of their extraction date and time.File1 = ForecastLastUpdated_*File2 = ForecastLastUpdated_ReferenceInformation*I hope it explains the criteria.Regards.Yours Sincerely,Nitin BalodiDate: Thu, 4 Sep 2014 03:33:36 -0700From: schreiner_paul@att.netSubject: Re: $$Excel-Macros$$ Assign already open workbooks name to variables using wildcardTo: excel-mac...@googlegroups.comi'm not sure what you're expecting with the wildcard. perhaps you could give specific examples? The Workbook object contains all of the open workbooks. You can loop through the Workbook object and save the filenames in a variable or array, like: Option ExplicitSub ListOpenWorkbooks()Dim wb As WorkbookDim wbArrayReDim wbArray(0)For Each wb In WorkbooksReDim Preserve wbArray(UBound(wbArray) + 1) wbArray(UBound(wbArray)) = wb.NameNext wbEnd Sub if you're wanting to assign all filenames with a common name structure to a single variable, then you're either going to have to use an array or concatenate the names. also note:in your example:File1 = ForecastLastUpdated_*.xls*File2 = ForecastLastUpdated_ReferenceInformation*.xls*then name: ForecastLastUpdated_ReferenceInformation*.xls*also is a match for:ForecastLastUpdated_*.xls* 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: Nitin Balodi nitinbal...@live.com To: excel-macros@googlegroups.com excel-macros@googlegroups.com Sent: Thursday, September 4, 2014 1:58 AM Subject: $$Excel-Macros$$ Assign already open workbooks name to variables using wildcard Hi Experts,I require your help in another problem. I have n excel files already opened but want to assign file name to variables likeFile1 = ForecastLastUpdated_*.xls*File2 = ForecastLastUpdated_ReferenceInformation*.xls*Highlighted in red are file name pattern and will be using these variables to perform specific functions for files. Thanks for your help and support.Regards.Yours Sincerely,Nitin Balodi -- 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,