I am putting together a departmental sales report in Excel. There will be 3 worksheets... one for raw daily sales data, one for a list of all current employees in the department, and one will will have the actual report. I cannot use VBA or macros since the bossman will be using Excel 2008 for Mac (unfortunately).
I actually had this finished using index/match etc etc, until the bossman informed me that the raw data included employees from other departments, whereas the sales report must only contain data for employees from my department.
Hence, I need a formula that will look at the employee code (employee initials) in the raw data, verify that it is a match of an employee in my department (same employee code), and then copy that employee code to a spot in the sales report. I want it to ignore any sales information from the raw data for an employee that is not in my department. From there, my index/match functions in the sales report can take over.
I should add that it would be nice if the sales report were able to dynamically adjust the line in which the column totals appear so that the totals appear on the first line below the last line of the table. The number of lines in the sales report could change from day to day.
I hope my explanation is clear. Any help would be greatly appreciated.
Bookmarks