help to create a work roster
$10-30 AUD
Pagado a la entrega
Hi I need help to create a roster that pulls from data from a master roster.
for example:
will need to look up the technicians details by his employment number and the copy the entire row.
I have used the = and the cell and used the drag function but because the master roster row numbers always change when they add new people it then pull the wrong persons data into my new roster.
I was thinking maybe can use the Index and Match function?
Please assist
Ethan
Nº del proyecto: #18197639
Sobre el proyecto
Adjudicado a:
High level experience with Excel, Google Docs and Research while working as a data analyst for top firms such as Accenture and Ernst & Young. Over 3+ years of US experience along with a Master's Degree in Information M Más
5 freelancers están ofertando un promedio de $70 por este trabajo
Hello, Hope you are doing well. I can help with you in your project create a work roster. I can assure you the quality job. I have good experience in Excel. We have worked on several similar projects before! Más
1. I am an expert in Excel, Excel formulas, and all excel functions, macros, lookup, pivot tables and charts. 2. Have done many projects in Excel, created many dashboards, and Business intelligence tool for forex mar Más
"Hi Dear, I’m an efficient data entry worker. I’m familiar with Google docs spreadsheet and I’ve experienced about collecting data from websites and enter into Excel and Google docs spreadsheet. I would love to tell Más
I can provide you what you need for I am a freelance data encoder. I have been in this business for 13 years.