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