Hello,
First, this forum has been a life saver for some of my vlookup and function woes. I spent some time this morning researching and testing a matching array for my latest problem but can't get it to work and I'm not sure if that is even the correct solution in this case. I know this should be a fairly basic solution so any help would be greatly appreciated.
My excel workbook is attached, Sheet1 lists my table of data. Column A (Charge #) lists unique number values. Column B - K lists hours associated with each charge number in Column A to each employee name. For example, in Cell B2 - Jake has 0 hours against the Row2 charge number. In Cell B3 Jake has 27 hours against Row3 charge number.
I am going to have a separate tab for each employee, and pull everything from this table. I want to be able to automatically pull and list only values greater than 0 for each employee, and report those hours along with the associated charge # in column A. I am not sure if I am explaining this well, but an example of what I am trying to automatically report for this example is on the "Jake" tab. Trying to avoid having separate pivot tables and filters for each employee.
Thank you for any advice.ExcelData.xlsx
Bookmarks