Hi all, I have to print salary slips and bank transfer letters for 600 employees at each month end. I have created a database in excel linked to word mail merge so it is easy to print salary slips by selecting the relevant fields. However, salary transfer letters had to be created by linking each employee to relevant bank letter. It was devised to input salary transfer information in the database and use pivot table to create letters for different banks in excel.
The problem aroused when a specific bank required that there should be no more than 9 employees per letter; which means that if salary of 70 employees had to be transferred through Bank A, 8 different letters must be made for that bank. Is it possible to somehow configure the pivot table to show only 9 results per letter and for further 9 results new letter created automatically, or is there any other solution to such problem? Any suggestions are welcomed. -- ---------------------------------------------------------------------------------- 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&ref=ts
