Copy certain rows to new tab in XL

Completed Posted 7 years ago Paid on delivery
Completed Paid on delivery

I want to copy/paste certain rows of data from a large XL file.

I have an XL file with 2 tabs. The first tab contains about 63,000 rows of data. The second tab has about 1600 rows, but the rows are incomplete, except for the "ID" in column A.

All of the "ID"s in the second tab are contained somewhere in the first.

I want to find all the rows in the first tab, with the same ID as the rows in the second tab, and I want the information from each of these rows moved into the rows on the second tab.

I already did about 120 manually, but I'm sick of it. But you can see, by looking at what I've already done, what I'm trying to accomplish. I've included screenshots of both tabs for your assistance. When I accept the bid, I'll upload the actual XL file, but I don't want to blast it all over the place.

Good luck.

Data Entry Excel

Project ID: #11044306

About the project

18 proposals Remote project Active 7 years ago

Awarded to:

$10 USD in 1 day
(190 Reviews)
6.2

18 freelancers are bidding on average $32 for this job

schoudhary1553

Dear Project poster, I have 5 years of experience. I am looking for projects. I can complete your project with in 2 day. Looking forward to hear from you. Let me give an opportunity to work. We can talk fu More

$25 USD in 1 day
(355 Reviews)
8.0
Khurramz

Hi! Didn't you try vlookup or index match function of excel? No need to do manually. .

$30 USD in 1 day
(396 Reviews)
7.6
khushh07

Hi, I understand the project requirements and willing to start as soon as possible. Kindly share the details and I will deliver with high quality. Looking forward to work with you. Thanks & Regards Khushi India

$28 USD in 0 days
(310 Reviews)
7.2
Tanmoy236

I am extremely good with excel as it is part of my daily professional work. I am fast accurate and at the same time understand the value of quality and deadlines. I have already done 90 works on Freelancer where majori More

$30 USD in 1 day
(271 Reviews)
7.0
hummerx

I can start working on this right away. I am a full time freelancer and you can expect complete dedication. If you're interested, please contact me. Thank you!

$25 USD in 1 day
(66 Reviews)
6.1
Rajni0802

Hello, I have reviewed both images as well as the project instructions and can do this task of copy/paste certain rows of data from a large XL file. Let's discuss further. - I can manage web researching and list bui More

$50 USD in 1 day
(102 Reviews)
6.1
engsalauddin

Greetings I've read your brief and it is visible that you are interested to work. I am a preferred freelancer to get enrolled with person who has 2 years' experience in different field such as Data Entry, Excel, Web More

$30 USD in 0 days
(34 Reviews)
5.3
indu0806

Hi :) I’m very much interested in your project and I think you'll find I have the skills you are looking for. I’m a graduate and my aim is to exceed your expectations by delivering high quality work. Hope you’ll have a More

$20 USD in 1 day
(60 Reviews)
5.3
choprac

Hello, Hope you are doing good, I read the job description. It’s my kind of work. I can complete the project timely and within your budget. I have an advanced knowledge of Internet research, PDF to word/excel Conver More

$30 USD in 1 day
(100 Reviews)
5.6
mdubey

Dear sir, I am very interested for this project and I can surely do this project , i work with my team who always looking for such type of project . so please sir try to give me one chance to prove my strength More

$25 USD in 1 day
(36 Reviews)
4.6
cjie

Hello, I’m an expert in data entry and I'm detail oriented and meticulous in handling of data tasks. I have a track record of timely delivery with good quality of job. I will do a quality job that will meet your requi More

$25 USD in 1 day
(19 Reviews)
4.5
GioMachaladze

Hello, I am Giorgi from Georgia. I would like to work with you. I have a big experience working in Writing Articles. If you are interested please contact me. Thank you!

$20 USD in 1 day
(14 Reviews)
3.9
awaheed03

Hi! Please share the data, I would finish it today and will send it to you. .

$15 USD in 1 day
(3 Reviews)
1.4
elenaoprescu

I'm a pregnant, soon to be (in 2 month) mother. Unfortunately, i have to stay home from work, and i am looking for an entertaining activity, so I can stop eating. At my previous job, I worked for a massive database for More

$30 USD in 1 day
(0 Reviews)
0.0