Hi, I have the pleasure of tracking telephone Automated Call Distribution calls (ACD for short) for a department. I have loaded 4 files ACD_R1 through ACD_R4 for this discussion
Every Monday I receive a PDF file that lists calls received by each group for the previous week (Monday through Friday). I enter them directly into ACD_R1 & save the file and name ACD_R1 for each week of the month. After I have accumulated the whole month’s worth of ACD_R1 I enter them into ACD_R_2. I have to manually do this. ACD_R_2 does accumulate monthly totals for me. I then take the monthly numbers from ACD_R_2 & enter them into ACD_R_3. Finally I take the totals from ACD_R_3 and enter them into ACD_R_4 and graph the data. As you can see it’s very tedious and prone to a lot of mistakes. I need some guidance on how best to do the above task combine them some how into one spreadsheet with various tabs. Any ideas will be welcome; I hope I explained it alright, please post here or email me for further clarification. -- ---------------------------------------------------------------------------------- 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
