Re: $$Excel-Macros$$ Copy Range From Files to Sheets
Dear Expert. Excellent Work. Bundle of thanks for it. Regards, Zafar Iqbal On Saturday, 10 January 2015 10:51:39 UTC+3, Vabz wrote: Hi Zafar, check this attachment.. Macro will chk for sheet name exist for filename for file string -001.xls If exist then data will be copied in same sheet else new sheet will be added at the end.. Cheers!! ᐧ On Thu, Jan 8, 2015 at 9:22 PM, Zafar Iqbal ziqb...@gmail.com javascript: wrote: Dear Expert, No need of replacement of existing data if it will be difficult to handle in big code. Thanks On Jan 8, 2015 6:46 PM, Vaibhav Joshi v...@vabs.in javascript: wrote: And what abt same records if exist.. wanna replace or keep duplicate records?? On Jan 8, 2015 9:15 PM, Zafar Iqbal ziqb...@gmail.com javascript: wrote: First run of code will create summary sheets 2400, 2401, 600, etc. Later on while updation new files data will be pasted below existing data in related summary sheets. Like 2400-08.xls will be pasted below existing last data in summary sheet 2400. On Jan 8, 2015 5:41 PM, Vaibhav Joshi v...@vabs.in javascript: wrote: what if there is sheet with name 2400, 2401 600 already exist? What about rest of file name? ᐧ + *I did not do this for you. God is here working through me for you.* On Thu, Jan 8, 2015 at 2:38 PM, Zafar Iqbal ziqb...@gmail.com javascript: wrote: Dear Experts, We are getting quick help from you. We appreciate your efforts, always. Attached Code copies a Range from Sheet1 from Selected files Paste in Active Sheet below each other. Kindly help in making this code more flexible as per below requirement. There are +400 excel files named as 2400-01.xls, 2400-02.xls, 2400-03.xls and so on 2401-01.xls, 2401-02.xls, 2401-03.xls and so on 600-01.xls, 600-02.xls, 600-03.xls and so. There are other groups with Names like 500*.xls, 700*.xls, 710*.xls, etc For files named 2400*.xls, code should create New Sheet Named as 2400 and paste in it Sheet1 Range from all 2400*.xls files. For files named 2401*.xls code should create New Sheet Named as 2401 and paste in it Sheet1 Range from all 2401*.xls files. For file named 600*.xls code should create New Sheet Named as 600 and paste in it Sheet1 Range from all 600*.xls files. Your guidance quick support always make our life comfortable. Thanks in advance for your help, please. Regards, Zafar Iqbal -- 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$$ Copy Range From Files to Sheets
First run of code will create summary sheets 2400, 2401, 600, etc. Later on while updation new files data will be pasted below existing data in related summary sheets. Like 2400-08.xls will be pasted below existing last data in summary sheet 2400. On Jan 8, 2015 5:41 PM, Vaibhav Joshi v...@vabs.in wrote: what if there is sheet with name 2400, 2401 600 already exist? What about rest of file name? ᐧ + *I did not do this for you. God is here working through me for you.* On Thu, Jan 8, 2015 at 2:38 PM, Zafar Iqbal ziqba...@gmail.com wrote: Dear Experts, We are getting quick help from you. We appreciate your efforts, always. Attached Code copies a Range from Sheet1 from Selected files Paste in Active Sheet below each other. Kindly help in making this code more flexible as per below requirement. There are +400 excel files named as 2400-01.xls, 2400-02.xls, 2400-03.xls and so on 2401-01.xls, 2401-02.xls, 2401-03.xls and so on 600-01.xls, 600-02.xls, 600-03.xls and so. There are other groups with Names like 500*.xls, 700*.xls, 710*.xls, etc For files named 2400*.xls, code should create New Sheet Named as 2400 and paste in it Sheet1 Range from all 2400*.xls files. For files named 2401*.xls code should create New Sheet Named as 2401 and paste in it Sheet1 Range from all 2401*.xls files. For file named 600*.xls code should create New Sheet Named as 600 and paste in it Sheet1 Range from all 600*.xls files. Your guidance quick support always make our life comfortable. Thanks in advance for your help, please. Regards, Zafar Iqbal -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to a topic in the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this topic, visit https://groups.google.com/d/topic/excel-macros/ZPWVGa6U-LE/unsubscribe. To unsubscribe from this group and all its topics, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =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
Re: $$Excel-Macros$$ Copy Range From Files to Sheets
what if there is sheet with name 2400, 2401 600 already exist? What about rest of file name? ᐧ + *I did not do this for you. God is here working through me for you.* On Thu, Jan 8, 2015 at 2:38 PM, Zafar Iqbal ziqba...@gmail.com wrote: Dear Experts, We are getting quick help from you. We appreciate your efforts, always. Attached Code copies a Range from Sheet1 from Selected files Paste in Active Sheet below each other. Kindly help in making this code more flexible as per below requirement. There are +400 excel files named as 2400-01.xls, 2400-02.xls, 2400-03.xls and so on 2401-01.xls, 2401-02.xls, 2401-03.xls and so on 600-01.xls, 600-02.xls, 600-03.xls and so. There are other groups with Names like 500*.xls, 700*.xls, 710*.xls, etc For files named 2400*.xls, code should create New Sheet Named as 2400 and paste in it Sheet1 Range from all 2400*.xls files. For files named 2401*.xls code should create New Sheet Named as 2401 and paste in it Sheet1 Range from all 2401*.xls files. For file named 600*.xls code should create New Sheet Named as 600 and paste in it Sheet1 Range from all 600*.xls files. Your guidance quick support always make our life comfortable. Thanks in advance for your help, please. Regards, Zafar Iqbal -- 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$$ Copy Range From Files to Sheets
And what abt same records if exist.. wanna replace or keep duplicate records?? On Jan 8, 2015 9:15 PM, Zafar Iqbal ziqba...@gmail.com wrote: First run of code will create summary sheets 2400, 2401, 600, etc. Later on while updation new files data will be pasted below existing data in related summary sheets. Like 2400-08.xls will be pasted below existing last data in summary sheet 2400. On Jan 8, 2015 5:41 PM, Vaibhav Joshi v...@vabs.in wrote: what if there is sheet with name 2400, 2401 600 already exist? What about rest of file name? ᐧ + *I did not do this for you. God is here working through me for you.* On Thu, Jan 8, 2015 at 2:38 PM, Zafar Iqbal ziqba...@gmail.com wrote: Dear Experts, We are getting quick help from you. We appreciate your efforts, always. Attached Code copies a Range from Sheet1 from Selected files Paste in Active Sheet below each other. Kindly help in making this code more flexible as per below requirement. There are +400 excel files named as 2400-01.xls, 2400-02.xls, 2400-03.xls and so on 2401-01.xls, 2401-02.xls, 2401-03.xls and so on 600-01.xls, 600-02.xls, 600-03.xls and so. There are other groups with Names like 500*.xls, 700*.xls, 710*.xls, etc For files named 2400*.xls, code should create New Sheet Named as 2400 and paste in it Sheet1 Range from all 2400*.xls files. For files named 2401*.xls code should create New Sheet Named as 2401 and paste in it Sheet1 Range from all 2401*.xls files. For file named 600*.xls code should create New Sheet Named as 600 and paste in it Sheet1 Range from all 600*.xls files. Your guidance quick support always make our life comfortable. Thanks in advance for your help, please. Regards, Zafar Iqbal -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to a topic in the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this topic, visit https://groups.google.com/d/topic/excel-macros/ZPWVGa6U-LE/unsubscribe. To unsubscribe from this group and all its topics, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =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
Re: $$Excel-Macros$$ Copy Range From Files to Sheets
Dear expert, Summary sheets for other files like 710, 720, 725, 525, 3490, etc will be created when later on code will run and it will find such files. Thanks for your quick help. On Jan 8, 2015 5:41 PM, Vaibhav Joshi v...@vabs.in wrote: what if there is sheet with name 2400, 2401 600 already exist? What about rest of file name? ᐧ + *I did not do this for you. God is here working through me for you.* On Thu, Jan 8, 2015 at 2:38 PM, Zafar Iqbal ziqba...@gmail.com wrote: Dear Experts, We are getting quick help from you. We appreciate your efforts, always. Attached Code copies a Range from Sheet1 from Selected files Paste in Active Sheet below each other. Kindly help in making this code more flexible as per below requirement. There are +400 excel files named as 2400-01.xls, 2400-02.xls, 2400-03.xls and so on 2401-01.xls, 2401-02.xls, 2401-03.xls and so on 600-01.xls, 600-02.xls, 600-03.xls and so. There are other groups with Names like 500*.xls, 700*.xls, 710*.xls, etc For files named 2400*.xls, code should create New Sheet Named as 2400 and paste in it Sheet1 Range from all 2400*.xls files. For files named 2401*.xls code should create New Sheet Named as 2401 and paste in it Sheet1 Range from all 2401*.xls files. For file named 600*.xls code should create New Sheet Named as 600 and paste in it Sheet1 Range from all 600*.xls files. Your guidance quick support always make our life comfortable. Thanks in advance for your help, please. Regards, Zafar Iqbal -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to a topic in the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this topic, visit https://groups.google.com/d/topic/excel-macros/ZPWVGa6U-LE/unsubscribe. To unsubscribe from this group and all its topics, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =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
Re: $$Excel-Macros$$ Copy Range From Files to Sheets
Dear Expert, No need of replacement of existing data if it will be difficult to handle in big code. Thanks On Jan 8, 2015 6:46 PM, Vaibhav Joshi v...@vabs.in wrote: And what abt same records if exist.. wanna replace or keep duplicate records?? On Jan 8, 2015 9:15 PM, Zafar Iqbal ziqba...@gmail.com wrote: First run of code will create summary sheets 2400, 2401, 600, etc. Later on while updation new files data will be pasted below existing data in related summary sheets. Like 2400-08.xls will be pasted below existing last data in summary sheet 2400. On Jan 8, 2015 5:41 PM, Vaibhav Joshi v...@vabs.in wrote: what if there is sheet with name 2400, 2401 600 already exist? What about rest of file name? ᐧ + *I did not do this for you. God is here working through me for you.* On Thu, Jan 8, 2015 at 2:38 PM, Zafar Iqbal ziqba...@gmail.com wrote: Dear Experts, We are getting quick help from you. We appreciate your efforts, always. Attached Code copies a Range from Sheet1 from Selected files Paste in Active Sheet below each other. Kindly help in making this code more flexible as per below requirement. There are +400 excel files named as 2400-01.xls, 2400-02.xls, 2400-03.xls and so on 2401-01.xls, 2401-02.xls, 2401-03.xls and so on 600-01.xls, 600-02.xls, 600-03.xls and so. There are other groups with Names like 500*.xls, 700*.xls, 710*.xls, etc For files named 2400*.xls, code should create New Sheet Named as 2400 and paste in it Sheet1 Range from all 2400*.xls files. For files named 2401*.xls code should create New Sheet Named as 2401 and paste in it Sheet1 Range from all 2401*.xls files. For file named 600*.xls code should create New Sheet Named as 600 and paste in it Sheet1 Range from all 600*.xls files. Your guidance quick support always make our life comfortable. Thanks in advance for your help, please. Regards, Zafar Iqbal -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to a topic in the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this topic, visit https://groups.google.com/d/topic/excel-macros/ZPWVGa6U-LE/unsubscribe. To unsubscribe from this group and all its topics, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =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
Re: $$Excel-Macros$$ copy range
hey Don, i didnt get the sheet can re-send it again On Mar 9, 8:59 am, dguillett1 dguille...@gmail.com wrote: I sent a “solved macro for this” Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Selva Loganathan Sent: Thursday, March 08, 2012 8:31 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ copy range -- Forwarded message -- From: Selva Loganathan sendse...@gmail.com Date: Thu, Mar 8, 2012 at 2:07 AM Subject: copy range To: dguille...@gmail.com please look at sheet 1 thank you for all your help -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- --- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ copy range
I sent a “solved macro for this” Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Selva Loganathan Sent: Thursday, March 08, 2012 8:31 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ copy range -- Forwarded message -- From: Selva Loganathan sendse...@gmail.com Date: Thu, Mar 8, 2012 at 2:07 AM Subject: copy range To: dguille...@gmail.com please look at sheet 1 thank you for all your help -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ copy range
hi guys this is the file can you please take a look On Mar 8, 9:31 pm, Selva Loganathan sendse...@gmail.com wrote: -- Forwarded message -- From: Selva Loganathan sendse...@gmail.com Date: Thu, Mar 8, 2012 at 2:07 AM Subject: copy range To: dguille...@gmail.com please look at sheet 1 thank you for all your help test copy.xlsx 16KViewDownload -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ copy range
hey Don sorry to trouble you but for some reason i couldnt get this to work... i dont know how to attatch a file On Mar 6, 8:57 am, dguillett1 dguille...@gmail.com wrote: Try this. BTW you have NO Bob in field 7 Sub filterandcopyusedrange() Dim ds As Worksheet Set ds = Sheets(Sheet10) Cells.Find(*, Cells(Rows.Count, Columns.Count) _ , , , xlByRows, xlPrevious).Copy ds.Range(d1) With ActiveSheet.UsedRange .AutoFilter Field:=7, Criteria1:=bob .SpecialCells(xlCellTypeVisible).Copy ds.Range(a2) .AutoFilter End With End Sub Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com -Original Message- From: LearnExcel Sent: Monday, March 05, 2012 6:21 PM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ copy range Hi Guys/Girls i use VBA to copy a range using the following code Selection.AutoFilter Field:=7, Criteria1:=bob ActiveSheet.Range(a1:o1, ActiveSheet.Range(a1).End(xlDown)).Select the problem that i have is in cell G after the last cell there is a 3 lines of blank cell and then the report, once the filter is made i want the cell to also include theName report can anyone help? data name nam nam nam nam nam nam nam 3/5/2012 random john bob dog bob john new name nam 3/6/2012 random john bob dog bob john new name nam 3/6/2012 random john bob dog bob john new name nam 3/6/2012 bob dog bob john random random john bob 3/6/2012 john bob dog bob john random john bob 3/6/2012 random john bob dog bob john new name nam 3/6/2012 bob bob dog bob john random john bob 3/6/2012 random john bob bob random random john bob 3/6/2012 random john bob dog bob john new name nam Name report -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- --- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ copy range
send to dguillett1 @gmail.com Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com -Original Message- From: LearnExcel Sent: Wednesday, March 07, 2012 4:37 PM To: MS EXCEL AND VBA MACROS Subject: Re: $$Excel-Macros$$ copy range hey Don sorry to trouble you but for some reason i couldnt get this to work... i dont know how to attatch a file On Mar 6, 8:57 am, dguillett1 dguille...@gmail.com wrote: Try this. BTW you have NO Bob in field 7 Sub filterandcopyusedrange() Dim ds As Worksheet Set ds = Sheets(Sheet10) Cells.Find(*, Cells(Rows.Count, Columns.Count) _ , , , xlByRows, xlPrevious).Copy ds.Range(d1) With ActiveSheet.UsedRange .AutoFilter Field:=7, Criteria1:=bob .SpecialCells(xlCellTypeVisible).Copy ds.Range(a2) .AutoFilter End With End Sub Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com -Original Message- From: LearnExcel Sent: Monday, March 05, 2012 6:21 PM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ copy range Hi Guys/Girls i use VBA to copy a range using the following code Selection.AutoFilter Field:=7, Criteria1:=bob ActiveSheet.Range(a1:o1, ActiveSheet.Range(a1).End(xlDown)).Select the problem that i have is in cell G after the last cell there is a 3 lines of blank cell and then the report, once the filter is made i want the cell to also include theName report can anyone help? data name nam nam nam nam nam nam nam 3/5/2012 random john bob dog bob john new name nam 3/6/2012 random john bob dog bob john new name nam 3/6/2012 random john bob dog bob john new name nam 3/6/2012 bob dog bob john random random john bob 3/6/2012 john bob dog bob john random john bob 3/6/2012 random john bob dog bob john new name nam 3/6/2012 bob bob dog bob john random john bob 3/6/2012 random john bob bob random random john bob 3/6/2012 random john bob dog bob john new name nam Name report -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- --- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ copy range
Will be easier if you attach a sample file Sam On Tue, Mar 6, 2012 at 5:51 AM, LearnExcel sendse...@gmail.com wrote: Hi Guys/Girls i use VBA to copy a range using the following code Selection.AutoFilter Field:=7, Criteria1:=bob ActiveSheet.Range(a1:o1, ActiveSheet.Range(a1).End(xlDown)).Select the problem that i have is in cell G after the last cell there is a 3 lines of blank cell and then the report, once the filter is made i want the cell to also include theName report can anyone help? datanamenam nam nam nam nam nam nam 3/5/2012random johnbob dog bob johnnew name nam 3/6/2012random johnbob dog bob johnnew name nam 3/6/2012random johnbob dog bob johnnew name nam 3/6/2012bob dog bob johnrandom random johnbob 3/6/2012johnbob dog bob johnrandom johnbob 3/6/2012random johnbob dog bob johnnew name nam 3/6/2012bob bob dog bob johnrandom johnbob 3/6/2012random johnbob bob random random johnbob 3/6/2012random johnbob dog bob johnnew name nam Name report -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Sam Mathai Chacko -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ copy range
for some reason it wont work but you should be able to paste this data datanamenam nam nam nam nam nam nam 3/5/2012random johnbob dog bob johnnew namenam 3/6/2012random johnbob dog bob johnnew namenam 3/6/2012random johnbob dog bob johnnew namenam 3/6/2012bob dog bob johnrandom random johnbob 3/6/2012johnbob dog bob johnrandom johnbob 3/6/2012random johnbob dog bob johnnew namenam 3/6/2012bob bob dog bob johnrandom johnbob 3/6/2012random johnbob bob random random johnbob 3/6/2012random johnbob dog bob johnnew namenam Name report On Mar 6, 8:30 am, Sam Mathai Chacko samde...@gmail.com wrote: Will be easier if you attach a sample file Sam On Tue, Mar 6, 2012 at 5:51 AM, LearnExcel sendse...@gmail.com wrote: Hi Guys/Girls i use VBA to copy a range using the following code Selection.AutoFilter Field:=7, Criteria1:=bob ActiveSheet.Range(a1:o1, ActiveSheet.Range(a1).End(xlDown)).Select the problem that i have is in cell G after the last cell there is a 3 lines of blank cell and then the report, once the filter is made i want the cell to also include theName report can anyone help? data name nam nam nam nam nam nam nam 3/5/2012 random john bob dog bob john new name nam 3/6/2012 random john bob dog bob john new name nam 3/6/2012 random john bob dog bob john new name nam 3/6/2012 bob dog bob john random random john bob 3/6/2012 john bob dog bob john random john bob 3/6/2012 random john bob dog bob john new name nam 3/6/2012 bob bob dog bob john random john bob 3/6/2012 random john bob bob random random john bob 3/6/2012 random john bob dog bob john new name nam Name report -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- --- To post to this group, send email to excel-macros@googlegroups.com -- Sam Mathai Chacko -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
RE: $$Excel-Macros$$ copy range
Can you attached excel file pleaes?? -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of LearnExcel Sent: Mar/Tue/2012 07:16 To: MS EXCEL AND VBA MACROS Subject: Re: $$Excel-Macros$$ copy range for some reason it wont work but you should be able to paste this data datanamenam nam nam nam nam nam nam 3/5/2012random johnbob dog bob johnnew namenam 3/6/2012random johnbob dog bob johnnew namenam 3/6/2012random johnbob dog bob johnnew namenam 3/6/2012bob dog bob johnrandom random johnbob 3/6/2012johnbob dog bob johnrandom johnbob 3/6/2012random johnbob dog bob johnnew namenam 3/6/2012bob bob dog bob johnrandom johnbob 3/6/2012random johnbob bob random random johnbob 3/6/2012random johnbob dog bob johnnew namenam Name report On Mar 6, 8:30 am, Sam Mathai Chacko samde...@gmail.com wrote: Will be easier if you attach a sample file Sam On Tue, Mar 6, 2012 at 5:51 AM, LearnExcel sendse...@gmail.com wrote: Hi Guys/Girls i use VBA to copy a range using the following code Selection.AutoFilter Field:=7, Criteria1:=bob ActiveSheet.Range(a1:o1, ActiveSheet.Range(a1).End(xlDown)).Select the problem that i have is in cell G after the last cell there is a 3 lines of blank cell and then the report, once the filter is made i want the cell to also include theName report can anyone help? data name nam nam nam nam nam nam nam 3/5/2012 random john bob dog bob john new name nam 3/6/2012 random john bob dog bob john new name nam 3/6/2012 random john bob dog bob john new name nam 3/6/2012 bob dog bob john random random john bob 3/6/2012 john bob dog bob john random john bob 3/6/2012 random john bob dog bob john new name nam 3/6/2012 bob bob dog bob john random john bob 3/6/2012 random john bob bob random random john bob 3/6/2012 random john bob dog bob john new name nam Name report -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- --- To post to this group, send email to excel-macros@googlegroups.com -- Sam Mathai Chacko -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal
Re: $$Excel-Macros$$ copy range
Try this. BTW you have NO Bob in field 7 Sub filterandcopyusedrange() Dim ds As Worksheet Set ds = Sheets(Sheet10) Cells.Find(*, Cells(Rows.Count, Columns.Count) _ , , , xlByRows, xlPrevious).Copy ds.Range(d1) With ActiveSheet.UsedRange .AutoFilter Field:=7, Criteria1:=bob .SpecialCells(xlCellTypeVisible).Copy ds.Range(a2) .AutoFilter End With End Sub Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com -Original Message- From: LearnExcel Sent: Monday, March 05, 2012 6:21 PM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ copy range Hi Guys/Girls i use VBA to copy a range using the following code Selection.AutoFilter Field:=7, Criteria1:=bob ActiveSheet.Range(a1:o1, ActiveSheet.Range(a1).End(xlDown)).Select the problem that i have is in cell G after the last cell there is a 3 lines of blank cell and then the report, once the filter is made i want the cell to also include theName report can anyone help? data name nam nam nam nam nam nam nam 3/5/2012 random john bob dog bob john new name nam 3/6/2012 random john bob dog bob john new name nam 3/6/2012 random john bob dog bob john new name nam 3/6/2012 bob dog bob john random random john bob 3/6/2012 john bob dog bob john random john bob 3/6/2012 random john bob dog bob john new name nam 3/6/2012 bob bob dog bob john random john bob 3/6/2012 random john bob bob random random john bob 3/6/2012 random john bob dog bob john new name nam Name report -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
RE: $$Excel-Macros$$ copy range to other sheet but split it to 3 column
Yes yes Very god But I want it by code I want three column in one row And three column in the next row And three column in next row Thanks for help From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of roberto mensa Sent: Friday, November 26, 2010 1:47 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ copy range to other sheet but split it to 3 column try the file ... you can changed the number of columns for the split regards r -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts ref=ts -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
Re: $$Excel-Macros$$ copy range to other sheet but split it to 3 column
2010/11/26 عمر omar27...@gmail.com Yes yes Very god But I want it by code Sub test() Dim rng1 As Excel.Range Dim rng2 As Excel.Range On Error Resume Next Set rng1 = Intersect(ActiveSheet.UsedRange, Range(A:A)) Set rng1 = Application.InputBox( _ Select series, _ Input, rng1.Address, , , , , 8) If rng1 Is Nothing Then Exit Sub On Error GoTo 0 If rng1.Columns.Count 1 Then Exit Sub On Error Resume Next Set rng2 = Application.InputBox( _ Select range output, _ Output, rng1(1).Offset(, 1).Address, , , , , 8) If rng2 Is Nothing Then Exit Sub On Error GoTo 0 Set rng2 = rng2(1) traslation rng1, rng2 End Sub Sub traslation( _ rngI As Excel.Range, _ rngO As Excel.Range, _ Optional c As Long = 3) Dim r As Excel.Range, lRow As Long Dim lCol As Long For Each r In rngI rngO.Offset(lRow, lCol).Value = r.Value lCol = lCol + 1 If lCol = c Then lCol = 0 lRow = lRow + 1 End If Next End Sub regards r -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
Re: $$Excel-Macros$$ copy range to other sheet but split it to 3 column
try the file ... you can changed the number of columns for the split regards r -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts serie_n_columns.xls Description: MS-Excel spreadsheet