help to create a work roster

Виконано Опубліковано %project.relative_time Оплачується при отриманні
Виконано Оплачується при отриманні

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

Excel

ID Проекту: #18197639

Про проект

5 заявок(-ки) Дистанційний проект Остання активність 5 роки(ів) тому

Доручено:

keerthanakumar90

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 Більше

$25 AUD за 1 день
(1 відгук)
1.0

5 фрілансерів(-и) готові виконати цю роботу у середньому за $70

schoudhary1553

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! Більше

$100 AUD за 2 дні(-в)
(384 відгуків(и))
8.2
citijayamala

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 Більше

$100 AUD за 3 дні(-в)
(73 відгуків(и))
6.1
dataexplorer

"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 Більше

$100 AUD за 1 день
(18 відгуків(и))
4.3
coolviper01

I can provide you what you need for I am a freelance data encoder. I have been in this business for 13 years.

$25 AUD за 1 день
(0 відгуків(и))
0.0