Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help Required
D/all I have a data which contain the details of credit & debit of clients....each customer has its own customer code No. in one column and name on other, I want to create a macro which can split the data in different workbook & save it with the customer name mentioned in data file & further if possible send to the e mail id's Thanks & Regards, Amol |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help Required
Ron de Bruin has an addin that does the separation into different worksheets
(within the same workbook, I think). Ron de Bruin's EasyFilter addin: http://www.rondebruin.nl/easyfilter.htm He also has an addin for integrating emails: http://www.rondebruin.nl/mail/add-in.htm If you want more control, Debra Dalgleish has some sample code: http://www.contextures.com/excelfiles.html Create New Sheets from Filtered List -- uses an Advanced Filter to create separate sheet of orders for each sales rep visible in a filtered list; macro automates the filter. AdvFilterRepFiltered.xls 35 kb Update Sheets from Master -- uses an Advanced Filter to send data from Master sheet to individual worksheets -- replaces old data with current. AdvFilterCity.xls 55 kb And Ron has lots of mailing tips/code samples he http://www.rondebruin.nl/sendmail.htm Amol wrote: D/all I have a data which contain the details of credit & debit of clients....each customer has its own customer code No. in one column and name on other, I want to create a macro which can split the data in different workbook & save it with the customer name mentioned in data file & further if possible send to the e mail id's Thanks & Regards, Amol -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help Required
I believe on Debra's site there is not a example to split in workbooks
I have one on this page http://www.rondebruin.nl/copy5.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Dave Peterson" wrote in message ... Ron de Bruin has an addin that does the separation into different worksheets (within the same workbook, I think). Ron de Bruin's EasyFilter addin: http://www.rondebruin.nl/easyfilter.htm He also has an addin for integrating emails: http://www.rondebruin.nl/mail/add-in.htm If you want more control, Debra Dalgleish has some sample code: http://www.contextures.com/excelfiles.html Create New Sheets from Filtered List -- uses an Advanced Filter to create separate sheet of orders for each sales rep visible in a filtered list; macro automates the filter. AdvFilterRepFiltered.xls 35 kb Update Sheets from Master -- uses an Advanced Filter to send data from Master sheet to individual worksheets -- replaces old data with current. AdvFilterCity.xls 55 kb And Ron has lots of mailing tips/code samples he http://www.rondebruin.nl/sendmail.htm Amol wrote: D/all I have a data which contain the details of credit & debit of clients....each customer has its own customer code No. in one column and name on other, I want to create a macro which can split the data in different workbook & save it with the customer name mentioned in data file & further if possible send to the e mail id's Thanks & Regards, Amol -- Dave Peterson |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help Required
Yep. The code would have to be modified to create a new worksheet in a new
workbook. But I was thinking that the OP would end up using your code to email each worksheet--so that location of the intermediate worksheet wouldn't be too important. (Well, not important to me--maybe very important to the OP, though!) Ron de Bruin wrote: I believe on Debra's site there is not a example to split in workbooks I have one on this page http://www.rondebruin.nl/copy5.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Dave Peterson" wrote in message ... Ron de Bruin has an addin that does the separation into different worksheets (within the same workbook, I think). Ron de Bruin's EasyFilter addin: http://www.rondebruin.nl/easyfilter.htm He also has an addin for integrating emails: http://www.rondebruin.nl/mail/add-in.htm If you want more control, Debra Dalgleish has some sample code: http://www.contextures.com/excelfiles.html Create New Sheets from Filtered List -- uses an Advanced Filter to create separate sheet of orders for each sales rep visible in a filtered list; macro automates the filter. AdvFilterRepFiltered.xls 35 kb Update Sheets from Master -- uses an Advanced Filter to send data from Master sheet to individual worksheets -- replaces old data with current. AdvFilterCity.xls 55 kb And Ron has lots of mailing tips/code samples he http://www.rondebruin.nl/sendmail.htm Amol wrote: D/all I have a data which contain the details of credit & debit of clients....each customer has its own customer code No. in one column and name on other, I want to create a macro which can split the data in different workbook & save it with the customer name mentioned in data file & further if possible send to the e mail id's Thanks & Regards, Amol -- Dave Peterson -- Dave Peterson |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help Required
On Jul 15, 4:58 pm, Dave Peterson wrote:
Yep. The code would have to be modified to create a new worksheet in a new workbook. But I was thinking that the OP would end up using your code to email each worksheet--so that location of the intermediate worksheet wouldn't be too important. (Well, not important to me--maybe very important to the OP, though!) Ron de Bruin wrote: I believe on Debra's site there is not a example to split in workbooks I have one on this page http://www.rondebruin.nl/copy5.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Dave Peterson" wrote in ... Ron de Bruin has an addin that does the separation into different worksheets (within the same workbook, I think). Ron de Bruin's EasyFilter addin: http://www.rondebruin.nl/easyfilter.htm He also has an addin for integrating emails: http://www.rondebruin.nl/mail/add-in.htm If you want more control, Debra Dalgleish has some sample code: http://www.contextures.com/excelfiles.html Create New Sheets from Filtered List -- uses an Advanced Filter to create separate sheet of orders for each sales rep visible in a filtered list; macro automates the filter. AdvFilterRepFiltered.xls 35 kb Update Sheets from Master -- uses an Advanced Filter to send data from Master sheet to individual worksheets -- replaces old data with current. AdvFilterCity.xls 55 kb And Ron has lots of mailing tips/code samples he http://www.rondebruin.nl/sendmail.htm Amol wrote: D/all I have a data which contain the details of credit & debit of clients....each customer has its own customer code No. in one column and name on other, I want to create a macro which can split the data in different workbook & save it with the customer name mentioned in data file & further if possible send to the e mail id's Thanks & Regards, Amol -- Dave Peterson -- Dave Peterson- Hide quoted text - - Show quoted text - Thanxs for reply...But as i am new to the macro, pls tell me which query is the most suitable to fulfil my requirements |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help Required
On Jul 15, 5:43 pm, Amol wrote:
On Jul 15, 4:58 pm, Dave Peterson wrote: Yep. The code would have to be modified to create a new worksheet in a new workbook. But I was thinking that the OP would end up using your code to email each worksheet--so that location of the intermediate worksheet wouldn't be too important. (Well, not important to me--maybe very important to the OP, though!) Ron de Bruin wrote: I believe on Debra's site there is not a example to split in workbooks I have one on this page http://www.rondebruin.nl/copy5.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Dave Peterson" wrote in ... Ron de Bruin has an addin that does the separation into different worksheets (within the same workbook, I think). Ron de Bruin's EasyFilter addin: http://www.rondebruin.nl/easyfilter.htm He also has an addin for integrating emails: http://www.rondebruin.nl/mail/add-in.htm If you want more control, Debra Dalgleish has some sample code: http://www.contextures.com/excelfiles.html Create New Sheets from Filtered List -- uses an Advanced Filter to create separate sheet of orders for each sales rep visible in a filtered list; macro automates the filter. AdvFilterRepFiltered.xls 35 kb Update Sheets from Master -- uses an Advanced Filter to send data from Master sheet to individual worksheets -- replaces old data with current. AdvFilterCity.xls 55 kb And Ron has lots of mailing tips/code samples he http://www.rondebruin.nl/sendmail.htm Amol wrote: D/all I have a data which contain the details of credit & debit of clients....each customer has its own customer code No. in one column and name on other, I want to create a macro which can split the data in different workbook & save it with the customer name mentioned in data file & further if possible send to the e mail id's Thanks & Regards, Amol -- Dave Peterson -- Dave Peterson- Hide quoted text - - Show quoted text - Thanxs for reply...But as i am new to the macro, pls tell me which query is the most suitable to fulfil my requirements- Hide quoted text - - Show quoted text - I want to slipt below data in different workbook with file name "Daily Credit Report Dt " followed by "Customer Name" Customer Code Customer Name Cr/Dr Chq No. Amt Drawer Name 123456 Mumbai Enterprises C 12345 125.00 123 7891011 Delhi Enterprises C 45785 110.00 3215 12131415 Bangalore Enterprises C 123 155.00 1321 |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help Required
If you're new to macros, I'd bet that Ron's code and addins will be easier to
implement. Amol wrote: On Jul 15, 4:58 pm, Dave Peterson wrote: Yep. The code would have to be modified to create a new worksheet in a new workbook. But I was thinking that the OP would end up using your code to email each worksheet--so that location of the intermediate worksheet wouldn't be too important. (Well, not important to me--maybe very important to the OP, though!) Ron de Bruin wrote: I believe on Debra's site there is not a example to split in workbooks I have one on this page http://www.rondebruin.nl/copy5.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Dave Peterson" wrote in ... Ron de Bruin has an addin that does the separation into different worksheets (within the same workbook, I think). Ron de Bruin's EasyFilter addin: http://www.rondebruin.nl/easyfilter.htm He also has an addin for integrating emails: http://www.rondebruin.nl/mail/add-in.htm If you want more control, Debra Dalgleish has some sample code: http://www.contextures.com/excelfiles.html Create New Sheets from Filtered List -- uses an Advanced Filter to create separate sheet of orders for each sales rep visible in a filtered list; macro automates the filter. AdvFilterRepFiltered.xls 35 kb Update Sheets from Master -- uses an Advanced Filter to send data from Master sheet to individual worksheets -- replaces old data with current. AdvFilterCity.xls 55 kb And Ron has lots of mailing tips/code samples he http://www.rondebruin.nl/sendmail.htm Amol wrote: D/all I have a data which contain the details of credit & debit of clients....each customer has its own customer code No. in one column and name on other, I want to create a macro which can split the data in different workbook & save it with the customer name mentioned in data file & further if possible send to the e mail id's Thanks & Regards, Amol -- Dave Peterson -- Dave Peterson- Hide quoted text - - Show quoted text - Thanxs for reply...But as i am new to the macro, pls tell me which query is the most suitable to fulfil my requirements -- Dave Peterson |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help Required
On Jul 15, 6:30 pm, Dave Peterson wrote:
If you're new to macros, I'd bet that Ron's code and addins will be easier to implement. Amol wrote: On Jul 15, 4:58 pm, Dave Peterson wrote: Yep. The code would have to be modified to create a new worksheet in a new workbook. But I was thinking that the OP would end up using your code to email each worksheet--so that location of the intermediate worksheet wouldn't be too important. (Well, not important to me--maybe very important to the OP, though!) Ron de Bruin wrote: I believe on Debra's site there is not a example to split in workbooks I have one on this page http://www.rondebruin.nl/copy5.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Dave Peterson" wrote in ... Ron de Bruin has an addin that does the separation into different worksheets (within the same workbook, I think). Ron de Bruin's EasyFilter addin: http://www.rondebruin.nl/easyfilter.htm He also has an addin for integrating emails: http://www.rondebruin.nl/mail/add-in.htm If you want more control, Debra Dalgleish has some sample code: http://www.contextures.com/excelfiles.html Create New Sheets from Filtered List -- uses an Advanced Filter to create separate sheet of orders for each sales rep visible in a filtered list; macro automates the filter. AdvFilterRepFiltered.xls 35 kb Update Sheets from Master -- uses an Advanced Filter to send data from Master sheet to individual worksheets -- replaces old data with current. AdvFilterCity.xls 55 kb And Ron has lots of mailing tips/code samples he http://www.rondebruin.nl/sendmail.htm Amol wrote: D/all I have a data which contain the details of credit & debit of clients....each customer has its own customer code No. in one column and name on other, I want to create a macro which can split the data in different workbook & save it with the customer name mentioned in data file & further if possible send to the e mail id's Thanks & Regards, Amol -- Dave Peterson -- Dave Peterson- Hide quoted text - - Show quoted text - Thanxs for reply...But as i am new to the macro, pls tell me which query is the most suitable to fulfil my requirements -- Dave Peterson- Hide quoted text - - Show quoted text - dave thanxs for your help....its realy working fine...but only problem i face now is the column which contains unique number got deleted from main file & file got saved with the name VALUE = before it & some of column also got deleted which was blank. i want same header to be copied in new workbook with the file name as unique customer code........ Hope u help me in this matter....it will saved around 2 hours of my routine work |
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help Required
You may have to go back to one of your backup versions if your workbook was
saved after you deleted that column. And Ron's EasyFilter code is protected. You won't be able to change that. I guess if you want more control, you'll have to spend some time learning to modify the code on the page Ron suggested (or spend time modifying Debra's code). Amol wrote: On Jul 15, 6:30 pm, Dave Peterson wrote: If you're new to macros, I'd bet that Ron's code and addins will be easier to implement. Amol wrote: On Jul 15, 4:58 pm, Dave Peterson wrote: Yep. The code would have to be modified to create a new worksheet in a new workbook. But I was thinking that the OP would end up using your code to email each worksheet--so that location of the intermediate worksheet wouldn't be too important. (Well, not important to me--maybe very important to the OP, though!) Ron de Bruin wrote: I believe on Debra's site there is not a example to split in workbooks I have one on this page http://www.rondebruin.nl/copy5.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Dave Peterson" wrote in ... Ron de Bruin has an addin that does the separation into different worksheets (within the same workbook, I think). Ron de Bruin's EasyFilter addin: http://www.rondebruin.nl/easyfilter.htm He also has an addin for integrating emails: http://www.rondebruin.nl/mail/add-in.htm If you want more control, Debra Dalgleish has some sample code: http://www.contextures.com/excelfiles.html Create New Sheets from Filtered List -- uses an Advanced Filter to create separate sheet of orders for each sales rep visible in a filtered list; macro automates the filter. AdvFilterRepFiltered.xls 35 kb Update Sheets from Master -- uses an Advanced Filter to send data from Master sheet to individual worksheets -- replaces old data with current. AdvFilterCity.xls 55 kb And Ron has lots of mailing tips/code samples he http://www.rondebruin.nl/sendmail.htm Amol wrote: D/all I have a data which contain the details of credit & debit of clients....each customer has its own customer code No. in one column and name on other, I want to create a macro which can split the data in different workbook & save it with the customer name mentioned in data file & further if possible send to the e mail id's Thanks & Regards, Amol -- Dave Peterson -- Dave Peterson- Hide quoted text - - Show quoted text - Thanxs for reply...But as i am new to the macro, pls tell me which query is the most suitable to fulfil my requirements -- Dave Peterson- Hide quoted text - - Show quoted text - dave thanxs for your help....its realy working fine...but only problem i face now is the column which contains unique number got deleted from main file & file got saved with the name VALUE = before it & some of column also got deleted which was blank. i want same header to be copied in new workbook with the file name as unique customer code........ Hope u help me in this matter....it will saved around 2 hours of my routine work -- Dave Peterson |
#10
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help Required
On Jul 16, 12:15 am, Dave Peterson wrote:
You may have to go back to one of your backup versions if your workbook was saved after you deleted that column. And Ron's EasyFilter code is protected. You won't be able to change that. I guess if you want more control, you'll have to spend some time learning to modify the code on the page Ron suggested (or spend time modifying Debra's code). Amol wrote: On Jul 15, 6:30 pm, Dave Peterson wrote: If you're new to macros, I'd bet that Ron's code and addins will be easier to implement. Amol wrote: On Jul 15, 4:58 pm, Dave Peterson wrote: Yep. The code would have to be modified to create a new worksheet in a new workbook. But I was thinking that the OP would end up using your code to email each worksheet--so that location of the intermediate worksheet wouldn't be too important. (Well, not important to me--maybe very important to the OP, though!) Ron de Bruin wrote: I believe on Debra's site there is not a example to split in workbooks I have one on this page http://www.rondebruin.nl/copy5.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Dave Peterson" wrote in ... Ron de Bruin has an addin that does the separation into different worksheets (within the same workbook, I think). Ron de Bruin's EasyFilter addin: http://www.rondebruin.nl/easyfilter.htm He also has an addin for integrating emails: http://www.rondebruin.nl/mail/add-in.htm If you want more control, Debra Dalgleish has some sample code: http://www.contextures.com/excelfiles.html Create New Sheets from Filtered List -- uses an Advanced Filter to create separate sheet of orders for each sales rep visible in a filtered list; macro automates the filter. AdvFilterRepFiltered.xls 35 kb Update Sheets from Master -- uses an Advanced Filter to send data from Master sheet to individual worksheets -- replaces old data with current. AdvFilterCity.xls 55 kb And Ron has lots of mailing tips/code samples he http://www.rondebruin.nl/sendmail.htm Amol wrote: D/all I have a data which contain the details of credit & debit of clients....each customer has its own customer code No. in one column and name on other, I want to create a macro which can split the data in different workbook & save it with the customer name mentioned in data file & further if possible send to the e mail id's Thanks & Regards, Amol -- Dave Peterson -- Dave Peterson- Hide quoted text - - Show quoted text - Thanxs for reply...But as i am new to the macro, pls tell me which query is the most suitable to fulfil my requirements -- Dave Peterson- Hide quoted text - - Show quoted text - dave thanxs for your help....its realy working fine...but only problem i face now is the column which contains unique number got deleted from main file & file got saved with the name VALUE = before it & some of column also got deleted which was blank. i want same header to be copied in new workbook with the file name as unique customer code........ Hope u help me in this matter....it will saved around 2 hours of my routine work -- Dave Peterson- Hide quoted text - - Show quoted text - thanxs again for your suggestion can u tell me any link which can guide me to create macro...as it is hard to know the meaning of query language. Why we use dim, (), / Sub etc etc |
#11
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help Required
If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm And Tushar Mehta's site: http://www.tushar-mehta.com/excel/vba/ http://www.tushar-mehta.com/excel/vb...rder/index.htm Amol wrote: <<snipped thanxs again for your suggestion can u tell me any link which can guide me to create macro...as it is hard to know the meaning of query language. Why we use dim, (), / Sub etc etc -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HELP ON SUM - REQUIRED | Excel Worksheet Functions | |||
Help required .... | Excel Worksheet Functions | |||
Further help required please :) | Excel Programming | |||
Bit of help required. | Excel Programming | |||
New to VBA - help required please. | Excel Programming |