Help Required

[Amol]

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]

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 here:
http://www.rondebruin.nl/sendmail.htm

 

[Ron de Bruin]

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

 

[Dave Peterson]

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!)

 

[Amol]

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!)








--

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

 

[Amol]

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

 

[Dave Peterson]

If you're new to macros, I'd bet that Ron's code and addins will be easier to
implement.

 

[Amol]

If you're new to macros, I'd bet that Ron's code and addins will be easier to
implement.







--

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]

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]

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).






--

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

 

[Dave Peterson]

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/vba/beyond_the_macro_recorder/index.htm


Amol wrote: