Hello everyone,
I've researched this a lot but I couldn't figure out how to accomplish it, so I'm turning for some help. Would appreciate any guidance in advance. The difficult part for me is that the same person could have a different role on different project code/streams. I'm doing it manually right now and sometimes I fill in the wrong rate. I'd love to automate that part of it.
So I have one tab where all the data is, where I fill in the weekly timesheets of resources. The columns are:
Date, Project Code, Stream, Name, Description, Rate, Hours Worked
So I wanted a way to automatically prefill the Rate column based on the data I have in another tab. That tab called AssignmentTracking and the columns are as follows:
Name, Role, Project Code, Stream, Assignment Start Date
1. John Smith, Developer, 123456, Packaging, Feb 01, 2018
2. John Smith, Business Analyst, 101010, Shipping, Feb 01, 2018
People send me their timesheets weekly, and I input the information into the first tracking tab. All is good except the rate bit I have trouble with, for the most part I have it memorized but I'd love to do something to automate it.
Thanks in advance for any help.
I've researched this a lot but I couldn't figure out how to accomplish it, so I'm turning for some help. Would appreciate any guidance in advance. The difficult part for me is that the same person could have a different role on different project code/streams. I'm doing it manually right now and sometimes I fill in the wrong rate. I'd love to automate that part of it.
So I have one tab where all the data is, where I fill in the weekly timesheets of resources. The columns are:
Date, Project Code, Stream, Name, Description, Rate, Hours Worked
So I wanted a way to automatically prefill the Rate column based on the data I have in another tab. That tab called AssignmentTracking and the columns are as follows:
Name, Role, Project Code, Stream, Assignment Start Date
1. John Smith, Developer, 123456, Packaging, Feb 01, 2018
2. John Smith, Business Analyst, 101010, Shipping, Feb 01, 2018
People send me their timesheets weekly, and I input the information into the first tracking tab. All is good except the rate bit I have trouble with, for the most part I have it memorized but I'd love to do something to automate it.
Thanks in advance for any help.