*** Updated post with Workbook Upload***
Hello- This website has been immensely helpful to me as I've been doing a crash course of sorts in Excel for my job. I'm especially fond of "copy/paste link" to automatically duplicate info onto different worksheets.
But now I'm stumped. I need to automate data entry from one worksheet tracking time per project into another that serves as an invoice. My problem is that this involves bringing over both both nominal and quantitative data (i.e., employee's name/role and # hours worked). I am tracking hours worked on each project (x axis) by each employee (y axis). If they worked any hours on a project (project hrs cell>0), then I need their name and role to appear on the invoice page along with the number of hours worked. If not, then I don't want their name to appear on the invoice under that particular project, even with a 0 hrs listed by their name.
Is there a way to do something like =IF(project hrs cell>0, "John Doe Architect" + project hrs cell, 0) wherein i don't have to separate the nominal and quantitative data? And instead of having 0 as the alternate,... just have nothing?
Lastly, if an employee doesn't work any hours on a project, how can I make the next employee who does work on the project have their data transferred to the invoice without any empty rows in between? Is this possible?
machead prob.xlsx (apologies any odd formatting- had to edit and upload this on my mac from home, which has Numbers instead of Excel.
Thank you !!!
Bookmarks