help to create a work roster

Finalizat Postat la acum 5 ani S-au achitat serviciile după ce au fost prestate
Finalizat S-au achitat serviciile după ce au fost prestate

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 Proiect: #18197639

Detalii despre proiect

5 propuneri Proiect la distanță Activ acum 5 ani

Acordat lui:

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 Mai multe

%selectedBids___i_sum_sub_4%%project_currencyDetails_sign_sub_5% AUD în 1 zi
(1 părere)
1.0

5 freelanceri plasează o ofertă medie de 70$ pentru proiect

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! Mai multe

$100 AUD în 2 zile
(384 recenzii)
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 Mai multe

$100 AUD în 3 zile
(73 recenzii)
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 Mai multe

$100 AUD în 1 zi
(18 recenzii)
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 în 1 zi
(0 recenzii)
0.0