![]() ![]() Soooo, I can't create relationships in order to create a query. I also have tried to create tables from the pivots but it won't let me. I know that I need to have a few up to a bunch of Vlookups to accomplish this but I was wondering if there is a slightly different way to do the same. The form will have a month's worth of days listed per column (column C is, column D is, etc.) and the info below should correlate to the date and the employee. I need to be able to choose an agent from a drop down box and the info to auto populate on the form. The workbooks are large in size and is the reason I am working with multiple workbooks. Two of the tabs had multiple entries per employee and had to be comprised and get to one row per agent per day. I have the reports in an Excel 2013 workbook, a tab per report, and I created pivot tables to compile the info into what I need only in a different workbook. Not worried about the chart at this time. The information includes DOH, supervisor, a few phone metrics, sales info, and a chart. I have 7 reports that have certain info that I need to compile into a one page report per employee. I've a break from the other project and want to continue my momentum on this project.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |