Re: $$Excel-Macros$$ Re: CLEAR CONTENTS of cells with value 0
Still Prob R/ Prince, I just 'recorded a macro just clicked in some cell G8 and stopped recording] and put your code in it., On exec. it says error, you may pl have a look Sub Macro1() ' ' Macro1 Macro ' Sheet1.range($A1$AZ1048576).clearcontents. ' Range(G8).Select End Sub Also is this method RIGHT ? [ The correct way pl. ] ALso sir, will it retain the other non-zero values. ? =mangal ho On 3/6/13, Prince prince141...@gmail.com wrote: By using VBA : Sheet1.range($A1$AZ1048576).clearcontents. regards prince On Tuesday, March 5, 2013 9:48:11 PM UTC+5:30, Somnath Khadilkar wrote: Dear Sir, I have ANY excel sheet ,some cells have value ZERO [ numeric 0 ]. I would like to BLANK or DELETE the numeric 0 , [Other cells may contain any ALPHA-NUMERIC values. ] Pl Help. =mangal ho -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out. 12.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ CLEAR CONTENTS of cells with value 0
Dear Sir, I have ANY excel sheet ,some cells have value ZERO [ numeric 0 ]. I would like to BLANK or DELETE the numeric 0 , [Other cells may contain any ALPHA-NUMERIC values. ] Pl Help. =mangal ho -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ SPLIT into many FILES , depeding UPON...
Sir , From our HO, we need to send to all CITY cerntre's offices/branches details pertaining to their specific figures. At HeadOffice we have total data for the entire system . Here say The Delhi offices need info pertaining to DELHI CITY/Off./Branches only. Furhter the item-xxx pertains to entries related to dept xxx , xxx/yyy/zzz etc.. cuold be many say 20 ! hence Delhi filter is just not enough, the xxx/yyy/zzz item code can be used to be more FOCUSSED, as such if, i cud generate say CITY * DEPT no of files I can AUTOMAIL the respective DEPT/CITY Centre. I hope I am clear. We have a tool to email automatically [ using some predefined naming structure. ] That I can use fully if I can SPLIT the BIG file into X * Y Tiny sheets. There will be colm D , E ... containg info about Date / Amount etc...I am again enclosing a file with filters . =Mangal Ho On 4/16/12, dguillett1 dguille...@gmail.com wrote: You need to provide a file with more info and a detailed explanation of what you want with examples. Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com -Original Message- From: Somnath Khadilkar Sent: Monday, April 09, 2012 11:58 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ SPLIT into many FILES , depeding UPON... Dear Sir, The foremost reason is I need to EMAIL this file to the Respective CityCircle, they require ONLY there own CITY info. The separate files so created will be saving lot of our SPACE .Currently anyway I am doing it MANUALLY [ rathersorry state!! ] Print out of the repo, we do at our HdOfice. and w/o a macro it takes too much of time...[ over five hundred LEFT clicks alone!! ] =mangal ho On 4/9/12, dguillett1 dguille...@gmail.com wrote: I haven't followed all of this but it seems to me that there is no reason for separate files. To get reports or print you can use filtering with/without macros and use only ONE file. Good design??? Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com -Original Message- From: Somnath Khadilkar Sent: Monday, April 09, 2012 9:58 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ one to many FILES , depeding upon filter condition Sir, there are many many colm.in the sheets [ that mighht complex the issue ] , but as a sample I am able to limit to the TWO fields and one QTY field. I need all the colm A thru C here in the RESPECTIVE files. --- issue 2. I am able to generate a datafile [ thru some 'C' code , can you guide me to 'CONVERT' these into XLS files thru some tool, [ w/o openining/saving individuay, as these are TOO many, I need to AUTOMAIL ] THIS is altogether a diff. issue, but any help will be highly appreciated ] =Mangal Ho On 4/9/12, Rajan_Verma rajanverma1...@gmail.com wrote: So , what the excel file will conatin? Only one Row? -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Somnath Khadilkar Sent: Apr/Mon/2012 08:11 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ one to many FILES , depeding upon filter condition Dear Sir, The attachment is file with more data in it [ only ONE work SHeet , say sheet1 ] 1. the col.A contains CITY code [ say currently upto 10 eg AHM, DEL, DEL.. ] 2. the col.B contains item-code say item-1, item-2, item-3...[ for that matter mango,apple,banana ] currently upto 25 distinct 'FRUITS' 3. Colm C contains just a number showing how many of these exists say 1,2, 600 etc.. now the output after running thr macro should be containining a subfolder say 'data' and XL files in it by name say AHM-item-1, AHM-item-10, [ if quantity exists for the perticular city/item-codeXX ] =mangal ho On 4/9/12, Rajan_Verma rajanverma1...@gmail.com wrote: Can you add more data and explain how you want to bifurcate the data? Rajan. -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Somnath Khadilkar Sent: Apr/Mon/2012 07:37 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ one to many FILES , depeding upon filter condition Dear Sir, I reqd the output to be upto say 25 * 10 distict FILES [ sir, not diff WorkSheets ] the names of these files will be combination of the 'CITY' and 'ITEM' code eg del-item001, hyd-item002, [ in a named subfolder, so that I can routinely keep track. ] thanks in adv. PS: if the file exists --- may be just OVERwrite it...[ if possible w/o prompting the user] =mangal ho On 4/9/12, Somnath Khadilkar khadilka...@gmail.com wrote: Dear Sir, MY request is to get the data into MULTIFLE FILES depending upon FILTER Selected. The file names should be say ahm-item-1, ahm-item-2 etc.. [ these will be unique combination] in a subdirectory named say XXYY, which will cotain ALL colms for the selected filters on col
Re: $$Excel-Macros$$ Most helpful Member - March 12- Don Guillett
Happy Birthday Mr. Don, May God Bless you with Long Life Peaceful Future Somnath Khadilkar On 4/14/12, Ayush Jain jainayus...@gmail.com wrote: Dear members, Don Guillett has been selected as 'Most Helpful Member' for the month of March'12 He has been helping forum members from long time consistently and we are proud to have him in the forum. He is business degree holder from University of Texas and retired Regional Manager for ING. Don, Many Many Thanks for your great contribution to forum. Keep Posting !! Best regards, Ayush Jain Group Manager, Microsoft MVP -- 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$$ one to many FILES , depeding upon filter condition
Sir, A while ago, you had sent me a file, [ which I am enclosing ] to convert the DATA file into MANY SHEETS depeding upon filter condition, That is V useful, but I would like to generate NewFIles [ instead of New Sheets in the same XL file, since, i want to email them [using AUTOmailer, but I reqd separate files], hence sir, i need your help. =mangal ho On 4/9/12, dguillett1 dguille...@gmail.com wrote: I haven't followed all of this but it seems to me that there is no reason for separate files. To get reports or print you can use filtering with/without macros and use only ONE file. Good design??? Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com -Original Message- From: Somnath Khadilkar Sent: Monday, April 09, 2012 9:58 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ one to many FILES , depeding upon filter condition Sir, there are many many colm.in the sheets [ that mighht complex the issue ] , but as a sample I am able to limit to the TWO fields and one QTY field. I need all the colm A thru C here in the RESPECTIVE files. --- issue 2. I am able to generate a datafile [ thru some 'C' code , can you guide me to 'CONVERT' these into XLS files thru some tool, [ w/o openining/saving individuay, as these are TOO many, I need to AUTOMAIL ] THIS is altogether a diff. issue, but any help will be highly appreciated ] =Mangal Ho On 4/9/12, Rajan_Verma rajanverma1...@gmail.com wrote: So , what the excel file will conatin? Only one Row? -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Somnath Khadilkar Sent: Apr/Mon/2012 08:11 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ one to many FILES , depeding upon filter condition Dear Sir, The attachment is file with more data in it [ only ONE work SHeet , say sheet1 ] 1. the col.A contains CITY code [ say currently upto 10 eg AHM, DEL, DEL.. ] 2. the col.B contains item-code say item-1, item-2, item-3...[ for that matter mango,apple,banana ] currently upto 25 distinct 'FRUITS' 3. Colm C contains just a number showing how many of these exists say 1,2, 600 etc.. now the output after running thr macro should be containining a subfolder say 'data' and XL files in it by name say AHM-item-1, AHM-item-10, [ if quantity exists for the perticular city/item-codeXX ] =mangal ho On 4/9/12, Rajan_Verma rajanverma1...@gmail.com wrote: Can you add more data and explain how you want to bifurcate the data? Rajan. -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Somnath Khadilkar Sent: Apr/Mon/2012 07:37 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ one to many FILES , depeding upon filter condition Dear Sir, I reqd the output to be upto say 25 * 10 distict FILES [ sir, not diff WorkSheets ] the names of these files will be combination of the 'CITY' and 'ITEM' code eg del-item001, hyd-item002, [ in a named subfolder, so that I can routinely keep track. ] thanks in adv. PS: if the file exists --- may be just OVERwrite it...[ if possible w/o prompting the user] =mangal ho On 4/9/12, Somnath Khadilkar khadilka...@gmail.com wrote: Dear Sir, MY request is to get the data into MULTIFLE FILES depending upon FILTER Selected. The file names should be say ahm-item-1, ahm-item-2 etc.. [ these will be unique combination] in a subdirectory named say XXYY, which will cotain ALL colms for the selected filters on col. A B so a unique list of cities say 10, and uniq list of items say 25 could generate upto 250 files. Pl help, attachment enclosed. =mangal ho -- 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
Re: $$Excel-Macros$$ one to many FILES , depeding upon filter condition
Dear Sir, I reqd the output to be upto say 25 * 10 distict FILES [ sir, not diff WorkSheets ] the names of these files will be combination of the 'CITY' and 'ITEM' code eg del-item001, hyd-item002, [ in a named subfolder, so that I can routinely keep track. ] thanks in adv. PS: if the file exists --- may be just OVERwrite it...[ if possible w/o prompting the user] =mangal ho On 4/9/12, Somnath Khadilkar khadilka...@gmail.com wrote: Dear Sir, MY request is to get the data into MULTIFLE FILES depending upon FILTER Selected. The file names should be say ahm-item-1, ahm-item-2 etc.. [ these will be unique combination] in a subdirectory named say XXYY, which will cotain ALL colms for the selected filters on col. A B so a unique list of cities say 10, and uniq list of items say 25 could generate upto 250 files. Pl help, attachment enclosed. =mangal ho -- 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 svk-sample.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ one to many FILES , depeding upon filter condition
Sir, there are many many colm.in the sheets [ that mighht complex the issue ] , but as a sample I am able to limit to the TWO fields and one QTY field. I need all the colm A thru C here in the RESPECTIVE files. --- issue 2. I am able to generate a datafile [ thru some 'C' code , can you guide me to 'CONVERT' these into XLS files thru some tool, [ w/o openining/saving individuay, as these are TOO many, I need to AUTOMAIL ] THIS is altogether a diff. issue, but any help will be highly appreciated ] =Mangal Ho On 4/9/12, Rajan_Verma rajanverma1...@gmail.com wrote: So , what the excel file will conatin? Only one Row? -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Somnath Khadilkar Sent: Apr/Mon/2012 08:11 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ one to many FILES , depeding upon filter condition Dear Sir, The attachment is file with more data in it [ only ONE work SHeet , say sheet1 ] 1. the col.A contains CITY code [ say currently upto 10 eg AHM, DEL, DEL.. ] 2. the col.B contains item-code say item-1, item-2, item-3...[ for that matter mango,apple,banana ] currently upto 25 distinct 'FRUITS' 3. Colm C contains just a number showing how many of these exists say 1,2, 600 etc.. now the output after running thr macro should be containining a subfolder say 'data' and XL files in it by name say AHM-item-1, AHM-item-10, [ if quantity exists for the perticular city/item-codeXX ] =mangal ho On 4/9/12, Rajan_Verma rajanverma1...@gmail.com wrote: Can you add more data and explain how you want to bifurcate the data? Rajan. -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Somnath Khadilkar Sent: Apr/Mon/2012 07:37 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ one to many FILES , depeding upon filter condition Dear Sir, I reqd the output to be upto say 25 * 10 distict FILES [ sir, not diff WorkSheets ] the names of these files will be combination of the 'CITY' and 'ITEM' code eg del-item001, hyd-item002, [ in a named subfolder, so that I can routinely keep track. ] thanks in adv. PS: if the file exists --- may be just OVERwrite it...[ if possible w/o prompting the user] =mangal ho On 4/9/12, Somnath Khadilkar khadilka...@gmail.com wrote: Dear Sir, MY request is to get the data into MULTIFLE FILES depending upon FILTER Selected. The file names should be say ahm-item-1, ahm-item-2 etc.. [ these will be unique combination] in a subdirectory named say XXYY, which will cotain ALL colms for the selected filters on col. A B so a unique list of cities say 10, and uniq list of items say 25 could generate upto 250 files. Pl help, attachment enclosed. =mangal ho -- 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
Re: $$Excel-Macros$$ SPLIT into many FILES , depeding UPON...
Dear Sir, The foremost reason is I need to EMAIL this file to the Respective CityCircle, they require ONLY there own CITY info. The separate files so created will be saving lot of our SPACE .Currently anyway I am doing it MANUALLY [ rathersorry state!! ] Print out of the repo, we do at our HdOfice. and w/o a macro it takes too much of time...[ over five hundred LEFT clicks alone!! ] =mangal ho On 4/9/12, dguillett1 dguille...@gmail.com wrote: I haven't followed all of this but it seems to me that there is no reason for separate files. To get reports or print you can use filtering with/without macros and use only ONE file. Good design??? Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com -Original Message- From: Somnath Khadilkar Sent: Monday, April 09, 2012 9:58 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ one to many FILES , depeding upon filter condition Sir, there are many many colm.in the sheets [ that mighht complex the issue ] , but as a sample I am able to limit to the TWO fields and one QTY field. I need all the colm A thru C here in the RESPECTIVE files. --- issue 2. I am able to generate a datafile [ thru some 'C' code , can you guide me to 'CONVERT' these into XLS files thru some tool, [ w/o openining/saving individuay, as these are TOO many, I need to AUTOMAIL ] THIS is altogether a diff. issue, but any help will be highly appreciated ] =Mangal Ho On 4/9/12, Rajan_Verma rajanverma1...@gmail.com wrote: So , what the excel file will conatin? Only one Row? -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Somnath Khadilkar Sent: Apr/Mon/2012 08:11 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ one to many FILES , depeding upon filter condition Dear Sir, The attachment is file with more data in it [ only ONE work SHeet , say sheet1 ] 1. the col.A contains CITY code [ say currently upto 10 eg AHM, DEL, DEL.. ] 2. the col.B contains item-code say item-1, item-2, item-3...[ for that matter mango,apple,banana ] currently upto 25 distinct 'FRUITS' 3. Colm C contains just a number showing how many of these exists say 1,2, 600 etc.. now the output after running thr macro should be containining a subfolder say 'data' and XL files in it by name say AHM-item-1, AHM-item-10, [ if quantity exists for the perticular city/item-codeXX ] =mangal ho On 4/9/12, Rajan_Verma rajanverma1...@gmail.com wrote: Can you add more data and explain how you want to bifurcate the data? Rajan. -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Somnath Khadilkar Sent: Apr/Mon/2012 07:37 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ one to many FILES , depeding upon filter condition Dear Sir, I reqd the output to be upto say 25 * 10 distict FILES [ sir, not diff WorkSheets ] the names of these files will be combination of the 'CITY' and 'ITEM' code eg del-item001, hyd-item002, [ in a named subfolder, so that I can routinely keep track. ] thanks in adv. PS: if the file exists --- may be just OVERwrite it...[ if possible w/o prompting the user] =mangal ho On 4/9/12, Somnath Khadilkar khadilka...@gmail.com wrote: Dear Sir, MY request is to get the data into MULTIFLE FILES depending upon FILTER Selected. The file names should be say ahm-item-1, ahm-item-2 etc.. [ these will be unique combination] in a subdirectory named say XXYY, which will cotain ALL colms for the selected filters on col. A B so a unique list of cities say 10, and uniq list of items say 25 could generate upto 250 files. Pl help, attachment enclosed. =mangal ho -- 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
Re: $$Excel-Macros$$ SPLIT into many FILES , depeding UPON...
Sir, A while ago, you had sent me a file, [ which I am enclosing ] to convert the DATA file into MANY SHEETS depeding upon filter condition, That is V useful, but I would like to generate NewFIles [ instead of New Sheets in the same XL file, since, i want to email them [using AUTOmailer, but I reqd separate files], hence sir, i need your help. =mangal ho On 4/10/12, dguillett1 dguille...@gmail.com wrote: A looping macro can be developed to filter the data and send it to each. Properly done you need only ONE mouse click. Or, if it takes awhile to run, set to run after you go home for the day. Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com -Original Message- From: Somnath Khadilkar Sent: Monday, April 09, 2012 11:58 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ SPLIT into many FILES , depeding UPON... Dear Sir, The foremost reason is I need to EMAIL this file to the Respective CityCircle, they require ONLY there own CITY info. The separate files so created will be saving lot of our SPACE .Currently anyway I am doing it MANUALLY [ rathersorry state!! ] Print out of the repo, we do at our HdOfice. and w/o a macro it takes too much of time...[ over five hundred LEFT clicks alone!! ] =mangal ho On 4/9/12, dguillett1 dguille...@gmail.com wrote: I haven't followed all of this but it seems to me that there is no reason for separate files. To get reports or print you can use filtering with/without macros and use only ONE file. Good design??? Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com -Original Message- From: Somnath Khadilkar Sent: Monday, April 09, 2012 9:58 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ one to many FILES , depeding upon filter condition Sir, there are many many colm.in the sheets [ that mighht complex the issue ] , but as a sample I am able to limit to the TWO fields and one QTY field. I need all the colm A thru C here in the RESPECTIVE files. --- issue 2. I am able to generate a datafile [ thru some 'C' code , can you guide me to 'CONVERT' these into XLS files thru some tool, [ w/o openining/saving individuay, as these are TOO many, I need to AUTOMAIL ] THIS is altogether a diff. issue, but any help will be highly appreciated ] =Mangal Ho On 4/9/12, Rajan_Verma rajanverma1...@gmail.com wrote: So , what the excel file will conatin? Only one Row? -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Somnath Khadilkar Sent: Apr/Mon/2012 08:11 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ one to many FILES , depeding upon filter condition Dear Sir, The attachment is file with more data in it [ only ONE work SHeet , say sheet1 ] 1. the col.A contains CITY code [ say currently upto 10 eg AHM, DEL, DEL.. ] 2. the col.B contains item-code say item-1, item-2, item-3...[ for that matter mango,apple,banana ] currently upto 25 distinct 'FRUITS' 3. Colm C contains just a number showing how many of these exists say 1,2, 600 etc.. now the output after running thr macro should be containining a subfolder say 'data' and XL files in it by name say AHM-item-1, AHM-item-10, [ if quantity exists for the perticular city/item-codeXX ] =mangal ho On 4/9/12, Rajan_Verma rajanverma1...@gmail.com wrote: Can you add more data and explain how you want to bifurcate the data? Rajan. -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Somnath Khadilkar Sent: Apr/Mon/2012 07:37 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ one to many FILES , depeding upon filter condition Dear Sir, I reqd the output to be upto say 25 * 10 distict FILES [ sir, not diff WorkSheets ] the names of these files will be combination of the 'CITY' and 'ITEM' code eg del-item001, hyd-item002, [ in a named subfolder, so that I can routinely keep track. ] thanks in adv. PS: if the file exists --- may be just OVERwrite it...[ if possible w/o prompting the user] =mangal ho On 4/9/12, Somnath Khadilkar khadilka...@gmail.com wrote: Dear Sir, MY request is to get the data into MULTIFLE FILES depending upon FILTER Selected. The file names should be say ahm-item-1, ahm-item-2 etc.. [ these will be unique combination] in a subdirectory named say XXYY, which will cotain ALL colms for the selected filters on col. A B so a unique list of cities say 10, and uniq list of items say 25 could generate upto 250 files. Pl help, attachment enclosed. =mangal ho -- 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
$$Excel-Macros$$ one to many FILES , depeding upon filter condition
Dear Sir, MY request is to get the data into MULTIFLE FILES depending upon FILTER Selected. The file names should be say ahm-item-1, ahm-item-2 etc.. [ these will be unique combination] in a subdirectory named say XXYY, which will cotain ALL colms for the selected filters on col. A B so a unique list of cities say 10, and uniq list of items say 25 could generate upto 250 files. Pl help, attachment enclosed. =mangal ho -- 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 svk-sample.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Need a small MACRO to SPLIT
Dear Sir, I am doing MOSTLY repetative tasks with the 'DATA'. Iam learning the use of the 'RECORDER' in the developer. I save this 'macro' recoring with diff. names. they are OK. What I need to learn is 1 How to do the tasks for TODAYS No. of record [ as this varies daily ] and my recorded macro is of THAT days record length. [ say 21000, and todays is say 21500 records, I guess you got it. ] =mangal ho On 2/6/12, dguillett1 dguille...@gmail.com wrote: Glad to help Don Guillett SalesAid Software dguille...@gmail.com -Original Message- From: Somnath Khadilkar Sent: Sunday, February 05, 2012 8:43 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Need a small MACRO to SPLIT Many thanks Don Guillett Sir, You hv done MORE than my requirement. =mangal ho [ GOD BLESS ] On 2/5/12, dguillett1 dguille...@gmail.com wrote: See Attached to make unique listfilter and copy to new sheets in file Don Guillett SalesAid Software dguille...@gmail.com -Original Message- From: Somnath Khadilkar Sent: Sunday, February 05, 2012 11:32 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Need a small MACRO to SPLIT Good even... I have attached a sample file depending upon colm A I need to split the whole DATA sheets into multiple sheets in the same/diff. file each sheets be named as per the COLM 'A', if possible. These entries are from few to many 100 K [ max distinct cities 25, however] =mangal ho Good Morning. I receive XL file comprising 1-sheet. Depending upon Colm 'A' I need to SPLIT this single sheet into MULTIPLE sheets [ with this colm as it name. ] The Distinct entries in this colm. would be less than say 25, but the no of entries cud be anything say 10 to 100 K. Regards You really need to give us details and send a file with a complete explanation. Don Guillett SalesAid Software dguille...@gmail.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 -- 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
$$Excel-Macros$$ Need a small MACRO to SPLIT Double Looping
Sir, Basically I Have rows of info. in 6/7 colm. depending upon the colm 1 and colm 2 entries i would like to make colm1 no of files with colm 2 no of sheets in them. I also need to introduce a S No. in each of the sheets. thats it. the data of say 100 rows * 7 Colm in a single XL file/sheet will be SLICED into col1 ffiles of colm 2 sheets with the remaining 3 thru 7 colm only. Well I need the S No 1 thru as many rows as a NEW Col in each sheet. If still unclear I will share a work file. [ I dont know if its called DOUBLE LOOPING ] On 2/24/12, Somnath Khadilkar khadilka...@gmail.com wrote: Sir, The MASTER sheet contains 7 - 8 colm. infomation viz. s no month sub nameroll no std mark 1 jan mathameya 1 X 10 what I need is 'months' of files of 'subject' sheets rest all is to be put as it is. so if there are 12 months and 3 subjects in MASTER all unique, the macro should produce 12 distict files [ with name as that of month ] each one having 3 sheets each row of these files contain remaining columns of MASTER and an addl S No colm. so the file jan will contain sheets only 'math' and the rows will be name roll no std mark ameya 1 X 10 smita 4 VIII40 indrani 7 IV 70 I need an addl. colm Sr No. so it shus contain s no nameroll no std mark 1 ameya 1 X 10 2 smita 4 VIII40 3 indrani 7 IV 70 if there are more months the addl sheets should be present. hope i have given one ex which might thro more light. =mangal ho On 2/24/12, dguillett1 dguille...@gmail.com wrote: From what you have provided, I have no idea what you want. You need to explain with EXAMPLES. Don Guillett SalesAid Software dguille...@gmail.com -Original Message- From: Somnath Khadilkar Sent: Friday, February 24, 2012 9:07 AM To: excel-macros@googlegroups.com Cc: dguille...@gmail.com Subject: $$Excel-Macros$$ Need a small MACRO to SPLIT Double Looping Dear Sir, Pl explain questions in a small para. I am enclosing a file this has col. on which I need separate XL files/sheets made. COLM D Thru F are say dummy.cud be more also. i) Separate files as per month[ col b ] ii) Separate sheets as per subjects[ col c ] Sheet names I got fro m you [ the unique city , but how to specify file names [ say I need combination of item and say DATE, or a variable... well I need to insert a row S. No in each sheet , of alll files [ to be populated 1,2,3... and in COLm 'A' ] [ Here I need say upto first 10 entries , if exists. ] On 2/6/12, dguillett1 dguille...@gmail.com wrote: Glad to help Don Guillett SalesAid Software dguille...@gmail.com -Original Message- From: Somnath Khadilkar Sent: Sunday, February 05, 2012 8:43 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Need a small MACRO to SPLIT Many thanks Don Guillett Sir, You hv done MORE than my requirement. =mangal ho [ GOD BLESS ] On 2/5/12, dguillett1 dguille...@gmail.com wrote: See Attached to make unique listfilter and copy to new sheets in file Don Guillett SalesAid Software dguille...@gmail.com -Original Message- From: Somnath Khadilkar Sent: Sunday, February 05, 2012 11:32 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Need a small MACRO to SPLIT Good even... I have attached a sample file depending upon colm A I need to split the whole DATA sheets into multiple sheets in the same/diff. file each sheets be named as per the COLM 'A', if possible. These entries are from few to many 100 K [ max distinct cities 25, however] =mangal ho Good Morning. I receive XL file comprising 1-sheet. Depending upon Colm 'A' I need to SPLIT this single sheet into MULTIPLE sheets [ with this colm as it name. ] The Distinct entries in this colm. would be less than say 25, but the no of entries cud be anything say 10 to 100 K. Regards You really need to give us details and send a file with a complete explanation. Don Guillett SalesAid Software dguille...@gmail.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
$$Excel-Macros$$ Need a small MACRO to SPLIT Double Looping
Dear Sir, Pl explain questions in a small para. I am enclosing a file this has col. on which I need separate XL files/sheets made. COLM D Thru F are say dummy.cud be more also. i) Separate files as per month[ col b ] ii) Separate sheets as per subjects[ col c ] Sheet names I got fro m you [ the unique city , but how to specify file names [ say I need combination of item and say DATE, or a variable... well I need to insert a row S. No in each sheet , of alll files [ to be populated 1,2,3... and in COLm 'A' ] [ Here I need say upto first 10 entries , if exists. ] On 2/6/12, dguillett1 dguille...@gmail.com wrote: Glad to help Don Guillett SalesAid Software dguille...@gmail.com -Original Message- From: Somnath Khadilkar Sent: Sunday, February 05, 2012 8:43 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Need a small MACRO to SPLIT Many thanks Don Guillett Sir, You hv done MORE than my requirement. =mangal ho [ GOD BLESS ] On 2/5/12, dguillett1 dguille...@gmail.com wrote: See Attached to make unique listfilter and copy to new sheets in file Don Guillett SalesAid Software dguille...@gmail.com -Original Message- From: Somnath Khadilkar Sent: Sunday, February 05, 2012 11:32 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Need a small MACRO to SPLIT Good even... I have attached a sample file depending upon colm A I need to split the whole DATA sheets into multiple sheets in the same/diff. file each sheets be named as per the COLM 'A', if possible. These entries are from few to many 100 K [ max distinct cities 25, however] =mangal ho Good Morning. I receive XL file comprising 1-sheet. Depending upon Colm 'A' I need to SPLIT this single sheet into MULTIPLE sheets [ with this colm as it name. ] The Distinct entries in this colm. would be less than say 25, but the no of entries cud be anything say 10 to 100 K. Regards You really need to give us details and send a file with a complete explanation. Don Guillett SalesAid Software dguille...@gmail.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 -- 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
$$Excel-Macros$$ Need a small MACRO to SPLIT
Good even... I have attached a sample file depending upon colm A I need to split the whole DATA sheets into multiple sheets in the same/diff. file each sheets be named as per the COLM 'A', if possible. These entries are from few to many 100 K [ max distinct cities 25, however] =mangal ho Good Morning. I receive XL file comprising 1-sheet. Depending upon Colm 'A' I need to SPLIT this single sheet into MULTIPLE sheets [ with this colm as it name. ] The Distinct entries in this colm. would be less than say 25, but the no of entries cud be anything say 10 to 100 K. Regards You really need to give us details and send a file with a complete explanation. Don Guillett SalesAid Software dguille...@gmail.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 sample.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Need a small MACRO to SPLIT
Many thanks Don Guillett Sir, You hv done MORE than my requirement. =mangal ho [ GOD BLESS ] On 2/5/12, dguillett1 dguille...@gmail.com wrote: See Attached to make unique listfilter and copy to new sheets in file Don Guillett SalesAid Software dguille...@gmail.com -Original Message- From: Somnath Khadilkar Sent: Sunday, February 05, 2012 11:32 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Need a small MACRO to SPLIT Good even... I have attached a sample file depending upon colm A I need to split the whole DATA sheets into multiple sheets in the same/diff. file each sheets be named as per the COLM 'A', if possible. These entries are from few to many 100 K [ max distinct cities 25, however] =mangal ho Good Morning. I receive XL file comprising 1-sheet. Depending upon Colm 'A' I need to SPLIT this single sheet into MULTIPLE sheets [ with this colm as it name. ] The Distinct entries in this colm. would be less than say 25, but the no of entries cud be anything say 10 to 100 K. Regards You really need to give us details and send a file with a complete explanation. Don Guillett SalesAid Software dguille...@gmail.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 -- 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
$$Excel-Macros$$ Need a small MACRO to SPLIT
Good Morning. I receive XL file comprising 1-sheet. Depending upon Colm 'A' I need to SPLIT this single sheet into MULTIPLE sheets [ with this colm as it name. ] The Distinct entries in this colm. would be less than say 25, but the no of entries cud be anything say 10 to 100 K. Regards -- 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